public static T Connection <T>(this T command, string connectionName, DatabaseDriver driver = null)
where T : Command
{
command._connection = ConnectionManager.GetConnection(connectionName);
command.DatabaseDriver = driver != null ? driver : DatabaseDriverManager.Drivers[command._connection.ProviderName];
return(command);
}
/// <summary>
/// Creates a database command from a connection
/// </summary>
/// <param name="connection"></param>
/// <param name="commandType"></param>
/// <param name="sql"></param>
/// <param name="parameters"></param>
/// <param name="timeout"></param>
/// <param name="driver"></param>
/// <returns></returns>
public static DbCommand CreateCommand(
this DbConnection connection,
CommandType commandType,
string sql,
IList <Parameter> parameters,
int?timeout,
DatabaseDriver driver)
{
var command = connection.CreateCommand();
command.CommandType = commandType;
if (timeout.HasValue)
{
command.CommandTimeout = timeout.Value;
}
if (string.IsNullOrEmpty(sql))
{
throw new ArgumentNullException("Must provide the SQL statement");
}
command.CommandText = sql;
if (parameters != null)
{
foreach (var parameter in parameters)
{
command.AddParameter(
driver.ParameterPlaceHolder + parameter.Name,
parameter.Value,
parameter.Size,
parameter.Direction,
parameter.SqlType,
driver);
}
}
return(command);
}
public static T ConnectionString <T>(this T command, string connectionString, string providerName, DatabaseDriver driver = null)
where T : Command
{
command._connection = new Connection
{
ConnectionString = connectionString,
ProviderName = providerName
};
command.DatabaseDriver = driver != null ? driver : DatabaseDriverManager.Drivers[command._connection.ProviderName];
return(command);
}
