LINQ实战一

 1
 2
 3namespace LinqConsoleApp
 4{
 5    [Table(Name = "Customers")]
 6    public class Customer
 7    {
 8             private string _CustomerID;
 9
            [Column(IsPrimaryKey=true, Storage="_CustomerID")]
            public string CustomerID
            {
                get
                {
                    return this._CustomerID;
                }
                set
                {
                    this._CustomerID = value;
                }

            }

            private string _City;
            [Column(Storage="_City")]
            public string City
            {
                get
                {
                    return this._City;
                }
                set
                {
                    this._City=value;
                }
            }

         


         

           
    }


    
    class Program
    {
        static void Main(string[] args)
        {
            // Use a connection string.
            DataContext db = new DataContext("server=.;database=Northwind;uid=sa;pwd=local;");

            // Get a typed table to run queries.
            Table<Customer> Customers = db.GetTable<Customer>();
            // Attach the log to show generated SQL.
            db.Log = Console.Out;

            // Query for customers in London.
            IQueryable<Customer> custQuery = from cust in Customers where cust.City == "London" select cust;


            foreach (Customer cust in custQuery)
            {
                Console.WriteLine("ID={0}, City={1}", cust.CustomerID,cust.City);
            }

            // Prevent console window from closing.
            Console.ReadLine();

        }
    }
}