using System;
using System.Data;
using System.Data.Common;
class MainClass {
public static void Main(string[] args) {
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.SqlClient");
using (IDbConnection con = factory.CreateConnection()) {
con.ConnectionString = @"Data Source = .\sqlexpress;Database = Northwind; Integrated Security=SSPI";
using (IDbCommand com = con.CreateCommand()) {
com.CommandType = CommandType.StoredProcedure;
com.CommandText = "Ten Most Expensive Products";
con.Open();
using (IDataReader reader = com.ExecuteReader()) {
Console.WriteLine(Environment.NewLine);
Console.WriteLine("Price of the Ten Most Expensive Products.");
while (reader.Read()) {
Console.WriteLine(" {0} = {1}", reader["TenMostExpensiveProducts"], reader["UnitPrice"]);
}
}
}
}
}
}
|