-1

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

Votes + Comments
suck suck suck, leech leech leech - http://www.slash7.com/pages/vampires
3
Contributors
3
Replies
4
Views
9 Years
Discussion Span
Last Post by Ezzaral
0

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

0

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

0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.