开发者

Difference between Sql Connection and OLEDB Connection

开发者 https://www.devze.com 2023-03-29 16:55 出处:网络
What is th开发者_运维问答e difference between the SQL Connection and OLEDB Connection? Is that OLEDB is common to all (also SQL Server)? To which are all Servers, OLEDB is using?The advantage of using

What is th开发者_运维问答e difference between the SQL Connection and OLEDB Connection? Is that OLEDB is common to all (also SQL Server)? To which are all Servers, OLEDB is using?


The advantage of using OleDbConnection is flexibility. You can change your database (for instance, move to Oracle)and not have to change your code.

If you using SQLServer as backend then use SQLConnection for better performance.

check with this link http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/fadb2742-d75a-49fb-a839-b2d4a9183998/

OleDbConnection : You can connect to any database, which you have provide for that.

Tip: use Universal Data Link File

Difference between Sql Connection and OLEDB Connection


SqlConnection is designed to access SQL Server, while OleDbConnection is designed to access any database.

0

精彩评论

暂无评论...
验证码 换一张
取 消