// clears the db and reseeds with new data
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" });
var j = new Ninja
{
Name = "JulieSan",
ServedInOniwaban = false,
DateOfBirth = new DateTime(1980, 1, 1),
Clan = vtClan
};
var s = new Ninja
{
Name = "SampsonSan",
ServedInOniwaban = false,
DateOfBirth = new DateTime(2008, 1, 28),
ClanId = 1
};
var l = new Ninja
{
Name = "Leonardo",
ServedInOniwaban = false,
DateOfBirth = new DateTime(1984, 1, 1),
Clan = turtleClan
};
var r = new Ninja
{
Name = "Raphael",
ServedInOniwaban = false,
DateOfBirth = new DateTime(1985, 1, 1),
Clan = turtleClan
};
context.Ninjas.AddRange(new List<Ninja> { j, s, l, r });
var ninjaKC = new Ninja
{
Name = "Kacy Catanzaro",
ServedInOniwaban = false,
DateOfBirth = new DateTime(1990, 1, 14),
Clan = amClan
};
var muscles = new NinjaEquipment
{
Name = "Muscles",
Type = EquipmentType.Tool,
};
var spunk = new NinjaEquipment
{
Name = "Spunk",
Type = EquipmentType.Weapon
};
ninjaKC.EquipmentOwned.Add(muscles);
ninjaKC.EquipmentOwned.Add(spunk);
context.Ninjas.Add(ninjaKC);
context.SaveChanges();
context.Database.ExecuteSqlCommand(@"CREATE PROCEDURE GetOldNinjas AS SELECT * FROM Ninjas WHERE DateOfBirth<='1/1/1980'");
context.Database.ExecuteSqlCommand( @"CREATE PROCEDURE DeleteNinjaViaId @Id int AS DELETE from Ninjas Where Id = @id RETURN @@rowcount");
}
}
private static void InsertNinjaWithEquipment()
{
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
var ninja = new Ninja()
{
Name = "Joe Ortiz",
ServedInOniwaban = false,
DateOfBirth = new DateTime(1990, 1, 1),
ClanId = 1
};
var muscles = new NinjaEquipment
{
Name = "Muscles",
Type = EquipmentType.Tool
};
var spunk = new NinjaEquipment()
{
Name = "Spunk",
Type = EquipmentType.Weapon
};
context.Ninjas.Add(ninja);
ninja.EquipmentOwned.Add(muscles);
ninja.EquipmentOwned.Add(spunk);
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 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();
}
}
private static void InsertNinjaWithEquipment()
{
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
var ninja = new Ninja
{
Name = "Kacy Catanzaro" , ServedInOniwaban = true, DateOfBirth = new DateTime (1975,7,2), ClanId = 1
};
var muscles = new NinjaEquipment { Name = "Muscles", Type = EquipmentType.Blade };
var spunk = new NinjaEquipment { Name = "Spunk", Type = EquipmentType.Sword };
context.Ninjas.Add(ninja);
ninja.EquipmentOwned.Add(muscles);
ninja.EquipmentOwned.Add(spunk);
context.SaveChanges();
}
}