public void Setup()
{
//DbContextOptionsBuilder dbContextOptionsBuilder = new DbContextOptionsBuilder();
//dbContextOptionsBuilder.UseLazyLoadingProxies(true);
//if (IsMSSQL)
//{
// dbContextOptionsBuilder.UseSqlServer(ConnectionString);
//}
//else
//{
// dbContextOptionsBuilder.UseMySql(ConnectionString);
//}
DbContext = GetContext(ConnectionString);
// DbContext = new MicrotingDbMs(dbContextOptionsBuilder.Options);
//DbContext = new MicrotingDbMs(ConnectionString);
DbContext.Database.SetCommandTimeout(300);
try
{
ClearDb();
}
catch
{
Core core = new Core();
core.StartSqlOnly(ConnectionString);
core.Close();
}
//if (!userName.Contains("USER_NAME"))
//{
// var credentials = SdkContext.AzureCredentialsFactory.FromServicePrincipal(applicationId, password, directoryId, AzureEnvironment.AzureGlobalCloud);
// var azure = Azure
// .Configure()
// .Authenticate(credentials)
// .WithDefaultSubscription();
// var sqlServer = azure.SqlServers.GetById(databaseServerId);
// sqlServer.Databases.Define(databaseName: databaseName).Create();
//}
//DbContext.Database.CreateIfNotExists();
//DbContext.Database.Initialize(true);
DoSetup();
}
//const bool IsMSSQL = false;//SQL Type
public TestHelpers()
{
// set true for MS SQL Server Database
// set false for MySQL Datbase
const string databaseName = "eformsdk-tests";
//MicrotingDbMs DbContext;
//string mySQLConnStringFormat = "Server = localhost; port = 3306; Database = {0}; user = eform; password = eform; Convert Zero Datetime = true;";
//string msSQLConnStringFormat = @"data source=localhost;Initial catalog={0};Integrated Security=True";
// string ConnectionString = @"data source=(LocalDb)\SharedInstance;Initial catalog=eformsdk-tests;Integrated Security=True";
string ConnectionString = string.Format(DbConfig.ConnectionString, databaseName);
////DbContextOptions dbo = new DbContextOptions();
//DbContextOptionsBuilder dbContextOptionsBuilder = new DbContextOptionsBuilder();
//dbContextOptionsBuilder.UseSqlServer(ConnectionString);
//dbContextOptionsBuilder.UseLazyLoadingProxies(true);
DbContext = GetContext(ConnectionString);
}
