public List<DbColumn> GetDbColumns(string database, string dbTable)
{
if (string.IsNullOrEmpty(database))
{
throw new ArgumentNullException("database");
}
if (string.IsNullOrEmpty(dbTable))
{
throw new ArgumentNullException("dbTable");
}
var dbColumns = new List<DbColumn>();
try
{
var commandText = string.Format(getDbColumns, database, dbTable);
IDataReader dataReader = this.sqlServer.ExecuteDataReader(CommandType.Text, commandText, null, null);
for (var i = 0; i < dataReader.FieldCount; i++)
{
var dbColumn = new DbColumn
{
Id = i + 1,
Name = dataReader.GetName(i),
DbColumnType = dataReader.GetDataTypeName(i),
Type = dataReader.GetFieldType(i)
};
commandText = string.Format(getDbColumnSummary, database, dbTable, dbColumn.Name);
var summary = this.sqlServer.ExecuteScalar(CommandType.Text, commandText, null, null);
dbColumn.Summary = summary != null ? summary.ToString() : string.Empty;
dbColumns.Add(dbColumn);
}
dataReader.Close();
}
catch (Exception exception)
{
throw new Exception(exception.Message, exception);
}
return dbColumns;
}
private string GetPropertyCode(DbColumn dbColumn)
{
if (dbColumn == null)
{
throw new ArgumentNullException("dbColumn");
}
return "public " + dbColumn.Type + " " + dbColumn.Name + " { get; set; }";
}
