public void SaveNewEquipment(NinjaEquipment equipment, int ninjaId) { //paying the price of not having a foreign key here. //reason #857 why I prefer foreign keys! using (var context = new NinjaContext()) { var ninja = context.Ninjas.Find(ninjaId); ninja.EquipmentOwned.Add(equipment); context.SaveChanges(); } }
public void SaveUpdatedEquipment(NinjaEquipment equipment, int ninjaId) { //paying the price of not having a foreign key here. //reason #858 why I prefer foreign keys! using (var context = new NinjaContext()) { var equipmentWithNinjaFromDatabase = context.Equipment.Include(n => n.Ninja).FirstOrDefault(e => e.Id == equipment.Id); context.Entry(equipmentWithNinjaFromDatabase).CurrentValues.SetValues(equipment); context.SaveChanges(); } }
public List <Ninja> GetQueryableNinjasWithClan(string query, int page, int pageSize) { using (var context = new NinjaContext()) { context.Database.Log = message => Debug.WriteLine(message); var linqQuery = context.Ninjas.Include(n => n.Clan); if (!string.IsNullOrEmpty(query)) { linqQuery = linqQuery.Where(n => n.Name.Contains(query)); } if (page > 0 && pageSize > 0) { linqQuery = linqQuery.OrderBy(n => n.Name).Skip(page - 1).Take(pageSize); } return(linqQuery.ToList()); } }
public static void NewDbWithSeed() { Database.SetInitializer(new DropCreateDatabaseAlways <NinjaContext>()); using (var context = new NinjaContext()) { if (context.Ninjas.Any()) { return; } var vtClan = context.Clans.Add(new Clan { ClanName = "Vermont Clan" }); var turtleClan = context.Clans.Add(new Clan { ClanName = "Turtles" }); var amClan = context.Clans.Add(new Clan { ClanName = "American Ninja Warriors" }); } }