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(); } }