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