public IEnumerable<string> Run()
{
_context = new FamilyMembersWithFluentConfiguration();
var kids = _context.Kids;
foreach(var kid in kids)
{
if(kid.Birthday.HasValue)
{
kid.Birthday = kid.Birthday.Value.AddDays(20);
}
}
//so by adding 20 days whose birth day changed?
foreach(var k in _context.Kids)
{
var birthDayProperty = _context.Entry(k).Property(x => x.Birthday);
if(birthDayProperty.IsModified)
{
if(birthDayProperty.OriginalValue.Value.Month != birthDayProperty.CurrentValue.Value.Month)
{
Log("Birthday month changed for {0} from {1} to {2}", k.Name, birthDayProperty.OriginalValue,
birthDayProperty.CurrentValue);
}
}
}
return _messages;
}
public IEnumerable<string> Run()
{
Database.SetInitializer(new FullOrtmanFamilyInitializer());
var context = new FamilyMembersWithFluentConfiguration();
context.Database.Initialize(true);
return Enumerable.Empty<string>();
}
public IEnumerable<string> Run()
{
_context = new FamilyMembersWithFluentConfiguration();
var kidsWhosNamesBeginWithC = from d in _context.Dads
from k in d.Kids
where k.Name.StartsWith("C")
select k.Name;
Log("There are {0} kids whose names begin with 'C' ({1})",kidsWhosNamesBeginWithC.Count(),String.Join(",",kidsWhosNamesBeginWithC));
var kidsWhoAreAlsoDads = from d in _context.Dads
join k in _context.Kids on d.FirstName equals k.Name
select d.FirstName;
Log("There are {0} kids who are dads ({1})",kidsWhoAreAlsoDads.Count(),String.Join(",",kidsWhoAreAlsoDads));
Log("Inefficient count of kids per dad");
foreach(var dad in _context.Dads)
{
Log("{0} has {1} kids", dad.FirstName, dad.Kids.Count);
}
Log("Efficient count of kids per dad");
foreach(var dad in _context.Dads.Include(x => x.Kids))
{
Log("{0} has {1} kids", dad.FirstName, dad.Kids.Count);
}
_context.SaveChanges();
return Enumerable.Empty<string>();
}
public IEnumerable<string> Run()
{
var context = new FamilyMembersWithFluentConfiguration();
//the old way you used to do it
var chris_first = (from d in context.Dads
where d.ID == 1
select d).First();
var secondContext = new FamilyMembersWithFluentConfiguration();
var chris_by_id = secondContext.Dads.Find(1);
return Enumerable.Empty<string>();
}
