>>>>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?
If it's not broken, fix it until it is.
My Blog