private static List <ResultFieldDetails> GetFields(DataTable SchemaTable)
{
//DataTable dt = new DataTable();
List <ResultFieldDetails> result = new List <ResultFieldDetails>();
if (SchemaTable == null)
{
return(result);
}
for (int i = 0; i <= SchemaTable.Rows.Count - 1; i++)
{
var qf = new ResultFieldDetails();
string properties = string.Empty;
for (int j = 0; j <= SchemaTable.Columns.Count - 1; j++)
{
properties += SchemaTable.Columns[j].ColumnName + (char)254 + SchemaTable.Rows[i].ItemArray[j].ToString();
if (j < SchemaTable.Columns.Count - 1)
{
properties += (char)255;
}
if (SchemaTable.Rows[i].ItemArray[j] != DBNull.Value)
{
switch (SchemaTable.Columns[j].ColumnName)
{
case "ColumnName":
// sby : ColumnName might be null, in which case it will be created from ordinal.
if (!string.IsNullOrEmpty(SchemaTable.Rows[i].Field <string>(j)))
{
qf.ColumnName = FirstLetterToUpper(SchemaTable.Rows[i].Field <string>(j));
}
break;
case "ColumnOrdinal":
qf.ColumnOrdinal = (int)SchemaTable.Rows[i].Field <int>(j);
if (string.IsNullOrEmpty(qf.ColumnName))
{
qf.ColumnName = "col" + qf.ColumnOrdinal.ToString();
}
break;
case "ColumnSize":
qf.ColumnSize = (int)SchemaTable.Rows[i].Field <int>(j);
break;
case "NumericPrecision":
qf.NumericPrecision = (int)SchemaTable.Rows[i].Field <short>(j);
break;
case "NumericScale":
qf.NumericScale = SchemaTable.Rows[i].Field <short>(j);
break;
case "IsUnique":
qf.IsUnique = SchemaTable.Rows[i].Field <bool>(j);
break;
case "BaseColumnName":
qf.BaseColumnName = SchemaTable.Rows[i].Field <string>(j);
break;
case "BaseTableName":
qf.BaseTableName = SchemaTable.Rows[i].Field <string>(j);
break;
case "DataType":
qf.DataType = SchemaTable.Rows[i].Field <System.Type>(j).FullName;
break;
case "AllowDBNull":
qf.AllowDBNull = SchemaTable.Rows[i].Field <bool>(j);
break;
case "ProviderType":
qf.ProviderType = SchemaTable.Rows[i].Field <int>(j);
break;
case "IsIdentity":
qf.IsIdentity = SchemaTable.Rows[i].Field <bool>(j);
break;
case "IsAutoIncrement":
qf.IsAutoIncrement = SchemaTable.Rows[i].Field <bool>(j);
break;
case "IsRowVersion":
qf.IsRowVersion = SchemaTable.Rows[i].Field <bool>(j);
break;
case "IsLong":
qf.IsLong = SchemaTable.Rows[i].Field <bool>(j);
break;
case "IsReadOnly":
qf.IsReadOnly = SchemaTable.Rows[i].Field <bool>(j);
break;
case "ProviderSpecificDataType":
qf.ProviderSpecificDataType = SchemaTable.Rows[i].Field <System.Type>(j).FullName;
break;
case "DataTypeName":
qf.DataTypeName = SchemaTable.Rows[i].Field <string>(j);
break;
case "UdtAssemblyQualifiedName":
qf.UdtAssemblyQualifiedName = SchemaTable.Rows[i].Field <string>(j);
break;
case "IsColumnSet":
qf.IsColumnSet = SchemaTable.Rows[i].Field <bool>(j);
break;
case "NonVersionedProviderType":
qf.NonVersionedProviderType = SchemaTable.Rows[i].Field <int>(j);
break;
default:
break;
}
}
}
qf.RawProperties = properties;
result.Add(qf);
}
return(result);
}
public static string MakeProperty(ResultFieldDetails fld)
{
return(string.Format("public {0} {1} {{ get; set; }} //({2} {3})" + nl, fld.CSType, fld.ColumnName, fld.DataTypeName, fld.AllowDBNull ? "null" : "not null"));
}