Member Avatar for 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!

  • 3 Contributors
  • 2 Replies
  • 134 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by pitic
Member Avatar for kvprajapati

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.

Member Avatar for pitic

i do :twisted:

Edited by pitic because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.