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