public void PerformSpNonQuery(String storedProcedureName, SqlParameterHandler handler, int commandTimeout) { ExecuteCommand(cmd => { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = storedProcedureName; if (commandTimeout != 0) { cmd.CommandTimeout = commandTimeout; } handler(cmd.Parameters); cmd.ExecuteNonQuery(); }); }
public T PerformSpScalar <T>(String storeProcedure, SqlParameterHandler handler, int commandTimeout) { return(ExecuteCommand(cmd => { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = storeProcedure; if (commandTimeout != 0) { cmd.CommandTimeout = commandTimeout; } handler(cmd.Parameters); var x = cmd.ExecuteScalar(); return (T)x; })); }
public void PerformSQLNonQuery(String commandText, SqlParameterHandler handler, int commandTimeout) { ExecuteCommand(cmd => { cmd.CommandType = CommandType.Text; cmd.CommandText = commandText; if (commandTimeout != 0) { cmd.CommandTimeout = commandTimeout; } handler(cmd.Parameters); cmd.ExecuteNonQuery(); } ); }
public DataTable PerformSpDataTable(String storedProcedure, SqlParameterHandler handler, int commandTimeout) { return(ExecuteCommand(cmd => { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = storedProcedure; if (commandTimeout != 0) { cmd.CommandTimeout = commandTimeout; } handler(cmd.Parameters); using (var reader = cmd.ExecuteReader()) { DataTable table = new DataTable(); table.Load(reader); return table; } })); }
public void PerformSpNonQuery(String storedProcedure, SqlParameterHandler handler) { PerformSpNonQuery(storedProcedure, handler, 0); }
public T PerformSpScalar <T>(String storedProcedure, SqlParameterHandler handler) { return(PerformSpScalar <T>(storedProcedure, handler, 0)); }
public DataTable PerformSpDataTable(String storedProcedure, SqlParameterHandler handler) { return(PerformSpDataTable(storedProcedure, handler, 0)); }
public void PerformSQLNonQuery(String commandText, SqlParameterHandler handler) { PerformSQLNonQuery(commandText, handler, 0); }