public static string GetBody(Table table, ModelRoot model)
{
try
{
var allColumns = new List<Column>();
foreach (var column in table.GetColumnsFullHierarchy().Where(x => x.Generated).OrderBy(x => x.Name))
{
if (!(column.DataType == System.Data.SqlDbType.Binary ||
column.DataType == System.Data.SqlDbType.Image ||
column.DataType == System.Data.SqlDbType.NText ||
column.DataType == System.Data.SqlDbType.Text ||
column.DataType == System.Data.SqlDbType.Timestamp ||
column.DataType == System.Data.SqlDbType.Udt ||
column.DataType == System.Data.SqlDbType.VarBinary ||
column.DataType == System.Data.SqlDbType.Variant ||
column.DataType == System.Data.SqlDbType.Money))
{
allColumns.Add(column);
}
}
if (allColumns.Count != 0)
{
return BuildStoredProcedure(table, model, allColumns);
}
return "";
}
catch (Exception ex)
{
throw new Exception(table.DatabaseName + ": Failed on generation of paging select statement", ex);
}
}