Microsoft.Data.SqlClient.SqlClientFactory.Instance null

Question

I'm trying to do some prototyping in a newly created Blazor web assembly application.

However when I try connection to SQL Server using Microsoft.Data.SqlClient.SqlClientFactory.Instance, this always returns null. I must have missed something here.

I'm not using EF, just basic ADO.NET.

Any help would be greatly appreciated.

David Browne - Microsoft · Accepted Answer · 2022-09-11 19:55:00Z

1

If you explicitly create a SqlConnection you'll get the error:

System.PlatformNotSupportedException: Microsoft.Data.SqlClient is not supported on this platform.

Because

Blazor WASM application will successfully compile, while referencing any .NET Standard libraries. However, you may receive some errors during runtime due to the restrictions of the browser security sandbox the app is running in. For example, browsers do not allow making arbitrary network connections, interacting directly with the file system or running native code. If a library you're using tries to do any of these things, the app will fail with System.PlatformNotSupportedException error.

Common Problems and Solutions in Blazor

answered Sep 11, 2022 at 19:55

David Browne - Microsoft

90.7k7 gold badges52 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jurjen Over a year ago

Ah, off course. Thanks !

Collectives™ on Stack Overflow

Microsoft.Data.SqlClient.SqlClientFactory.Instance null

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related