Asp.Net Core 3.1 MVC web application compile error with SqlDateTime
I am having trouble migrating my web app from 2.2 to 3.1 regarding the use of SqlDateTime. To make sure it wasn't an issue with my migration I created a new MVC web application using the standard asp.net core 3.1 template in Visual Studio 2019 16.4. When I add a variable and assign it to SqlDateTime I get a compilation error...
The type 'SqlDateTime' exists in both 'System.Data.Common, Version=4.2.2.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' and 'System.Data.SqlClient, Version=4.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'
Previously it used to work when using System.Data.SqlClient but I know that this has been replaced in 3.0 with Microsoft.Data.SqlClient however the latter doesn't have SqlDateTime so the only way to get it is by using System.Data.SqlTypes but this produces the compilation error. I haven't even included System.Data.SqlClient so I'm a bit confused as to why it is being referenced by the compiler anyway. Any ideas?
You have 2 options.
Downgrade to 3.0, it's not supported in 3.1.
Make your own struct with the
MinValueof January 1, 1753
Check here for the value and supported versions
- Kestrel ignores certificate configuration in code
- Conditional not working in ASP.NET Core 7 Razor view
- Get null in controller when implementing IEnumerable in ASP NET model
- Directory.Build.props only respected when building .sln file
- What is the next step after login for frontend? I am working with .NET 8 Blazor Web App InteractiveAuto
- Are C# 9 'init' properties safe to use for configuration binding (IOptions)?
- How do I run npm build as part of dotnet publish
- Integration test with WebApplicationFactory fails with ObjectDisposedException for IServiceProvider
- Does .NET Core IServiceScopeFactory child scope dispose transient services?
- ServiceCollection does not contain a definition from "AddLogging"
- Token Request Failing and Returning error invalid grant
- How to extend existing third party model?
- Dependency injection approach for object used only in a single method
- How to use appsettings.json in Asp.net core 6 Program.cs file
- ASP.NET Core absolutely refuses to host on other port
- Asp.net core keep using the expired certificate
- Adding classes to Blazor(Razor) Validation
- How can you split the Query / Mutation / Subscription type into multiple files with HotChocolate GraphQL?
- Middleware that calls other middlewares
- Asp.Net Core - The configured user limit (128) on the number of inotify instances has been reached
- Locale "ar-KW" is not getting listed CultureInfo.GetCultures(CultureTypes.AllCultures) in Windows10 .NET 8 Blazor WASM
- Returning Values to Razor Page - Confused Javascript or .cs?
- After Get success, why does first Angular 9 Put request succeed on MVC Core 2.2 API Controller, but fails on next PUT with http err 302 and/or 503?
- Entity Framework search multiple words
- 'Access-Control-Allow-Origin' in ASP.NET Core 6
- How to run dotnet tests in a specific environment?
- How can I make my Blazor Web App save the login infor entered as it would in InteractiveServer but still be able to use the HttpContext for login?
- Exchanging a google idToken for local openId token c#
- Is the ConfigureApplicationCookie(...) designed to allow us to configure an existing cookie by default in the default scheme (Cookies)?
- ASP.NET Azure AD / Entra Authentication - App roles in token, but not being assigned to principal