ADO.Net classic, is anyone still using it?

[sngapoonage]

Hi everyone,

I use the ADO.Net SqlConnection, SqlCommand and SqlDataReader for all of my database interaction within my DAL. When I do a SELECT statement I cycle through my reader in a while loop and store each row in custom objects I have created.

It seems to me like nobody uses this method anymore, I hear all these things about LINQ to SQL and the Entity Framework. Is my method still an acceptable way of database manipulation?

Thanks for your opinions!

[__avd]

Good question indeed. That's true that EDM /FE and LINQ to SQL have number of advantages over ADO.NET. In fact Entity Framework is an O/R mapper which is built on top of ADO.NET but lot of old applications still uses ADO.NET & Dataset.

[pitic]

i do :twisted: