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

A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance

-
Ok, this exception "A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance" can happen with NHibernate if you have an entity with a list of other entities with the .Cascade.AllDeleteOrphan() mapping. If you clear the list by assigning it a new List<entity>(), this exception will appear. Instead clear the list by using the .Clear() method. Error Code using( var session = _sessionManager.GetSession())         using (var transaction = session.BeginTransaction())         {             var order = repository.GetOrderEagerlyByOrderId(session, fromDb.Id);             var now = DateTime.Now;             const string user = "GNB\\Username";             var future = now.AddYears(1);             var taxType = new TaxType(0, "Code", "AlternateNameE", "AlternateNameF", "NameE", "NameF", "DescriptionE", "DescriptionF", 13, now, fu
Read more