81 lines
2.7 KiB
C#
81 lines
2.7 KiB
C#
using Liman.CadCam.DbModel;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using NLog;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
|
|
namespace Liman.CadCam
|
|
{
|
|
public partial class LicManMdbContext : DbContext
|
|
{
|
|
public LicManMdbContext()
|
|
{
|
|
// default
|
|
connString = DbConfig.CONNECTION_STRING;
|
|
}
|
|
|
|
public LicManMdbContext(string currConnString)
|
|
{
|
|
connString = currConnString;
|
|
}
|
|
|
|
public virtual DbSet<KeyModel> DbSetKeys { get; set; } = null!;
|
|
public virtual DbSet<LicenceModel> DbSetLicences { get; set; } = null!;
|
|
public virtual DbSet<ProductModel> DbSetProducts{ get; set; } = null!;
|
|
|
|
public void DbForceMigrate()
|
|
{
|
|
try
|
|
{
|
|
// se non ci fosse... crea o migra!
|
|
Database.Migrate();
|
|
Log.Info("DbForceMigrate: done!");
|
|
}
|
|
catch (Exception exc)
|
|
{
|
|
Log.Error(exc, "DbForceMigrate: Exception during context initialization 01");
|
|
}
|
|
}
|
|
|
|
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
|
|
{
|
|
if (!optionsBuilder.IsConfigured)
|
|
{
|
|
// commentato x test su cluster in ufficio
|
|
#if DEBUG
|
|
//connString = "Server=localhost;port=3306;database=MagMan_000470;uid=MagMan_DbUser;pwd=viad@nte16!;sslmode=None;";
|
|
////connString = "Server=mdb03.ufficio;port=3306;database=MagMan_000470;uid=MagMan_DbUser;pwd=viad@nte16!;sslmode=None;";
|
|
#endif
|
|
var serverVersion = DbConfig.MysqlServerVersion(connString);
|
|
optionsBuilder.UseMySql(connString, serverVersion, options => options.EnableRetryOnFailure(
|
|
maxRetryCount: 5,
|
|
maxRetryDelay: TimeSpan.FromSeconds(10),
|
|
errorNumbersToAdd: null)
|
|
);
|
|
}
|
|
}
|
|
|
|
protected override void OnModelCreating(ModelBuilder modelBuilder)
|
|
{
|
|
foreach (var relationship in modelBuilder.Model.GetEntityTypes().SelectMany(e => e.GetForeignKeys()))
|
|
{
|
|
relationship.DeleteBehavior = DeleteBehavior.Restrict;
|
|
}
|
|
|
|
//modelBuilder.Entity<KeyModel>()
|
|
// .HasKey(c => new { c.Family, c.ValueOriginal });
|
|
|
|
//modelBuilder.Seed();
|
|
|
|
OnModelCreatingPartial(modelBuilder);
|
|
}
|
|
|
|
private static NLog.Logger Log = LogManager.GetCurrentClassLogger();
|
|
private string connString = "";
|
|
|
|
partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
|
|
}
|
|
} |