public static TableForMapping SQLRequestSPAutoFillParams(string sql, ParamList paramList) { using (ConnectionHelper ch = new ConnectionHelper(SettingsBackEnd.CS.ConnectionString)) { TableForMapping myTable = new TableForMapping(); myTable.Load(ch.MakeCommand(sql, paramList, CommandType.StoredProcedure).ExecuteReader()); return(myTable); } }
public static TableForMapping SQLRequestDTO(string sql, ParamList paramList) { using (ConnectionHelper ch = new ConnectionHelper(SettingsBackEnd.CS.ConnectionString)) { TableForMapping myTable = new TableForMapping(); myTable.Load(ch.MakeCommand(sql, paramList).ExecuteReader()); return(myTable); } }