Exemplos de Chapter01.CSharp3.Sql LinqDemoDataContext em C# (CSharp)

Exemplo n.º 1

Arquivo: LinqToSql.cs Projeto: HBDLP/CSharp-in-Depth

 static void Main()
 {
     using (LinqDemoDataContext db = new LinqDemoDataContext())
     {
         var filtered = from p in db.Products
                        join s in db.Suppliers
                        on p.SupplierID equals s.SupplierID
                        where p.Price > 10
                        orderby s.Name, p.Name
             select new
         {
             SupplierName = s.Name,
             ProductName  = p.Name
         };
         foreach (var v in filtered)
         {
             Console.WriteLine("Supplier={0}; Product={1}",
                               v.SupplierName, v.ProductName);
         }
     }
 }

Exemplo n.º 2

Arquivo: LinqToSql.cs Projeto: gourdon/C-

 static void Main()
 {
     using (LinqDemoDataContext db = new LinqDemoDataContext())
     {
         var filtered = from p in db.Products
                        join s in db.Suppliers
                        on p.SupplierID equals s.SupplierID
                        where p.Price > 10
                        orderby s.Name, p.Name
                        select new
                        {
                            SupplierName = s.Name,
                            ProductName = p.Name
                        };
         foreach (var v in filtered)
         {
             Console.WriteLine("Supplier={0}; Product={1}",
                               v.SupplierName, v.ProductName);
         }
     }
 }