private List<Column> GetColumns(Table table)
{
List<Column> cols;
using (IDbConnection db = _factory.OpenDbConnection())
{
var sql = string.Format("select * from information_schema.columns where LOWER(table_name) =LOWER('{0}') order by ordinal_position", table.Table_Name);
cols= db.Select<Column>(sql);
}
cols = PopulateColumnMetaData(cols);
return cols;
}
private string GenerateForm(Table table)
{
var sb = new StringBuilder();
foreach (var c in table.Columns)
{
sb.AppendFormat("<input type={0}");
}
return sb.ToString();
}