public static T Scalar <T>(this IDbConnection connection, string sql, object parameters)
{
IDbCommand cmd = connection.CreateCommand();
cmd.CommandText = sql;
cmd.AddParametersToCommand(parameters);
return(ReadScalar <T>(cmd));
}
public static int Execute(this IDbConnection connection, string sql, object parameters)
{
IDbCommand cmd = connection.CreateCommand();
cmd.CommandText = sql;
cmd.AddParametersToCommand(parameters);
return(Execute(cmd));
}
public static IEnumerable <T> Query <T>(this IDbConnection connection, string sql, object parameters)
{
IDbCommand cmd = connection.CreateCommand();
cmd.CommandText = sql;
cmd.AddParametersToCommand(parameters);
return(ReadRows <T>(cmd));
}
public static IEnumerable <T> StoredProcedure <T>(this IDbConnection connection, string storedProcName, object parameters)
{
IDbCommand cmd = connection.CreateCommand();
cmd.CommandText = storedProcName;
cmd.CommandType = CommandType.StoredProcedure;
cmd.AddParametersToCommand(parameters, allowArray: false);
return(ReadRows <T>(cmd));
}
public static int StoredProcedure(this IDbConnection connection, string storedProcName, object parameters)
{
IDbCommand cmd = connection.CreateCommand();
cmd.CommandText = storedProcName;
cmd.CommandType = CommandType.StoredProcedure;
cmd.AddParametersToCommand(parameters, allowArray: false);
return(Execute(cmd));
}
