private static void CreateDatabase()
{
Database.SetInitializer(new DropCreateDatabaseIfModelChanges <EfDateAndTimeOfDayModelContext>());
using (EfDateAndTimeOfDayModelContext db = new EfDateAndTimeOfDayModelContext())
{
if (!db.DateTimes.Any())
{
DateTime dt = new DateTime(2015, 12, 22);
IList <DateAndTimeOfDayModel> dateTimes = Enumerable.Range(1, 5).Select(i =>
new DateAndTimeOfDayModel
{
Id = i,
Birthday = dt.AddYears(i),
EndDay = dt.AddDays(i),
DeliverDay = i % 2 == 0 ? (DateTime?)null : dt.AddYears(5 - i),
PublishDay = i % 2 != 0 ? (DateTime?)null : dt.AddMonths(5 - i),
CreatedTime = new TimeSpan(0, i, 3, 5, 79),
EndTime = i % 2 == 0 ? (TimeSpan?)null : new TimeSpan(0, 10 + i, 3 + i, 5 + i, 79 + i),
ResumeTime = new TimeSpan(0, 8, 6, 4, 3)
}).ToList();
foreach (var efDateTime in dateTimes)
{
db.DateTimes.Add(efDateTime);
}
db.SaveChanges();
}
}
}
private static void CreateDatabase()
{
Database.SetInitializer(new DropCreateDatabaseIfModelChanges<EfDateAndTimeOfDayModelContext>());
using (EfDateAndTimeOfDayModelContext db = new EfDateAndTimeOfDayModelContext())
{
if (!db.DateTimes.Any())
{
DateTime dt = new DateTime(2015, 12, 22);
IList<DateAndTimeOfDayModel> dateTimes = Enumerable.Range(1, 5).Select(i =>
new DateAndTimeOfDayModel
{
Id = i,
Birthday = dt.AddYears(i),
EndDay = dt.AddDays(i),
DeliverDay = i % 2 == 0 ? (DateTime?)null : dt.AddYears(5 - i),
PublishDay = i % 2 != 0 ? (DateTime?)null : dt.AddMonths(5 - i),
CreatedTime = new TimeSpan(0, i, 3, 5, 79),
EndTime = i % 2 == 0 ? (TimeSpan?)null : new TimeSpan(0, 10 + i, 3 + i, 5 + i, 79 + i),
ResumeTime = new TimeSpan(0, 8, 6, 4, 3)
}).ToList();
foreach (var efDateTime in dateTimes)
{
db.DateTimes.Add(efDateTime);
}
db.SaveChanges();
}
}
}