ADO.NET or ADO?

  • ADO.NET looks like a reasonable solution for database access from the Internet. But what about when the client and database server are on the same LAN? Is ADO.NET overkill? Should I use ADO instead to connect?

    TIA,

    Bill

  • ADO.NET is definitly not overkill. ADO.NET is simply the next version of ADO. Its SqlDataReader and SqlCommand objects provides a low resource intensive method for selecting, inserting and updating data.

  • If you are going with the .NET platform, I'd look at ADO.NET. However, if not, ADO is very stable and mature and works great.

    I do agree with Jon, but am always wary of 1.0 products.

    Steve Jones

    steve@dkranch.net

  • From what I heard at Pass ADO.Net using the SQL provider uses TDS directly and is supposed to be very fast. Will be interesting to see. I'm hoping to tackle a project in the next month or so that will let me start using ADO.Net in production.

    Andy

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply