>>>>Hi Viv,
>>>>
>>>>If I change definition of the TableSchema class to be
>>>>

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

>>
>>Good idea! So, you think it's better than using dictionary, right?
>>
>>If so, I'll try to change to your code and use a List.
>
>Don't see much point in a Dictionary here. And IEnumerable might be better the List....

In our conversion we mostly use Dictionary. I think it's done mostly because of our ignorance and not enough knowledge to use Linq that way you showed.

I am going to try using list for this particular class and see if there will be a speed benefit.

One quick question - how should I access individual properties of the columnSchema using the code you showed? Say, I need to get column's DbType?