public static IRatingsContext SetupContext()
{
//var options = new DbContextOptionsBuilder<RatingsContext>().UseInMemoryDatabase(Guid.NewGuid().ToString()).Options;
var options = new DbContextOptionsBuilder <RatingsContext>().UseSqlite("Data Source=ratings.db").Options;
var dbContext = new RatingsContext(options);
dbContext.Database.EnsureCreated();
return(dbContext);
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var ctx = new RatingsContext(serviceProvider.GetRequiredService<DbContextOptions<RatingsContext>>()))
{
//Check if the Types are setup
if (ctx.RatingType.Any())
{
return; // DB has already been seeded
}
// Fill the base list of the Rating Types
var lstRatingTypes = new List<RatingType>();
lstRatingTypes.Add(new RatingType
{
//Id = 1,
Name = "Excellent"
});
lstRatingTypes.Add(new RatingType
{
//Id = 2,
Name = "Moderate"
});
lstRatingTypes.Add(new RatingType
{
//Id = 3,
Name = "Needs Improvement"
});
ctx.RatingType.AddRange(lstRatingTypes);
// Fill some sample ratings to prove it worked in the UI.
ctx.Rating.AddRange(
new Rating
{
Comments = "This was made on seeding of the database.",
CreatedDate = DateTime.Now,
RatingTypeId = 1
},
new Rating
{
Comments = "This was made as well on the seeding of the database.",
CreatedDate = DateTime.Now,
RatingTypeId = 3
}
);
ctx.SaveChanges();
}
}
public RatingsController(RatingsContext dbContext)
{
_dbContext = dbContext;
}
public RatingsController(RatingsContext context)
{
_context = context;
}
public DepartmentsController(RatingsContext context)
{
_context = context;
}
public HomeController(RatingsContext context, ILogger <HomeController> logger)
{
_context = context;
_logger = logger;
}
public ArchiveController(RatingsContext context)
{
_context = context;
}
