I recently got to know that SQLNativeclient will no longer support from SQL Server 2022 and we may need to upgrade the provider.

Please refer Microsoft Official Document:
MSDN

My application is WebAPI in .Net core. I am using Microsft.Data.SQLClient. Is there any change for my application or not. If changes are there please let me know how to use provider =”MSOLEDB”.

I tried:
“Server=XXXXXXXXXX;Database=DEV_DB;persist security info=True;user id=DEUser;password=XXXXXXXEP;MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=True;Provider=MSOLEDB;”

But it did not work and i got error “Keyword not supported: Provider:”

Please help.

TIA

I tried provider as “MSOLEDB” but it was giving me error “Keyword not supported: provider”