Friday, October 10, 2025

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)

 


How can I remove GitHub bindings from a Visual Studio 2022 Solution

To remove Git from a solution in Visual Studio 2022, effectively unbinding it from source control, follow these steps:
  1. Ensure the solution is NOT open in the Visual Studio IDE.
  2. Navigate to the root directory of your solution using File Explorer.
  3. If you cannot see the .git folder, you need to enable the display of hidden files and folders in File Explorer. In Windows, open File Explorer, go to the "View" tab, and check "Hidden items."
  4. Delete the .git folder within your solution's root directory. This folder contains all the Git repository information, including history, branches, and tags for the solution and all projects within it.
  5. Visual Studio should now recognize that the Git repository is no longer present and will no longer manage it with Git source control.