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;
}
}
static async Task Main(string[] args)
{
var serviceProvider = new ServiceCollection()
.AddMediatR(Assembly.GetExecutingAssembly())
.AddSingleton <IQueryBus, QueryBus>()
.BuildServiceProvider();
MySqlBootstrap.Initialize();
var queryBus = serviceProvider.GetService <IQueryBus>();
if (queryBus is null)
{
return;
}
Console.WriteLine("People");
var people = await queryBus.Send <GetPersonList, IEnumerable <PersonListItemRecord> >(new GetPersonList());
foreach (var person in people)
{
Console.WriteLine($"{person.Id} {person.LastName} {person.AddressesCount}");
}
Console.WriteLine("Person with id = 2");
var personDetails = await queryBus.Send <GetPersonDetails, PersonDetailsRecord>(new GetPersonDetails(2));
Console.WriteLine($"{personDetails.FirstName} {personDetails.LastName}");
}
// 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();
}
/// <summary>
/// SQLite wrapped Model repository.
/// </summary>
/// <param name="connectionString">Connection string to SQLite database file.</param>
public MySqlRepository(string connectionString)
{
_connectionString = connectionString;
if (!MySqlBootstrap.IsInitialized)
{
MySqlBootstrap.Initialize();
}
}
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);
});
}
static void Main(string[] args)
{
var config = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appConfigs.json", optional: false, reloadOnChange: true)
.Build();
MergeConfig.Instance.Add(new ConfigurationBridge(config));
MySqlBootstrap.Initialize();
var program = new Program();
program.Run();
}
public static void Initialize()
{
// Get the connection string
var connectionStringForSys = Environment.GetEnvironmentVariable("REPODB_CONSTR_SYS", EnvironmentVariableTarget.Process);
var connectionString = Environment.GetEnvironmentVariable("REPODB_CONSTR", EnvironmentVariableTarget.Process);
// Set the connection string
ConnectionStringForSys = (connectionStringForSys ?? @"Server=localhost;Database=sys;Uid=user;Pwd=Password123;");
ConnectionString = (connectionString ?? @"Server=localhost;Database=RepoDb;Uid=user;Pwd=Password123;");
// Initialize MySql
MySqlBootstrap.Initialize();
// Create databases
CreateDatabase();
// Create tables
CreateTables();
}
public App()
{
var bridge = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appConfigs.json", optional: false, reloadOnChange: true)
.Build();
MergeConfig.Instance.Add(new ConfigurationBridge(bridge));
MySqlBootstrap.Initialize();
var config = MergeConfig.Instance;
var host = config.CombineReadString("mysql:host");
var database = config.CombineReadString("mysql:database");
var userName = config.CombineReadString("mysql:username");
var password = config.CombineReadString("mysql:password");
var connectionString = $"Server={host};Database={database};Uid={userName};Pwd={password};";
Connection = new MySqlConnection(connectionString);
}
public void Initialize()
{
MySqlBootstrap.Initialize();
}
