Member Avatar for George_E

Hey guys I was curious to see how ADO.net and SQL server could rank against each other.

I have read into it and from what I understand is that SQL server is a medium for retrieving data and ADO.net is for storing data.

Am I right in believing this?
Does ADO.net and SQL server compliment each other or are they the same concept? If so what are theyre differences and similarities?

Thanks for your time guys

George

  • 3 Contributors
  • 3 Replies
  • 97 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Ezzaral
Member Avatar for sarehu

I'm unsure about the source of your confusion. What does the documentation and other information online say about these products?

Member Avatar for George_E

They say that they are both DBMS technologies.

Which is the more powerful one? Which would be better suited to implement in vb.net?

Thanks again guys

Member Avatar for Ezzaral

It's not a question of which is more powerful. They are different things.

SQL Server is a database system. It stores, manages, and retrieves data.

ADO.net is a data access layer that provides an API to interact with data stored in many different formats, including SQL Server, though you could also connect to Oracle, Sybase, MySQL, and other database systems (and even non-database sources if you wish)
http://en.wikipedia.org/wiki/ADO.NET

You cannot store data in ADO.NET itself - you use it to access data stored in some other system.

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.