public void GivenContextWhenDescriptionsAccessedThenDoesNotThrowErrors() { using (var ctx = new FoodContext()) { var listOfFoodDescriptions = ctx.FoodDescriptions.ToList(); Assert.IsNotNull(listOfFoodDescriptions); } }
public ActionResult FoodDescriptions([DataSourceRequest]DataSourceRequest request) { try { using (var context = new FoodContext()) { return Json(context.FoodDescriptions.ToDataSourceResult(request), JsonRequestBehavior.AllowGet); } } catch (Exception ex) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest, ex.Message); } }
private static void Main() { var parse = "FOOD_DES.txt".AsEnumerableLinesForFile().ToList(); Console.WriteLine("Parsing {0} food descriptions.", parse.Count()); using (var context = new FoodContext()) { if (context.FoodDescriptions.Any()) { Console.WriteLine("Food descriptions already exist."); } else { foreach (var item in parse.Select(description => description.Split('^')) .Select(parts => new FoodDescription { Number = parts[0].AsCleanField(), Group = parts[1].AsCleanField(), Description = parts[2].AsCleanField(), Name = parts[3].AsCleanField(), ProteinFactor = parts[11].SafeDecimal(), FatFactor = parts[12].SafeDecimal(), CarbFactor = parts[13].SafeDecimal(), SomeDate = DateTimeOffset.Now })) { context.FoodDescriptions.Add(item); Console.Write("."); } Console.WriteLine("Saving changes..."); context.SaveChanges(); Console.WriteLine("Done!"); } } Console.ReadLine(); }