using Microsoft.EntityFrameworkCore;
using System;
using System.Data.SqlClient;

namespace AutoBet.Db
{
    public class HorseRacingDataContext : DbContext
    {
        public DbSet<Race> Races { get; set; }
        public DbSet<Runner> Runners { get; set; }
        public DbSet<LastRun> LastRuns { get; set; }
        public DbSet<RunnerResult> RunnerResults { get; set; }
        public DbSet<OddsSnapshot> OddsSnapshots { get; set; }
        public DbSet<BetOdds> BetOdds { get; set; }
        public DbSet<Fixture> Fixtures { get; set; }

        public static string ConnectionString { get; } = GenerateConnectionString();
        private static string GenerateConnectionString()
        {
            var connBuilder = new SqlConnectionStringBuilder
            {
                IntegratedSecurity = true,
                InitialCatalog = "AutoBet.DataRecorded2",
                DataSource = ".\\SQLEXPRESS",
                ConnectTimeout = (int)TimeSpan.FromMinutes(2).TotalSeconds
            };
            return connBuilder.ToString();
        }
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            base.OnConfiguring(optionsBuilder);


            optionsBuilder.UseSqlServer(ConnectionString);
        }
    }
}