/// <summary>
/// FINDS ALL THE NAMES THAT CONTAIN SHAN
/// </summary>
private static void FindAName()
{
using (var context = new NinjaContext())
{
var ninjas = context.Ninjas.Where(x=>x.Name.Contains("Shan"));
}
}
public NinjaEquipment GetEquipmentById(int id)
{
using (var context = new NinjaContext())
{
return context.Equipment.Find(id);
}
}
public IEnumerable GetClanList()
{
using (var context = new NinjaContext()) {
return context.Clans.AsNoTracking().OrderBy(c => c.ClanName)
.Select(c => new { c.Id, c.ClanName }).ToList();
}
}
public ConnectedRepository()
{
_context = new NinjaContext();
_ninjas = _context.Ninjas;
_clans = _context.Clans;
_equipment = _context.Equipment;
}
private static void InsertMultipleNinjas()
{
var ninja2 = new Ninja
{
Name = "SampsonSan",
ServedInOniwaban = false,
DateOfBirth = new DateTime(2008, 1, 28),
ClanId = 1
};
var ninjas22 = new Ninja
{
Name = "SampsonSan",
ServedInOniwaban = false,
DateOfBirth = new DateTime(2008, 1, 28),
ClanId = 1
};
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
context.Ninjas.AddRange(new List<Ninja> { ninja2, ninjas22});
context.SaveChanges();
}
}
private static void SimpleNinjaGraphQuery()
{
Ninja ninja;
var LoadingType = "lazy";
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
switch (LoadingType)
{
case "eager":
ninja = context.Ninjas
.Include(n => n.EquipmentOwned)
.FirstOrDefault(n => n.Name == "Joe Ortiz");
break;
case "explicit":
ninja = context.Ninjas.FirstOrDefault(n => n.Name.StartsWith("Joe Ortiz"));
Console.WriteLine("Ninja Retrieved:" + ninja.Name);
context.Entry(ninja).Collection(n => n.EquipmentOwned).Load();
break;
case "lazy":
ninja = context.Ninjas.FirstOrDefault(n => n.Name.StartsWith("Joe Ortiz"));
Console.WriteLine("Ninja Retrieved:" + ninja.Name);
Console.WriteLine("Ninja Equipment Count: " + ninja.EquipmentOwned.Count());
//mark EquipmentOwned property as virtual. Be careful with performance issues.
break;
}
}
}
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 List<Ninja> GetNinjasWithClan()
{
using (var context = new NinjaContext()) {
//return context.Ninjas.Include(n => n.Clan).ToList();
return context.Ninjas.AsNoTracking().Include(n => n.Clan).ToList();
}
}
private static void DeleteNinja()
{
Ninja ninja;
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
// SELECT TOP 1 FROM Ninjas
ninja = context.Ninjas.FirstOrDefault();
}
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
//context.Ninjas.Attach(ninja);
//context.Ninjas.Remove(ninja); // new context, without Attach ninja not found
context.Entry(ninja).State = EntityState.Deleted;
// DELETE Ninjas WHERE Id = 8
context.SaveChanges();
}
//using (var context = new NinjaContext())
//{
// context.Database.Log = Console.WriteLine;
// var ninja = context.Ninjas.FirstOrDefault();
// context.Ninjas.Remove(ninja);
// context.SaveChanges();
//}
}
public Ninja GetNinjaById(int id)
{
using (var context = new NinjaContext()) {
return context.Ninjas.Find(id);
// return context.Ninjas.AsNoTracking().SingleOrDefault(n => n.Id == id);
}
}
public Ninja GetNinjaWithEquipment(int id)
{
using (var context = new NinjaContext()) {
return context.Ninjas.AsNoTracking().Include(n => n.EquipmentOwned)
.FirstOrDefault(n => n.Id == id);
}
}
public void DeleteNinja(int ninjaId)
{
using (var context = new NinjaContext()) {
var ninja = context.Ninjas.Find(ninjaId);
context.Entry(ninja).State = EntityState.Deleted;
context.SaveChanges();
}
}
private static void SimpleNinjaQueries()
{
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
var query = context.Ninjas;
var ninjas = query.ToList();
}
}
public List<Ninja> GetNinjasWithClan()
{
using (var context = new NinjaContext())
{
return context.Ninjas
.AsNoTracking() // PERFORMANCE: do not provide tracking information as we will destroy context
.Include(n => n.Clan)
.ToList();
}
}
private static void DeleteNinja()
{
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
var ninja = context.Ninjas.FirstOrDefault();
context.Ninjas.Remove(ninja);
context.SaveChanges();
}
}
// use a stored procedure to delete an entry in a single db call
private static void DeleteNinjaViaStoredProcedure()
{
var keyVal = 3;
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
context.Database.ExecuteSqlCommand("exec DeleteNinjaViaId {0}", keyVal);
}
}
private static void ProjectQuery()
{
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
var ninjas = context.Ninjas
.Select(n => new {n.Name, n.DateOfBirth, n.EquipmentOwned})
.ToList();
}
}
private static void DeleteNinjaWithKeyValue()
{
var keyval = 1;
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
var ninja = context.Ninjas.Find(keyval);
context.Ninjas.Remove(ninja);
context.SaveChanges();
}
}
/// <summary>
/// THIS WILL RETURN NULL or FIRST IF YOU USE FIRST
/// </summary>
private static void FindByDateOfBirth()
{
using (var context = new NinjaContext())
{
//FirstOrDefault will retrun a null if there are no results
var ninjas = context.Ninjas.Where(x => x.DateOfBirth == new DateTime(1980,1,1)).FirstOrDefault();
//This will throw exception if there are no results
// var ninjas = context.Ninjas.Where(x => x.DateOfBirth == new DateTime(1980, 1, 1)).First();
}
}
private static void DeleteNinja()
{
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
var n = context.Ninjas.FirstOrDefault();
context.Entry(n).State = EntityState.Modified;
context.Ninjas.Remove(n);
context.SaveChanges();
}
}
private static void QueryAndUpdateNinja()
{
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
var query = context.Ninjas;
var ninja = query.FirstOrDefault();
ninja.ServedInOniwaban = !ninja.ServedInOniwaban;
context.SaveChanges();
}
}
public Ninja GetNinjaWithEquipmentAndClan(int id)
{
using (var context = new NinjaContext())
{
return(context
.Ninjas
.AsNoTracking()
.Include(n => n.EquipmentOwned)
.Include(n => n.Clan)
.FirstOrDefault(n => n.Id == id));
}
}
public IEnumerable GetClans()
{
using (var context = new NinjaContext())
{
return(context
.Clans
.AsNoTracking()
.OrderBy(c => c.ClanName)
.Select(c => new { c.Id, c.ClanName })
.ToList());
}
}
public void SaveUpdatedEquipment(NinjaEquipment equipment, int postId)
{
//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.Post).FirstOrDefault(e => e.Id == equipment.Id);
context.Entry(equipmentWithNinjaFromDatabase).CurrentValues.SetValues(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 static void NewDBWithSeed()
{
Database.SetInitializer(new DropCreateDatabaseAlways <NinjaContext>());
using (var context = new NinjaContext())
{
if (context.Ninjas.Any())
{
return;
}
var vtclas = context.Clans.Add(new Clan {
ClanName = "White Clan"
});
}
}
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 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());
}
}
private static void InsertNinja()
{
var ninja = new Ninja
{
Name = "SampsonSan",
ServedInOniwaban = false,
DateOfBirth = new DateTime(2008, 1, 28),
ClanId = 1
};
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
context.Ninjas.Add(ninja);
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();
}
}
private static void DeleteNinja()
{
Ninja ninja;
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
ninja = context.Ninjas.FirstOrDefault();
//context.Ninjas.Remove(ninja);
//context.SaveChanges();
}
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
//context.Ninjas.Attach(ninja);
//context.Ninjas.Remove(ninja);
context.Entry(ninja).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void SaveUpdatedEquipment(NinjaEquipment equipment, int ninjaId)
{
using (var context = new NinjaContext())
{
// again, need to load existing entity as no FK in model and Ninja marked as [Required]
// ...and again, this could be avoided by adding a NinjaId to NinjaEquipemnt!
var equipmentWithNinjaFromDb = context
.Equipment
.Include(e => e.Ninja)
.FirstOrDefault(e => e.Id == equipment.Id);
context
.Entry(equipmentWithNinjaFromDb)
.CurrentValues
.SetValues(equipment);
context.SaveChanges();
}
}
private static void QueryAndUpdateNinjaDisconnected()
{
Ninja ninja;
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
var query = context.Ninjas;
ninja = query.FirstOrDefault();
}
ninja.ServedInOniwaban = !ninja.ServedInOniwaban;
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
context.Ninjas.Attach(ninja);
context.Entry(ninja).State = EntityState.Modified;
context.SaveChanges();
}
}
//
// INSERT
//
private static void InsertNinja()
{
var ninja = new Ninja
{
Name = "TerriSan", ServedInOniwaban = false, DateOfBirth = new DateTime(1980,1,1), ClanId = 5
};
var ninja2 = new Ninja
{
Name = "JulieLerman", ServedInOniwaban = false, DateOfBirth = new DateTime(1970, 1, 1), ClanId = 5
};
//now lets use EF to insert this object
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
//context.Ninjas.Add(ninja);
//context.Ninjas.Add(ninja2);
context.Ninjas.AddRange(new List<Ninja> { ninja, ninja2 });
context.SaveChanges();
}
}
private static void InsertMultipleNinjas()
{
var ninja1 = new Ninja
{
Name = "Leonardo",
ServedInOniwaban = false,
DateOfBirth = new DateTime(1984, 1, 1),
ClanId = 1
};
var ninja2 = new Ninja
{
Name = "Raphael",
ServedInOniwaban = false,
DateOfBirth = new DateTime(1985, 1, 1),
ClanId = 1
};
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
context.Ninjas.AddRange(new List<Ninja> { ninja1, ninja2 });
context.SaveChanges();
}
}
private static void InsertNinja()
{
var n = new Ninja
{
Name = "ChrisSan",
ServedInOniwaban = false,
DatOfBirth = new DateTime(1946, 4, 4),
ClanId = 1
};
var n2 = new Ninja
{
Name = "BijanSan",
ServedInOniwaban = false,
DatOfBirth = new DateTime(1993, 4, 4),
ClanId = 1
};
using (var context = new NinjaContext())
{
context.Database.Log = Console.WriteLine;
context.Ninjas.Add(n);
context.Ninjas.Add(n2);
context.SaveChanges();
}
}
public NinjaEquipment GetEquipmentById(int id)
{
using (var context = new NinjaContext()) {
return(context.Equipment.Find(id));
}
}
// 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");
}
}
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");
}
}
