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

The serve command requires to be run in an Angular project, but a project definition could not be found - Fixed

-
Error -  The serve command requires to be run in an Angular project, but a project definition could not be found Root Cause - When there is no project definition file in your project then you will see this error when you will run ng-serve or ng-build commands. Project definition file - In Angular project definition file is generated when you create new application or upgrade existing application. In Angular versions lesser than 6 this file name is .angulat-cli.json  and in Angular version 6 and above it's name is angular.json . Solution -   So while running the angular build or run commands make sure you have correct project definition file. If you are upgrading your application from Angular 5 or lesser versions to Angular 6 and greater versions then you need to run below command to generate new project definition and other related files. ng update @angular/cli   // run it twice, If it's not generating then again try to run below commands in same sequence....
Read more

Azure - Failed to deploy web package to App Service. Internal Server Error (CODE: 500)- Fixed

-
Image
Error:  Failed to deploy web package to App Service. Internal Server Error (CODE: 500) Explanation: I was getting this error when trying to deploy azure functions with release pipeline. I got this and there was no additional information logs with this. I wasted my one day on this issue. Find Error: You can see the actual error by changing  deploy method for  web deploy   by editing your pipeline. My Root Cause:  "Web Deploy detected insufficient space on disk." So this was the issue for me, it may be because of my subscription.  For different persons root cause might be vary but you can see actual error using this deploy method and can apply your fixes accordingly. Thanks!!!
Read more

Unexpected token T in JSON at position 0 in Angular CLI 6 - Fixed

-
Error -  Unexpected token T in JSON at position 0  Root Cause - When upgrading to Angular CLI 6 and then you run build or install command then you can face this error. Solution - Make sure correct version of Angular CLI is installed. For me Angular CLI 6 did not work so finally I upgraded directly to Angular 7 instead of Angular 6 first as per angular upgrade guide . Thanks
Read more