ASP.net中访问数据库的几种方式

ADO.NET中,我们会用.NET提供的SqlConnection, SqlCommand, SqlDataAdapter，SqlReader, DataSet, 和 DataTable等来访问操作数据库 :

//使用SqlDataAdapter填充DataSet
using (SqlConnection conn = new SqlConnection("********"))
            {
                DataSet ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Customers", conn);
                da.Fill(ds);
            }

//使用SqlDataReader读取数据
using (SqlConnection connection = new SqlConnection("*********"))
            {
                connection.Open();
                SqlCommand command = connection.CreateCommand();
                command.CommandText = @"SELECT Name, Country FROM Customers WHERE City = @City";
                command.Parameters.AddWithValue("@City", "Paris");
                                using (SqlDataReader reader = command.ExecuteReader())
                                {
                                                while (reader.Read())
                                                    {
                                                                string name = reader.GetString(0);
                                                                string country = reader.GetString(1);
                                                     }
                                }
                }

 

//使用Linq可能就是如下这样一个写法（该处只是简单举例，不一定能正确运行）
//查询集成到编程语言中
  DataContext db = new DataContext("********");
  var getData = from customer in db.GetTable ()
  where customer.City == "Pairs"
  select new { customer.Name, customer.Country };