泛型与序列化

private IList<CustomersM> GetAllCustomers()

{

??? IList<CustomersM> customer = new List<CustomersM>();

??? using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["cc_2005"].ConnectionString))

??? {

??????? connection.Open();

??????? SqlCommand command = new SqlCommand("SELECT? [CompanyName],[ContactName],[ContactTitle],[Address],[City] FROM [Customers]",connection);

??????? SqlDataReader sdr=command.ExecuteReader(CommandBehavior.CloseConnection);

??????? while (sdr.Read())

??????? {

??????????? //实体类中没有初始化属性的构造函数

??????????? /*CustomersM m = new CustomersM();

??????????? m.CompanyName = sdr[0].ToString();

??????????? m.ContactName = sdr[1].ToString();

??????????? m.ContactTitle = sdr[2].ToString();

??????????? m.Address = sdr[3].ToString();

??????????? m.City = sdr[4].ToString();

???????????? *

???????????? */

??????????? //实体类中有初始化属性的构造函数

??????????? CustomersM m = new CustomersM(sdr[0].ToString(),sdr[1].ToString(),sdr[2].ToString(),sdr[3].ToString(),sdr[4].ToString());

??????????? customer.Add(m);

??????? }

??????? return customer;

??? }

}

?

3.这样GetAllCustomers就可以绑定到GridView,DropDownList等控件上了。

注意：IList是不能序列化的，因此当需要序列化的时候(如：webservice，由于webservice中传递的对象都是可以序列化的)必须使用System.Collections.ObjectModel.Collection< >

?

代码如下：

private System.Collections.ObjectModel.Collection<CustomersM> GetCustomers()

{

??? System.Collections.ObjectModel.Collection<CustomersM> customer = new System.Collections.ObjectModel.Collection<CustomersM>();

??? using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["cc_2005"].ConnectionString))

??? {

??????? connection.Open();

??????? SqlCommand command = new SqlCommand("SELECT? [CompanyName],connection);

??????? SqlDataReader sdr = command.ExecuteReader(CommandBehavior.CloseConnection);

??????? while (sdr.Read())

??????? {

??????????? CustomersM m = new CustomersM(sdr[0].ToString(),sdr[4].ToString());

??????????? customer.Add(m);

??????? }

??????? return customer;

??? }

}

?

在webservice中如果把上面两个调用数据库的方法搬过去（好多命名空间要添加），使用IList<>类型的就会报错，“IList不能序列化接口”，而使用Collection<>的就可以正常使用.