Unable to solve System.Data.SqlClient not supported with Blazor?

I’m getting the following error:

– System.Data.SqlClient is not supported on this platform

When using:

– using System.Data.SqlClient;

– using (IDbConnection connection = new SqlConnection(connectionSting)){}

Using the following:

– System,Data.SqlClient is 4.8.3

– .Net Framework 5.0

– Edge Browser

– VS 2019

Can’t for the life of me figure out why this isn’t working?

Thanks

Hello Sean,

I have been investigating into the behavior you are seeing, and it appears from the following GitHub page that the Microsoft.Data.SqlClient is unfortunately not supported in Blazor: https://github.com/dotnet/SqlClient/issues/599.

Please let me know if you have any other questions or concerns on this matter.

Hey Andrew,

When you say it's not supported in Blazor, I'm assuming/hoping you're saying its not supported as a Blazor Web Assembly, but it works on Blazor server?

Thanks

I have the working by converting a datatable into a list of getter/setter models because I don't like EF.   However all the Microsoft new stuff is using EF that is slower than ADO.NET.