public SessionsController(DatabaseAsServiceContext context)
{
_context = context;
}
public KeywordsController(DatabaseAsServiceContext context)
{
_context = context;
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new DatabaseAsServiceContext(serviceProvider.GetRequiredService <DbContextOptions <DatabaseAsServiceContext> >()))
{
// Look for any data in the database.
if (context.Sessions.Any() || context.Keywords.Any() || context.SessionKeywordMappings.Any())
{
return; // DB has been seeded
}
context.Sessions.AddRange(
new Session
{
Title = "Session 1",
},
new Session
{
Title = "Session 2",
},
new Session
{
Title = "Session 3",
}
);
context.Keywords.AddRange(
new Keyword {
Value = "Keyword 1"
},
new Keyword {
Value = "Keyword 2"
},
new Keyword {
Value = "Keyword 3"
},
new Keyword {
Value = "Keyword 4"
}
);
context.SaveChanges();
var s1 = context.Sessions.First();
var s2 = context.Sessions.Skip(1).First();
var s3 = context.Sessions.Last();
var k1 = context.Keywords.First();
var k2 = context.Keywords.Skip(1).First();
var k3 = context.Keywords.Skip(2).First();
var k4 = context.Keywords.Last();
context.SessionKeywordMappings.AddRange(
new SessionKeywordMapping {
SessionId = s1.Id, KeywordId = k1.Id
},
new SessionKeywordMapping {
SessionId = s1.Id, KeywordId = k2.Id
},
new SessionKeywordMapping {
SessionId = s2.Id, KeywordId = k2.Id
},
new SessionKeywordMapping {
SessionId = s2.Id, KeywordId = k3.Id
},
new SessionKeywordMapping {
SessionId = s3.Id, KeywordId = k3.Id
},
new SessionKeywordMapping {
SessionId = s3.Id, KeywordId = k4.Id
}
);
context.SaveChanges();
}
}
