I've got an ASP.NET app that currently uses DataSets and TableAdapters, and thus makes heavey use of typed DataRows.
I'm going to convert this to Connected Data Access as described here:
(FYI, I'm not going with anything more abstract, like Entity Framework, in order to maintain migratability)
The example at that link uses Lists as in-memory proxies for the DB tables.
I recently learned that Dictionaries can be searched much faster that Lists, for unique IDs, which I can arrange for have in all the tables I'm using. Also, Dictionaries can be Typed.
What I'm hoping for is input on the Pros and Cons of List vs Dictionary for these in-memory proxies of DB Tables.
Any help with this would be appreciated.