public Cake GetCakeByID(int cakeID) { Cake cake; try { using (EntityContext context = new EntityContext()) { var query = from c in context.Cake .Include(c => c.CakePhoto) .Include(c => c.Rate) //.Include(c => c.Ingredient) //.Include(c=>c.Ingredient.Select(i=>i.Unit)) where c.CakeID == cakeID select c; cake = query.FirstOrDefault(); } } catch (Exception) { throw; } return cake; }
public static Cake GetAllCakesByCakeID(int cakeID) { List<ICollection> list = new List<ICollection>(); Cake cake; try { using (EntityContext context = new EntityContext()) { var query1 = from c in context.Cake.Include(c => c.CakePhoto) select c; var query = from c in context.Cake //where c.CakeID == cakeID select new { cake = c , CakePhoto = c.CakePhoto }; list.Add(query.Select(a => a.cake).ToList()); list.Add(query.Select(b => b.CakePhoto).ToList()); cake = query1.FirstOrDefault(); } } catch (Exception) { throw; } return cake; }
public List<ICollection> GetAllCakesEager() { try { List<ICollection> list = new List<ICollection>(); using (EntityContext context = new EntityContext()) { var cakeList = (from i in context.Cake select i).ToList(); list.Add(cakeList); var rateList = (from i in context.Rate select i).ToList(); list.Add(rateList); var cakePhotoList = (from i in context.CakePhoto select i).ToList(); list.Add(cakePhotoList); return list; //context.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); return null; } }
public static List<Cake> GetAllCakes() { try { using (EntityContext context = new EntityContext()) { return (from i in context.Cake select i).ToList(); //context.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); throw; } }
public List<Cake> GetAllCakes() { try { using (EntityContext context = new EntityContext()) { var query = (from c in context.Cake .Include(c=>c.CakePhoto) .Include(c=>c.Rate) select c).ToList(); return query; } } catch (Exception ex) { Console.WriteLine(ex.Message); throw; } }
public static List<ICollection> GetAllCakesEager() { List<ICollection> list = new List<ICollection>(); using (EntityContext context = new EntityContext()) { var cakeList = (from i in context.Cake select i).ToList(); list.Add(cakeList); var rateList = (from i in context.Rate select i).ToList(); list.Add(rateList); var cakePhotoList = (from i in context.CakePhoto select i).ToList(); list.Add(cakePhotoList); return list; //context.SaveChanges(); } }
static void Main(string[] args) { //Database.SetInitializer(new DropCreateDBWithSeedData()); //Database.SetInitializer<EntityContext>(null); using (EntityContext context = new EntityContext()) { //context.Cake.Add(new Cake() { CakeID = 1, TimeStamp = DateTime.Now, UserID = 1 }); //context.Cake.Add(new Cake() { CakeID = 2, TimeStamp = DateTime.Now, UserID = 12 }); //context.Cake.Add(new Ingredient() { }); //context.SaveChanges(); var i = context.Cake.ToList(); } //var a = GetAllCakesEager(); //var t = GetAllCakesByCakeID(1); var a = GetIngredientsByCakeID(4); }
public static List<Ingredient> GetIngredientsByCakeID(int cakeID) { List<Ingredient> ingredientList; try { using (EntityContext context = new EntityContext()) { var query = from i in context.Ingredient .Include(i => i.Unit) where i.Cake.Contains(context.Cake.Where(c => c.CakeID == cakeID).FirstOrDefault()) select i; ingredientList = query.ToList(); } } catch (Exception) { throw; } return ingredientList; }