using Microsoft.EntityFrameworkCore;

namespace Sales
{
    public class SalesDbContext : DbContext
    {
        public DbSet<SalesProduct> Products { get; set; }
        
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            base.OnConfiguring(optionsBuilder);
            optionsBuilder.UseSqlite("Data Source=sales.db");
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);
            modelBuilder.Entity<SalesProduct>().HasKey(product => product.Sku);
        }
    }

    public class SalesProduct
    {
        public string Sku { get; set; }
        public decimal Price { get; set; }
        public bool ForSale { get; set; }
        public bool FreeShipping { get; set; }
    }
}