public List <T> ExecSql <T>(string sql, ref OperationResult op)
{
if (!op.Success)
{
return(null);
}
try
{
DataTable table = ExecSql(sql, ref op);
if (!op.Success)
{
return(null);
}
List <T> ts = DataSchemaDataTableUtilities.ConvertTo <T>(table).ToList();
return(ts);
}
catch (Exception ex)
{
op.AddException(ex);
}
return(null);
}
public List <T> ExecuteSql <T>(SqlScriptEnum sqlScript, Dictionary <string, string> sqlPrmNameValueList, ref OperationResult op)
{
try
{
DataTable table = ExecuteSql(sqlScript, sqlPrmNameValueList, ref op);
if (!op.Success)
{
return(null);
}
List <T> ts = DataSchemaDataTableUtilities.ConvertTo <T>(table).ToList();
return(ts);
}
catch (Exception ex)
{
op.AddException(ex);
}
return(null);
}
