Converting .NET Application from Oracle to SQL Server

The SQL Server equivalent of Oracle.ManagedDataAccess.Client is either System.Data.SqlClient or Microsoft.Data.SqlClient

System.Data.SqlClient is the older built-in provider.

Microsoft.Data.SqlClient is the newer, actively maintained version with better support for .NET Core and .NET 5+.

 

Feature	Oracle.ManagedDataAccess.Client	System.Data.SqlClient / Microsoft.Data.SqlClient
Database	Oracle	SQL Server
Namespace	Oracle.ManagedDataAccess.Client	System.Data.SqlClient or Microsoft.Data.SqlClient
Connection class	OracleConnection	SqlConnection
Command class	OracleCommand	SqlCommand
Data reader class	OracleDataReader	SqlDataReader
NuGet package	Oracle.ManagedDataAccess	System.Data.SqlClient (legacy) or Microsoft.Data.SqlClient (modern)