>>>>>>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 just the one property:
var dbType = Columns.FirstOrDefault(x => x.ColumnName == "Name").DbType;
BTW, I am getting an error that generic list does not contain Where extension method. Which using I am missing?
If it's not broken, fix it until it is.
My Blog