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; } } }