Comparison of '.NET SqlClient' and 'Microsoft OLEDB' for accessing MSSQL 7 and above
-
In the .NET documentation Microsoft is recommending usage of SQL server .NET data provider for accessing MSSQL 7 and above. Will any one please tell me what are the advantages of using .NET library over OLEDB? Uday
-
In the .NET documentation Microsoft is recommending usage of SQL server .NET data provider for accessing MSSQL 7 and above. Will any one please tell me what are the advantages of using .NET library over OLEDB? Uday
Its recommened to use SQL Server .NET data provider because its made strictly for SQL Server and supports all its features. the OleDb.NET provider is a general provider and can be used for connectivity to any database Sql Server, Access, Oracel, etc... Similarly you should use the Oracle.NET dataprovider for connecting to oracle. There are finer points than what I've mentioned but that the bird's eye view.
-
Its recommened to use SQL Server .NET data provider because its made strictly for SQL Server and supports all its features. the OleDb.NET provider is a general provider and can be used for connectivity to any database Sql Server, Access, Oracel, etc... Similarly you should use the Oracle.NET dataprovider for connecting to oracle. There are finer points than what I've mentioned but that the bird's eye view.