mapo-iob-libs/EgwProxy.SqlDb/SyncStateDbContext.cs

using EgwProxy.SqlDb.DbModels;
using EgwProxy.SqlDb.Migrations;
using NLog;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace EgwProxy.SqlDb
{
    /// <summary>
    /// Classe per accesso dati SyncState del DB
    /// </summary>
    public partial class SyncStateDbContext : DbContext
    {
        private static NLog.Logger Log = LogManager.GetCurrentClassLogger();

        /// <summary>
        /// Costruttore implicito
        /// </summary>
        public SyncStateDbContext() : base("name=SyncState")
        {
            Log.Info("Init 01 SyncStateDbContext - DONE");
        }

        protected string connString = "";

        /// <summary>
        /// Costruttore da connectionString
        /// </summary>
        /// <param name="connectionString"></param>
        public SyncStateDbContext(string connectionString) : base(connectionString)
        {
            Log.Info("Init 02 SyncStateDbContext - DONE");
            connString = connectionString;
#if false
            try
            {
                // se non ci fosse... crea o migra!
                Database.CreateIfNotExists();
                Database.SetInitializer(new MyDbInitializer());
                Database.Initialize(false);
            }
            catch (Exception exc)
            {
                Log.Error(exc, "Exception during context initialization 02");
            } 
#endif
        }

        public void DbForceMigrate()
        {
            try
            {
                // se non ci fosse... crea o migra!
                //Database.Migrate();
                Database.CreateIfNotExists();
                Database.SetInitializer(new MyDbInitializer());
                Database.Initialize(true);
                Log.Info("DbForceMigrate: done!");
            }
            catch (Exception exc)
            {
                Log.Error(exc, "DbForceMigrate: Exception during context initialization 01");
            }
        }

        /// <summary>
        /// DbSet Flux Log già decodificato
        /// </summary>
        public virtual DbSet<ActTypeModel> DbSetActListType{ get; set; }
        /// <summary>
        /// DbSet dei dati stato sync DB esterni <--> locale
        /// </summary>
        public virtual DbSet<SyncStateModel> DbSetSyncState { get; set; }
        /// <summary>
        /// DbSet ActionList da MES / MACCHINA
        /// </summary>
        public virtual DbSet<ActListModel> DbSetActions { get; set; }
        /// <summary>
        /// DbSet PODL da Macchina
        /// </summary>
        public virtual DbSet<MachPODLModel> DbSetMachPODL { get; set; }
        /// <summary>
        /// DbSet PODL Req da MES
        /// </summary>
        public virtual DbSet<MesPODLReqModel> DbSetMesPodlReq { get; set; }
        /// <summary>
        /// DbSet PODL Last da MES
        /// </summary>
        public virtual DbSet<MesPODLLastModel> DbSetMesPodlLast { get; set; }
        /// <summary>
        /// DbSet Flux Log già decodificato
        /// </summary>
        public virtual DbSet<MachFluxLogModel> DbSetMachFluxLog { get; set; }
        /// <summary>
        /// DbSet Flux Log già decodificato
        /// </summary>
        public virtual DbSet<MachSigLogModel> DbSetMachEvList { get; set; }
        /// <summary>
        /// DbSet Prod Data da macchina
        /// </summary>
        public virtual DbSet<MachProdDataModel> DbSetMachProdData { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
        }
    }
}