public static void PerformDbInteraction(Action <IDbConnection> action, DatabaseConnectionAdapter adapter)
{
using (var connection = InitializeConnection(adapter))
{
action?.Invoke(connection);
}
}
public static IDbConnection InitializeConnection(DatabaseConnectionAdapter adapter)
{
var connectionString = DatabaseConnectionUtils.CreateConnectionString(adapter.DatabaseConnection, adapter.ConnectionStringType);
IDbConnection connection = new SqlConnection(connectionString);
connection.Open();
return(connection);
}
public static IDbCommand PerformCommand(DatabaseConnectionAdapter adapter)
{
IDbCommand dbCommand = null;
PerformDbInteraction(con =>
{
dbCommand = con.CreateCommand();
}, adapter);
return(dbCommand);
}