MafiaTelegramBot/MafiaTelegramBot/DataBase/MafiaDataBase.cs

using MafiaTelegramBot.DataBase.Entity;
using MafiaTelegramBot.Resources;
using Microsoft.EntityFrameworkCore;

namespace MafiaTelegramBot.DataBase
{
    public class MafiaDataBase : DbContext
    {
        private MafiaDataBase() { }
        private static MafiaDataBase _instance;

        public static MafiaDataBase GetInstance()
        {
            if(_instance!=null) return _instance;
            _instance = new MafiaDataBase();
            return _instance;
        }

        public DbSet<UserEntity> Users { get; set; }
        public DbSet<StatisticsEntity> Statistics { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseMySQL(
                $"server={AppSettings.IpAddress};" +
                $"port={AppSettings.Port};" +
                $"database={AppSettings.Database};" +
                $"uid={AppSettings.Uid};" +
                $"pwd={AppSettings.Pwd}"
            );
        }
        
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<StatisticsEntity>()
                .HasKey(s => new {s.UserId, s.Role});
        }
    }
}