Fixed: The required column was not present in the results of a 'FromSql' operation in asp.net core EF core

-
In EF core you will face this error many times.

Error:  The required column was not present in the results of a 'FromSql' operation.

To fix this error either remove the column from mapped model or add UnMapped attribute.


    public class Customer
    {
        /// <summary>
        /// Gets or sets the ID for the customer
        /// </summary>
        [UnMapped]
        public int CustomerName { get; set; }



Comments

Post a Comment

Popular posts from this blog

Swagger for Azure functions: Undocumented TypeError: Failed to execute 'fetch' on 'Window': Request with GET/HEAD method cannot have body. Fixed.

-
Error -  Undocumented TypeError: Failed to execute 'fetch' on 'Window': Request with GET/HEAD method cannot have body.  Root Cause: I have my Azure functions Project for which I am configuring swagger documentation using Nuget Package " AzureExtensions.Swashbuckle ". When I am opening swagger url in browser and I try one get method then I face this error because 'Get' method has body that should not. My function code is:  public async Task<IActionResult> Test(             [HttpTrigger(AuthorizationLevel.Anonymous, Http.Methods.Get, Route = Version + "/test")] HttpRequest request,             ExecutionContext context, IBinder binder)         { } Solution: To remove the body from 'Get' method, I need to specify some ignore attribute to function parameters as below.  public async Task<IActionResult> GetTest(             [HttpTrigger(AuthorizationLevel.Anonymous, Http.Methods.Get, Route = Version + "/test")] HttpRequ
Read more

System.Net.Http.HttpClient' does not contain a definition for 'PostAsJsonAsync

-
Error: 'System.Net.Http. HttpClient '  does not contain a definition for 'PostAsJsonAsync ' and  no  extension method ' PostAsJsonAsync ' accepting a first argument of type 'System.Net.Http. HttpClient ' could be found Solution:  You need to add a reference to System . Net . Http . Formatting . dll This can be found in the extensions assemblies area. A good way of achieving this is by adding the NuGet package  System.Net.Http.Formatting.Extension  to your project. Faced this problem in  QFLES
Read more