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