private void RtrieveTest() { var ctx = new AdventureCtx(); PrintMessage(Wordfiy("Print SalesOrders")); foreach (var salesOrderHeader in ctx.SalesOrderHeaders.Take(10)) { Console.WriteLine($"{salesOrderHeader.Customer.Person} {salesOrderHeader.CreditCard.CardType} {salesOrderHeader.CreditCard.CardNumber.Substring(0, 3).PadRight(20, '*')} {salesOrderHeader.SubTotal.ToString("C0")}"); } PrintMessage(Wordfiy("Print Addresses")); foreach (var address in ctx.Addresses.Take(10)) { Console.WriteLine($"{address.AddressLine1}-{address.City}"); } PrintMessage(Wordfiy("Print SalesTerritories")); foreach (var territory in ctx.SalesTerritories.Take(10)) { Console.WriteLine(territory.Name); } PrintMessage(Wordfiy("Print ProductDescriptions")); foreach (var productDescription in ctx.ProductDescriptions.Take(10)) { Console.WriteLine(productDescription.Description); } }
public virtual async Task <Customer> GetCustomerById(int customerId) { DebuggerInfo.DisplayCurrentMethod(MethodBase.GetCurrentMethod()); Customer resultData; using (_dbcontext = new AdventureCtx()) { resultData = _dbcontext.Customers.SingleOrDefault(c => c.CustomerID == customerId); } return(await Task.Run(() => resultData)); }
private void CheckMetadata() { using (var ctx = new AdventureCtx()) { var x = ctx.Addresses.Include(a => a.SalesOrderHeaders).Where(a => a.SalesOrderHeaders.Any()).FirstOrDefault().SalesOrderHeaders; if (x.Any()) { PrintMessage(x.FirstOrDefault().AccountNumber); var y = x.FirstOrDefault().SalesOrderDetails.FirstOrDefault(); PrintMessage(y.rowguid.ToString()); } } }
public virtual async Task <ResultModel <Customer> > SearchCustomer(Func <IQueryable <Customer>, IQueryable <Customer> > expression) { Console.WriteLine($" parameter {expression} is invoked"); //await Task.Delay(5000); List <Customer> resultData; using (_dbcontext = new AdventureCtx()) { resultData = expression(_dbcontext.Customers.Include("Person")).ToList(); } return(await Task.Run(() => new ResultModel <Customer> { ModelList = resultData, Search = expression.ToString() })); }
public virtual async Task <ResultModel <Customer> > GetCustomersByName(string name) { Console.WriteLine($" parameter {name} is invoked"); //await Task.Delay(5000); List <Customer> resultData; using (_dbcontext = new AdventureCtx()){ resultData = _dbcontext.Customers.Include("Person").Where(c => c.Person.FirstName.ToLower().Contains(name.ToLower()) || c.Person.LastName.ToLower().Contains(name.ToLower() )).Take(100).ToList(); } return(await Task.Run(() => new ResultModel <Customer> { ModelList = resultData, Search = name })); }
private void UpdateTest() { using (var ctx = new AdventureCtx()) { PrintMessage(Wordfiy("Update address")); var address = ctx.Addresses.FirstOrDefault(); var addresJson = JsonConvert.SerializeObject(address, Formatting.None); var clonedAddress = JsonConvert.DeserializeObject <Address>(addresJson); PrintMessage($"Address before change {address}"); address.City = "Sydney"; address.AddressLine1 = "1 Evanse Avenue"; ctx.SaveChanges(); var savedAddress = ctx.Addresses.SingleOrDefault(a => a.rowguid == address.rowguid); PrintMessage($"Address after change {savedAddress}"); savedAddress.City = clonedAddress.City; savedAddress.AddressLine1 = clonedAddress.AddressLine1; ctx.SaveChanges(); PrintMessage($"Address after restoration {savedAddress}"); } }