SQL Server has been developed over a long time and is very very good at doing things like getting the two records out of 100 million that you want very quickly. I hope DLinq takes advantage of this - I mean, does it as Minh asks do a full scan of the table
or does it parse your DLinq query in to T-SQL?
Object databases have been developed for the last 5 years and a few are .net open source projects. Some already handle indexing.
After all, you just inject queries. It still uses the SQL engine.
I was sitting through the video thinking to myself that "this is cool", "that is cool", "Wonder where this will fit in my n-tier apps"..
Actually with N-tier apps do not have a need for ADO.NET and it should be hitting the classes anyways.
They are just wrapping reflection around the queries. Which is what many world class tier apps already do. It's just easier now.
Hell I havent even seen someone use a DataSet in a year or 2 now. And if they do I call them a noob. ( jokingly of course. Its actually peoples flavor ) Usually people who shift to true OOP go with classes only, which is all ADO.NET is anyways.