public static vsCMTypeRef GetRefTypeOfColumnDefinition(ColumnDefinition columnDefinition)
{
var type = vsCMTypeRef.vsCMTypeRefString;
switch (columnDefinition.ColumnType)
{
case "varchar":
case "uniqueidentifier":
type = vsCMTypeRef.vsCMTypeRefString;
break;
}
return type;
}
public static string GetPropertyName(ColumnDefinition columnDefinition)
{
return "_" + columnDefinition.ColumnName.ToLower();
}
private async Task GetColumnDefinitions(string tableName, string connectionString, List<ColumnDefinition> columnDefinitions)
{
using (var connection = new SqlConnection(connectionString))
{
await connection.OpenAsync();
var tableStructureCommand = new SqlCommand(string.Format("SELECT COLUMN_NAME,DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '{0}'", tableName), connection);
var tableStructureReader = await tableStructureCommand.ExecuteReaderAsync();
while (tableStructureReader.Read())
{
var columnDefinition = new ColumnDefinition
{
ColumnName = tableStructureReader.GetString(0),
ColumnType = tableStructureReader.GetString(1)
};
columnDefinitions.Add(columnDefinition);
}
tableStructureReader.Close();
connection.Close();
}
}
