public static void UseConfiguration(this DbContextOptionsBuilder optionsBuilder, IDatabaseConfiguration configuration, DatabaseType type)
{
IDatabaseConnectionString connectionString = configuration.GetConnectionString(type);
switch (connectionString.Provider)
{
case DatabaseProvider.MySql:
optionsBuilder.UseMySql(connectionString.ConnectionString);
break;
default:
throw new NotSupportedException();
}
}
public static DbContextOptionsBuilder UseConfiguration(this DbContextOptionsBuilder optionsBuilder, IDatabaseConfiguration databaseConfiguration, DatabaseType databaseType)
{
var connectionString = databaseConfiguration.GetConnectionString(databaseType);
switch (connectionString.Provider)
{
case DatabaseProvider.MySql:
optionsBuilder.UseMySql(connectionString.ConnectionString);
break;
default:
throw new NotSupportedException($"The requested database provider: {connectionString.Provider:G} is not supported.");
}
return(optionsBuilder);
}
public void Execute(string query)
{
var cmd = new SqliteCommand(query);
using (var connection = new SqliteConnection(databaseConfiguration.GetConnectionString())){
try{
cmd.Connection = connection;
connection.Open();
cmd.ExecuteNonQuery();
}catch (SqliteException) {
throw;
}
}
}
private void ExecuteCommand(SqliteCommand command)
{
using (var connection = new SqliteConnection(databaseConfiguration.GetConnectionString()))
{
try
{
command.Connection = connection;
connection.Open();
command.ExecuteNonQuery();
}
catch (SqliteException ex)
{
System.Console.WriteLine(ex.Message);
}
}
}
public T Execute <T>(string query, Func <SqliteDataReader, T> mapper)
{
var cmd = new SqliteCommand(query);
using (var connection = new SqliteConnection(databaseConfiguration.GetConnectionString())){
try{
cmd.Connection = connection;
connection.Open();
var reader = cmd.ExecuteReader();
return(mapper(reader));
}catch (SqliteException) {
throw;
}
}
}
