ByteDecoder/Queryology

using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Logging;

namespace ByteDecoder.Queryology.Example.Models
{
    public class EfCoreContext : DbContext
    {
        private static readonly ILoggerFactory LoggerFactory = Microsoft.Extensions.Logging.LoggerFactory.Create(configure => configure.AddConsole());

        public DbSet<Book> Books => Set<Book>();
        public DbSet<Author> Authors => Set<Author>();
        public DbSet<PriceOffer> PriceOffers => Set<PriceOffer>();

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<BookAuthor>().HasKey(x => new { x.BookId, x.AuthorId });

            modelBuilder.Entity<Book>().HasData(SeedData.BooksData());
            modelBuilder.Entity<Review>().HasData(SeedData.ReviewsData());
            modelBuilder.Entity<Author>().HasData(SeedData.AuthorsData());
            modelBuilder.Entity<BookAuthor>().HasData(SeedData.BookAuthors());
            modelBuilder.Entity<PriceOffer>().HasData(SeedData.PromotionsData());
        }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) =>
         optionsBuilder
          .UseLoggerFactory(LoggerFactory)
          .EnableSensitiveDataLogging()
          .UseSqlite($"Data source=ExampleDatabase.db");
    }
}