CODEWITHSUNDEEP
c#sql-serverasp.net-coresqlclient
Pop
Pop

Reputation: 71

Raw SQL access to SQL Server with ASP.NET Core

I am supporting a ASP 2.0 legacy application and want to add some capabilities (HTML editor, PDF generation). Of course these new capabilities do not have a older version of their libraries that I can link to. I have generated a newer ASP.NET Core app which does have libraries which will work, and I can hand off control as needed to these.

The problem is getting to the database with the new ASP.NET Core app. I do not want to import the whole (large) database with EF, as I only need to update one or two of the hundreds of tables with the new ASP.NET Core app. I want to use a simple SqlClient that will work to surgically update the needed tables.

I got this working on my laptop, but when I run it on the (Windows Server 2019) server, I get the message:

Microsoft.Data.SqlClient is not supported on this platform.

Upvotes: 0

Views: 77

Answers (0)

Related Questions