.Net 5.0 - This package is required for the Entity Framework Core Tools to work
I was trying to create a migration in a new project within a solution and received the following error: Build started… Build succeeded. Your startup project…
Read post.NET
OpenXml Validation Spreadsheet Value Between Two Numbers - C#
Hi everyone, Just a quick post on how to validate a numeric cell to ensure that the value is between two numbers when using OpenXml: // Restrict min and max values…
Read postView Raw SQL in EF Core - Simple Option
Hi everyone, I’ve been looking for a simple way of viewing the raw output of sql in my local environment without having to make code changes and came across the…
Read postNetTopologySuite Circular Reference with .net core 2.2
Hey everyone, Testing out a spatial project with .net core and I ran into the following error: Microsoft.CSharp.RuntimeBinder.RuntimeBinderException : The best…
Read post.NET Core 2.1 is Returning JSON with Lowercase Properties
Hi everyone, Just testing out .Net Core 2.1 and noticed that all of my JSON properties are being returned in lowercase despite being defined as uppercase. It turns…
Read postDynamic Robots.txt with Web Api 2
Hi everyone, For a project I’m currently working on I needed a dynamic robots.txt. Because our test environment is public facing we want to keep it from being indexed…
Read postDbSet does not contain a definition for 'FromSQL' and no extension method 'FromSql' accepting an argument of type 'DbSet' could be found.
Hi everyone, I ran into the following error while attempting to use a custom query with EntityFramework: DbSet does not contain a definition for ‘FromSQL’ and no…
Read postInclude UserId in Login Response (Token) - Web API 2
Hi everyone, A quick post on how to include the user’s id in your login response when using Web API 2. The default response to the /Token request is as follows: {…
Read postCannot attach the file 'C:...database.mdf' as database x - Entity Framework
Hi everyone, I ran into the following error when attempting to run ‘update-database’ on an initial migration: Cannot attach the file…
Read postRetrieving User Id in Web API 2 Controller - .NET
Hi everyone, Just a quick post on how to retrieve the current user’s id in a Web API 2 controller: var userId = RequestContext.Principal.Identity.GetUserId(); Note…
Read post