3-----强类型DataContext

来源:互联网 发布:团队文档库 mac 编辑:程序博客网 时间:2024/05/02 03:02

所谓的强类型DataContext 也就是继承了DataContext类

如下:

----------------

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 ctx = new DataContext("server=xxx;database=Northwind;uid=xxx;pwd=xxx");

Table<Customer> Customers = ctx.GetTable<Customer>();

GridView1.DataSource = from c in Customers where c.CustomerID.StartsWith("A") select new {顾客ID=c.CustomerID, 顾客名=c.Name, 城市=c.City};

GridView1.DataBind();

-----

对比一下可以看出 直接用DataContext需要走一步 GetTable操作。

而用强类型直接把该操作封装了。

 

原创粉丝点击