创建对象模型

1. using System;
2. using System.Collections.Generic;
3. using System.Linq;
4. using System.Text;
5. using System.Data.Linq;
6. using System.Data.Linq.Mapping;
8. namespace ConsoleApplication1
9. {
10.     [Table (Name="Customers")]
11.     public class Customer
12.     {
13.         private string _CustomerID;
14.         [Column(IsPrimaryKey=true , Storage="_CustomerID")]
15.         public string CustomerID
16.         {
17.             get
18.             { return this._CustomerID; }
19.             set
20.             {this._CustomerID=value;}
21.         }
22.         private string _City;
23.         [Column(Storage = "_City")]
24.         public string City
25.         {
26.             get
27.             { return this._City; }
28.             set
29.             { this._City = value; }
30.         }
31.         private EntitySet<order> _Orders;
32.         public Customer()
33.         {
34.             this._Orders=new EntitySet<order>();
35.         }
36.         [Association(Storage="_Orders",OtherKey="CustomerID")]
37.         public EntitySet<order> Orders
38.         {
39.             get {return this._Orders;}
40.             set{this._Orders.Assign(value);}
41.         }
43.     }
47.     [Table(Name = "Orders")]
48.     public class order
49.     {
50.         private int _OrderID = 0;
51.         private string _CustomerID;
52.         private EntityRef<Customer> _Customer;
53.         public order()
54.         {
55.             this._Customer = new EntityRef<Customer>();
56.         }
57.         [Column(Storage = "_OrderID", DbType = "Int NOT NULL IDENTITY", IsPrimaryKey = true, IsDbGenerated = true)]
58.         public int OrderID
59.         {
60.             get { return this._OrderID; }
61.         }
62.         [Column(Storage = "_CustomerID", DbType = "NChar(5)")]
63.         public string CustomerID
64.         {
65.             get { return this._CustomerID; }
66.             set { this._CustomerID = value; }
67.         }
68.         [Association(Storage = "_Customer", ThisKey = "CustomerID")]
69.         public Customer Customer
70.         {
71.            get { return this._Customer.Entity;}
72.             set { this._Customer.Entity = value; }
73.         }
74.     }
75.     class Program
76.     {
77.         static void Main(string[] args)
78.         {
79.             DataContext db = new DataContext("server=(Local);database=northwind;uid=sa;pwd=sa");
80.             Table<Customer> Customers = db.GetTable<Customer>();
81.             //db.Log = Console.Out;   //输入SQL语句
82.             IQueryable<Customer> custQuery =
83.                 from cust in Customers
84.                 where cust.Orders.Any()
85.                 select cust;
86.             foreach (Customer custobj in custQuery)
87.             {
88.                 Console.WriteLine("ID={0},Qty={1}", custobj.CustomerID, custobj.Orders.Count());
89.             }
90.             Console.WriteLine("请按任一键退出");
91.             Console.ReadKey();
92.         }
93.     }
94. }