public partial class NorthwindDataContext : DataContext { public Table<Customer> Customers; public NorthwindDataContext(IDbConnection connection) : base(connection) { } public NorthwindDataContext(string connection) : base(connection) { } } |
强类型数据上下文使代码更简洁:
NorthwindDataContext ctx = new NorthwindDataContext("server=xxx;database=Northwind;uid=xxx;pwd=xxx"); GridView1.DataSource = from c in ctx.Customers where c.CustomerID.StartsWith("A") select new { 顾客ID = c.CustomerID, 顾客名 = c.Name, 城市 = c.City }; GridView1.DataBind(); |
-----------------------------------------------------
个人理解:
所谓强类型的DataContext就是继承子DataContext的自定义类,类似于工厂模式般,自己的类和实体用自己的。