EVCB_OCPP.Common/EVCB_OCPP.Domain/MainDBContext.cs

namespace EVCB_OCPP.Domain
{
    using EVCB_OCPP.Domain.Models.Database;
    using Microsoft.EntityFrameworkCore;
    using System;
    using System.Linq;
    using System.Threading;
    using System.Threading.Tasks;

    public class MainDBContext : DbContext
    {
        // 您的內容已設定為使用應用程式組態檔 (App.config 或 Web.config)
        // 中的 'MainDBContext' 連接字串。根據預設，這個連接字串的目標是
        // 您的 LocalDb 執行個體上的 'EVCB_OCPP.Domain.MainDBContext' 資料庫。
        // 
        // 如果您的目標是其他資料庫和 (或) 提供者，請修改
        // 應用程式組態檔中的 'MainDBContext' 連接字串。
        public MainDBContext() : base()
        {
            //this.Configuration.LazyLoadingEnabled = false;
            //this.Database.CommandTimeout = 180;
            //this.Database.AutoTransactionBehavior = AutoTransactionBehavior.Never;
        }

        /// <summary>
        /// DB coneection set
        /// </summary>
        //public MainDBContext(string conn)
        //{
        //    this.Database.Connection.ConnectionString = conn;
        //    this.Configuration.LazyLoadingEnabled = false;
        //    this.Database.CommandTimeout = 180;
        //}
        public MainDBContext(DbContextOptions<MainDBContext> options) : base(options)
        {
            //this.Database.AutoTransactionBehavior = AutoTransactionBehavior.Never;
        }

        // 針對您要包含在模型中的每種實體類型新增 DbSet。如需有關設定和使用
        // Code First 模型的詳細資訊，請參閱 http://go.microsoft.com/fwlink/?LinkId=390109。

        public virtual DbSet<OCMF> OCMF { get; set; }

        public virtual DbSet<ConnectorStatus> ConnectorStatus { get; set; }

        public virtual DbSet<Customer> Customer { get; set; }


        public virtual DbSet<Machine> Machine { get; set; }



        public virtual DbSet<MachineConfiguration> MachineConfigurations { get; set; }

        public virtual DbSet<MachineError> MachineError { get; set; }


        public virtual DbSet<MachineOperateRecord> MachineOperateRecord { get; set; }



        public virtual DbSet<MachineVersionFile> MachineVersionFile { get; set; }



        public virtual DbSet<ServerMessage> ServerMessage { get; set; }

        public virtual DbSet<TransactionRecord> TransactionRecord { get; set; }

        public virtual DbSet<UploadFile> UploadFile { get; set; }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {

            modelBuilder.Entity<Machine>().Property(x => x.RatedPower).HasPrecision(6, 2);
            modelBuilder.Entity<Machine>().Property(x => x.Longitude).HasPrecision(10, 6);
            modelBuilder.Entity<Machine>().Property(x => x.Latitude).HasPrecision(10, 6);
            modelBuilder.Entity<ConnectorStatus>().Property(x => x.TotalEnergy).HasPrecision(10, 2);
            base.OnModelCreating(modelBuilder);

        }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            //optionsBuilder.UseSqlServer("data source=172.1.2.187;initial catalog=StandardOCPP_Main;;persist security info=True;user id=sa;password=Ph0930118811;MultipleActiveResultSets=True;App=EntityFramework");
            base.OnConfiguring(optionsBuilder);
        }
    }
}