private static void InitializeRepoDb()
{
var provider = MixService.GetEnumConfig <MixDatabaseProvider>(MixConstants.CONST_SETTING_DATABASE_PROVIDER);
switch (provider)
{
case MixDatabaseProvider.MSSQL:
SqlServerBootstrap.Initialize();
break;
case MixDatabaseProvider.MySQL:
MySqlBootstrap.Initialize();
break;
case MixDatabaseProvider.PostgreSQL:
PostgreSqlBootstrap.Initialize();
break;
case MixDatabaseProvider.SQLITE:
SqLiteBootstrap.Initialize();
break;
default:
SqLiteBootstrap.Initialize();
break;
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseWebAssemblyDebugging();
}
else
{
app.UseExceptionHandler("/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseBlazorFrameworkFiles();
app.UseStaticFiles();
PostgreSqlBootstrap.Initialize();
app.UseRouting();
app.UseEndpoints(endpoints =>
{
endpoints.MapRazorPages();
endpoints.MapControllers();
endpoints.MapFallbackToFile("index.html");
});
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
SqlServerBootstrap.Initialize();
PostgreSqlBootstrap.Initialize();
MySqlBootstrap.Initialize();
#region dependency injection
services.AddTransient <IDatabaseConnectionFactory, NorthWindDbConnectionFactory>();
services.AddTransient <IDatabaseConnectionFactory, AdemBlogDbConnectionFactory>();
services.AddTransient <IDatabaseConnectionFactory, FinansDbConnectionFactory>();
services.AddTransient <IDatabaseConnectionFactory, BookStoreDbConnectionFactory>();
services.AddTransient <ICategoryService, CategoryManager>();
services.AddTransient <ICategoryDal, CategoryDal>();
services.AddTransient <ICashboxService, CashboxManager>();
services.AddTransient <ICashboxDal, CashboxDal>();
services.AddTransient <ITagService, TagManager>();
services.AddTransient <ITagDal, TagDal>();
services.AddTransient <IPostService, PostManager>();
services.AddTransient <IPostDal, PostDal>();
services.AddTransient <IBookService, BookManager>();
services.AddTransient <IBookDal, BookDal>();
#endregion dependency injection
services.AddControllersWithViews();
}
public static void Initialize()
{
// Check the connection string
var connectionStringForPosgres = Environment.GetEnvironmentVariable("REPODB_CONSTR_POSTGRESDB", EnvironmentVariableTarget.Process);
var connectionString = Environment.GetEnvironmentVariable("REPODB_CONSTR", EnvironmentVariableTarget.Process);
// Master connection
ConnectionStringForPosgres = (connectionStringForPosgres ?? "Server=127.0.0.1;Port=5432;Database=postgres;User Id=postgres;Password=Password123;");
// RepoDb connection
ConnectionString = (connectionString ?? "Server=127.0.0.1;Port=5432;Database=RepoDb;User Id=postgres;Password=Password123;");
// For >= v6.0.0: To reutilize the legacy behavior
// https://github.com/abpframework/abp/issues/10273
AppContext.SetSwitch("Npgsql.EnableLegacyTimestampBehavior", true);
// Initialize PostgreSql
PostgreSqlBootstrap.Initialize();
// Create databases
CreateDatabase();
// Create tables
CreateTables();
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
//initializes RepoDb ORM for PostgreSQl ...........
PostgreSqlBootstrap.Initialize();
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller=Home}/{action=Index}/{id?}");
});
}
public void Init(string connectionString, DatabaseProvider databaseType)
{
DatabaseProvider = databaseType;
conn = DatabaseProvider.GetAndConfigureConnection(connectionString, (connection, dbType) =>
{
switch (dbType)
{
case DatabaseProvider.MySqlData:
MySqlBootstrap.Initialize();
break;
case DatabaseProvider.Npgsql:
PostgreSqlBootstrap.Initialize();
break;
case DatabaseProvider.SystemData:
{
var dbSetting = new SqlServerDbSetting();
DbSettingMapper.Add(typeof(System.Data.SqlClient.SqlConnection), dbSetting, true);
// Map the DbHelper
var dbHelper = new SqlServerDbHelper();
DbHelperMapper.Add(typeof(System.Data.SqlClient.SqlConnection), dbHelper, true);
// Map the Statement Builder
var statementBuilder = new SqlServerStatementBuilder(dbSetting);
StatementBuilderMapper.Add(typeof(System.Data.SqlClient.SqlConnection), statementBuilder, true);
break;
}
case DatabaseProvider.MicrosoftData:
{
var dbSetting = new SqlServerDbSetting();
DbSettingMapper.Add(typeof(Microsoft.Data.SqlClient.SqlConnection), dbSetting, true);
// Map the DbHelper
var dbHelper = new SqlServerDbHelper();
DbHelperMapper.Add(typeof(Microsoft.Data.SqlClient.SqlConnection), dbHelper, true);
// Map the Statement Builder
var statementBuilder = new SqlServerStatementBuilder(dbSetting);
StatementBuilderMapper.Add(typeof(Microsoft.Data.SqlClient.SqlConnection), statementBuilder, true);
break;
}
case DatabaseProvider.MySqlConnector:
MySqlConnectorBootstrap.Initialize();
break;
default:
throw new ArgumentOutOfRangeException();
}
connection.Open();
return(connection);
});
}
/// <summary>
/// Initialize the creation of the database.
/// </summary>
public static void Initialize()
{
// Set the connection string
ConnectionStringForPosgres = Environment.GetEnvironmentVariable("REPODB_CONSTR_POSTGRESDB", EnvironmentVariableTarget.Process) ??
"Server=127.0.0.1;Port=5432;Database=postgres;User Id=postgres;Password=Password123;";
ConnectionStringForRepoDb = Environment.GetEnvironmentVariable("REPODB_CONSTR", EnvironmentVariableTarget.Process) ??
"Server=127.0.0.1;Port=5432;Database=RepoDb;User Id=postgres;Password=Password123;";
// Initialize PostgreSql
PostgreSqlBootstrap.Initialize();
// Create databases
CreateDatabase();
// Create tables
CreateTables();
}
public void Initialize()
{
PostgreSqlBootstrap.Initialize();
}
public void Setup()
{
SqlServerBootstrap.Initialize();
PostgreSqlBootstrap.Initialize();
}
public void Setup()
{
PostgreSqlBootstrap.Initialize();
TypeMapper.Add(typeof(DateTime), DbType.DateTime2, true);
BaseSetup();
}
