Target framework 6.0 not able to open sqlconnection

Ravi Gollapudi 1

I have a project target to 6.0 and when opening sqlconnection I am getting

Arithmetic operation resulted in a overflow
At system.data.sqlclient.tdsparserstateobject.writebytes

When I change to 5.0 targetframework it's working fine.
Plz advice

Jack J Jun 24,286 Reputation points Microsoft Vendor

2022-05-19T06:20:35.78+00:00
@Ravi Gollapudi , based on my test, it works for me either .net 5.0 or .net 6.0.
Also, you coud try another namespace to open sqlconnection.
Please install nuget-package Microsoft.Data.SqlClient first.
Then, Please use the following code to open sql connection.

Microsoft.Data.SqlClient.SqlConnection connection = new Microsoft.Data.SqlClient.SqlConnection("connstr"); connection.Open(); Console.WriteLine(connection.State); connection.Close(); Console.WriteLine(connection.State);