public void Run() { ConsoleUtility.PrintInfo(".net 3.5 querying objects using linq to xml with a query expression."); string text = string.Empty; using (var db = new LinqDemoDataContext()) { if (db.Products.Count() == 0) { ConsoleUtility.PrintInfo("Populating products to database..."); var entities = Model.Product.GetSampleProducts().Select(item => new Edward.Wilde.CSharp.Features.Querying.net_3.Product() { Id = item.Id, Name = item.Name, SupplierId = item.SupplierId, Price = item.Price }); db.Products.InsertAllOnSubmit(entities); } if (db.Suppliers.Count() == 0) { ConsoleUtility.PrintInfo("Populating suppliers to database..."); var entities = Model.Supplier.GetSampleSuppliers().Select(item => new Edward.Wilde.CSharp.Features.Querying.net_3.Supplier() { Id = item.Id, Name = item.Name }); db.Suppliers.InsertAllOnSubmit(entities); } var items = from p in db.Products join s in db.Suppliers on p.SupplierId equals s.Id where p.Price > 10 orderby s.Name select new { Name = p.Name, Price = p.Price, SupplierName = s.Name }; text = items.ToStringTable(new[] { "Name", "Price", "Supplier" }, item => item.Name, item => item.Price, item => item.SupplierName); db.SubmitChanges(); ConsoleUtility.PrintSuccess(text); } ConsoleUtility.BlankLine(); }
public void Run() { ConsoleUtility.PrintInfo(".net 3.5 querying objects using linq to xml with a query expression."); string text = string.Empty; using (var db = new LinqDemoDataContext()) { if (db.Products.Count() == 0) { ConsoleUtility.PrintInfo("Populating products to database..."); var entities = Model.Product.GetSampleProducts().Select( item=>new Edward.Wilde.CSharp.Features.Querying.net_3.Product() { Id = item.Id, Name = item.Name, SupplierId = item.SupplierId, Price = item.Price}); db.Products.InsertAllOnSubmit(entities); } if (db.Suppliers.Count() == 0) { ConsoleUtility.PrintInfo("Populating suppliers to database..."); var entities = Model.Supplier.GetSampleSuppliers().Select(item => new Edward.Wilde.CSharp.Features.Querying.net_3.Supplier() { Id = item.Id, Name = item.Name}); db.Suppliers.InsertAllOnSubmit(entities); } var items = from p in db.Products join s in db.Suppliers on p.SupplierId equals s.Id where p.Price > 10 orderby s.Name select new {Name = p.Name, Price = p.Price, SupplierName = s.Name}; text = items.ToStringTable(new[] { "Name", "Price", "Supplier" }, item => item.Name, item => item.Price, item => item.SupplierName); db.SubmitChanges(); ConsoleUtility.PrintSuccess(text); } ConsoleUtility.BlankLine(); }