Ignore extra property from entity while getting data from DB using EF Core

Question

I am using EF Core. I want to extract data from the database using a stored procedure and EF Core. I am getting error for those property whose are not returned from DB. How can I fix this?

Entity:

public class CustomOverview
{
    public int A{ get; set; }
    public int? B{ get; set; }
    public int? C{ get; set; }
    public int? D{ get; set; }
}

Repository code

public async Task<CustomOverview> GetMyData()
{
    return  _dbContext.CustomOverviews.FromSqlInterpolated($"exec spr_myStoredProcedure).AsEnumerable().FirstOrDefault();
}

My stored procedure returns data for Column A, Column B.

When I run the code, I get this exception:

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

How can I resolve it? There is many solution where they suggest to remove property or use [NotMapped] attribute before the property. But my requirement is I need those property for different stored procedure. So I couldn't remove them.

David Browne - Microsoft · Accepted Answer · 2021-05-30 16:37:59Z

3

Create a new class that matches the stored procedure return results.

or

Use traditional data reader to read the stored procedure results into your existing class.

or

Add columns C and D to the stored procedure results, using Null values if appropriate.

edited May 30, 2021 at 16:37

David Browne - Microsoft

90.7k7 gold badges52 silver badges87 bronze badges

answered May 30, 2021 at 16:33

pjs

3832 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Ignore extra property from entity while getting data from DB using EF Core

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related