public static SqlDataReader GetDataReader(Enumerations.DBServerType serverType, string tStoredProcedureName, int iTimeout, params DataAccessParameter[] parameters) { SQLServerHelper objSQLHelper = default(SQLServerHelper); objSQLHelper = CreateHelper(serverType); return(objSQLHelper.GetDataReader(tStoredProcedureName, iTimeout, parameters)); }
public static DataSet ExecuteSQL(Enumerations.DBServerType serverType, string tSqlStatment, int iTimeout) { SQLServerHelper objSQLHelper = default(SQLServerHelper); objSQLHelper = CreateHelper(serverType); return(objSQLHelper.ExecuteSQL(tSqlStatment, iTimeout)); }
public static decimal ExecuteScalar(Enumerations.DBServerType serverType, string tStoredProcedureName, params DataAccessParameter[] parameters) { SQLServerHelper objSQLHelper = default(SQLServerHelper); objSQLHelper = CreateHelper(serverType); return(objSQLHelper.ExecuteScalar(tStoredProcedureName, parameters)); }
public static DataTable GetDataTable(Enumerations.DBServerType serverType, string storedProcedureName) { return(CreateHelper(serverType).GetDataTable(storedProcedureName)); }
public static DataSet GetDataSet(Enumerations.DBServerType serverType, string storedProcedureName, params DataAccessParameter[] parameters) { var dataSet = new DataSet(); return(CreateHelper(serverType).GetDataSet(storedProcedureName, ref dataSet, parameters)); }
public static SqlDataReader GetDataReader(Enumerations.DBServerType serverType, string tStoredProcedureName, List <DataAccessParameter> colParameters, int iTimeout) { return(GetDataReader(serverType, tStoredProcedureName, iTimeout, null)); }
/// <description> /// Instancia un SQLServerHelper con una BD en particular /// </description> /// <returns>A SQLServerHelper object</returns> /// <raiseErrors></raiseErrors> private static SQLServerHelper CreateHelper(Enumerations.DBServerType serverType) { return(new SQLServerHelper(ConfigurationManager.ConnectionStrings[serverType.ToString()].ConnectionString)); }
public static SqlDataReader GetDataReader(Enumerations.DBServerType serverType, string tStoredProcedureName) { return(GetDataReader(serverType, tStoredProcedureName, null)); }
public static decimal ExecuteScalar(Enumerations.DBServerType serverType, string tStoredProcedureName) { return(ExecuteScalar(serverType, tStoredProcedureName, null)); }
public static int ExecuteStoredProcedure(Enumerations.DBServerType serverType, string storedProcedureName, params DataAccessParameter[] parameters) { return(CreateHelper(serverType).ExecuteStoredProcedure(storedProcedureName, parameters)); }
public static int ExecuteStoredProcedure(Enumerations.DBServerType serverType, string storedProcedureName) { return(CreateHelper(serverType).ExecuteStoredProcedure(storedProcedureName)); }
public static DataTable GetDataTable(Enumerations.DBServerType serverType, ref DataTable dataTable, string storedProcedureName, params DataAccessParameter[] parameters) { return(CreateHelper(serverType).GetDataTable(ref dataTable, storedProcedureName, parameters)); }