AS P.NET3.5网站开发项目实战课件作者龚赤兵任务4LINQtoSQL应用.pptVIP

Written by Lushaoming 任务4 LINQ to SQL应用 实训1——LINQ to SQL的基本应用 实训2——延迟加载 实训3——数据修改 实训4——存储过程 实训1——LINQ to SQL的基本应用 创建实体类 数据上下文DataContext 定义数据表之间的关联 基于关联的查询 创建实体类 创建实体类 1: [Table(Name = Customers)] 2: public class Customer 3: { 4: [Column(IsPrimaryKey = true)] 5: public string CustomerID; 6: 7: [Column] 8: public string City; 9: } 数据上下文DataContext 1: static void Main(string[] args) 2: { 3: DataContext db = new DataContext(@Data Source=.\sqlexpress; Initial Catalog=Northwind;Integrated Security=True); 4: 5: TableCustomer Customers = db.GetTableCustomer(); 6: 7: var q = from c in Customers where c.City == London select c; 8: 9: foreach (var cust in q) 10: Console.WriteLine(id = {0}, City = {1}, cust.CustomerID, cust.City); 11: } 数据上下文DataContext 1: public partial class Northwind : DataContext 2: { 3: public TableCustomer Customers; 4: 5: public Northwind(string connection): base(connection) {} 6: } 数据上下文DataContext 1: static void Main(string[] args) 2: { 3: Northwind db = new Northwind(@Data Source=.\sqlexpress; Initial Catalog=Northwind;Integrated Security=True); 4: 5: var Customers = db.Customers ; 6: 7: var q = from c in Customers where c.City == London select c; 8: 9: foreach (var cust in q) 10: Console.WriteLine(id = {0}, City = {1}, cust.CustomerID, cust.City); 11: } 定义数据表之间的关联 1: [Table(Name=Customers)] 2: public class Customer 3: { 4: [Column(IsPrimaryKey = true)] 5: public string CustomerID; 6: 7: [Column] 8: public string City; 9: 10: private EntitySetOrder _Orders; 11: 12: [Association(Storage=_Orders, OtherKey=CustomerID)] 13: public EntitySetOrder Orders 14: { 15: get { return this._Orders; } 16: set { this._Orders.Assign(value); } 17: } 18: } 19: 定义数据