Let’s try something new… What about Microsoft.Data.dll?
The new Microsoft.Data.dll seems to be very “interesting”. 
I generally agree, that pure raw ADO.NET is more verbose than the shown example. And that’s all. On the other hand, everybody using pure raw ADO.NET have written couple of helper methods already. And directly for his/her desired approach, with non-dynamic typing. This isn’t going to make anyones life easier. As an experiment with dynamic keyword it’s nice. But a stuff used in real world deployed application? No so sure.
Wanna go easy path? Go LINQ to SQL of Entity Framework with just 1:1 model generated from database (if we’re on MS’s stack, NHibernate or LLBLGen Pro will do the work as well). Wanna go pure SQL, all under own control? ADO.NET is waiting for you. But this, this looks like kind of mixture of both, but nothing good resulted.
By the way, will there be any support for parametrized queries? I hope so. Because if not, then it’s even more funny than it already is.
UPDATE: There’s a support: http://blog.andrewnurse.net/2010/08/03/MicrosoftDataItrsquosNotAsEvilAsYouThink.aspx.
For me it’s a step back. Or am I missing something?
There's 6 Comments So Far
August 3rd, 2010 at 16:25
Snippet with paramatrized query is here: http://blog.andrewnurse.net/2010/08/03/MicrosoftDataItrsquosNotAsEvilAsYouThink.aspx
August 3rd, 2010 at 16:31
Nice. Another question that remains is what about types of parameters. That may be pain too.
August 3rd, 2010 at 16:36
It is not step back, it is step to PHP wonderland.
It is targeted to hobby programmers, nothing for us.
August 3rd, 2010 at 16:42
Shouldn’t also the hobby programmers be taught write good code? I think they should (if they’re trying to actually learn something).
August 3rd, 2010 at 17:09
Maybe they don’t have brainpower to write good code.
Who Linked To This Post?
Share your thoughts, leave a comment!