static void Main() { var context = new SupermarketChainEntities(); var vendors = context.Vendors .OrderBy(v => v.VendorName) .Select(v => new { v.VendorName, Products = v.Products .OrderBy(p => p.ProductName) .Select(p => p.ProductName) }); var xmlreport = new XElement("report"); foreach (var vendor in vendors) { var xmlvendor = new XElement("vendor"); xmlvendor.Add(new XAttribute("name", vendor.VendorName.Trim())); xmlreport.Add(xmlvendor); foreach (var product in vendor.Products) { xmlvendor.Add(new XElement("product", product.Trim())); } } string path = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); var xmlDocument = new XDocument(xmlreport); xmlDocument.Save(path + "\\report.xml"); }
static void Main(string[] args) { var context = new SupermarketChainEntities(); var product = from vendor in context.Vendors where vendor.VendorName == "Coca-Cola" select vendor.VendorName; foreach (var p in product) { Console.WriteLine(p); } }
private static void AddVendorExpense(string vendorName, DateTime expenseDate, decimal expenseAmount) { var context = new SupermarketChainEntities(); var vendorId = context.Vendors .Where(v => v.VendorName.Trim() == vendorName) .Select(v => v.Id).First(); Expense expenseEntity = new Expense(); expenseEntity.VdendorId = vendorId; expenseEntity.Date = expenseDate; expenseEntity.Amount = expenseAmount; context.Expenses.Add(expenseEntity); context.SaveChanges(); Console.WriteLine("Added expense for vendor: {0}", vendorName); }