>>>>>>public class TableSchema >>>>>>{ >>>>>> >>>>>>internal String TableName; >>>>>> >>>>>>public List<ColumnSchema> Columns = new List<ColumnSchema>(); >>>>>> >>>>>>} >>>>>>>>>>>>then how would I retrieve column schema for particular column name ?
var columnSchema = Columns.Where(x => x.ColumnName == "Name").FirstOrDefault();>>>>
Dictionary<string, ColumnSchema> columnTypes; >> >> using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.SchemaOnly)) >> { >> >> columnTypes = (from DataRow r in reader.GetSchemaTable().AsEnumerable() >> select new ColumnSchema >> { >> ColumnName = (string) r["ColumnName"], >> ColumnSize = (Int32) r["ColumnSize"], >> DbType = (SqlDbType) r["ProviderType"], >> DataType = (Type) r["DataType"] >> }).ToDictionary(cs=> cs.ColumnName); >> }Fair point. Guess we don't know enough about the context in which the collection will be used. One downside of a Dictionary is that it makes it more difficult to access an item by anything other than the ColumnName?