How to use SqlClient in ASP.NET Core?

by

I think you may have missed this part in the tutorial:

Instead of referencing System.Data and System.Data.SqlClient you need
to grab from Nuget:

System.Data.Common and System.Data.SqlClient.

Currently this creates dependency in project.json –> aspnetcore50
section to these two libraries.

"aspnetcore50": {
       "dependencies": {
           "System.Runtime": "4.0.20-beta-22523",
           "System.Data.Common": "4.0.0.0-beta-22605",
           "System.Data.SqlClient": "4.0.0.0-beta-22605"
       }
}

Try getting System.Data.Common and System.Data.SqlClient via Nuget and see if this adds the above dependencies for you, but in a nutshell you are missing System.Runtime.

Edit: As per Mozarts answer, if you are using .NET Core 3+, reference Microsoft.Data.SqlClient instead.

More Related Contents:

  1. AddTransient, AddScoped and AddSingleton Services Differences
  2. How to get HttpContext.Current in ASP.NET Core? [duplicate]
  3. How should I inject a DbContext instance into an IHostedService?
  4. System.Text.Json API is there something like IContractResolver
  5. Enable OPTIONS header for CORS on .NET Core Web API
  6. MVC/JQuery validation does not accept comma as decimal separator
  7. Asp.Net core long running/background task
  8. Hangfire – Multi tenant, ASP.NET Core – Resolving the correct tenant
  9. How to unapply a migration in ASP.NET Core with EF Core
  10. Manipulating images with .NET Core
  11. How to know the selected checkboxes from within the HttpPost Create action method?
  12. How to implement Permission Based Access Control with Asp.Net Core
  13. How do I setup multiple auth schemes in ASP.NET Core 2.0?
  14. TempData null in asp.net core
  15. How to consume a Scoped service from a Singleton?
  16. Upload files and JSON in ASP.NET Core Web API
  17. How to read values from the querystring with ASP.NET Core?
  18. ASP.NET Core appsettings.json update in code
  19. Change the JSON serialization settings of a single ASP.NET Core controller
  20. Avoid or control circular references in Entity Framework Core
  21. Using IConfiguration in C# Class Library
  22. ASP.NET Core middleware vs filters
  23. Replace service registration in ASP.NET Core built-in DI container?
  24. Multiple Authorization attributes on method
  25. Entity Framework Core: `SqlNullValueException: Data is Null.` How to troubleshoot?
  26. Dependency Injection with classes other than a Controller class
  27. How to get user information in DbContext using Net Core
  28. How should I manage DbContext Lifetime in MVC Core?
  29. What Nuget packages must be referenced by an ASP.NET Core 6 application parts project
  30. No service for type ‘Microsoft.AspNetCore.Identity.UserManager`1[Microsoft.AspNetCore.Identity.IdentityUser]’ has been registered

Leave a Comment