how to use stored procedure in asp.net core using EF

Question

I am working on an asp.net core application where I am using EF for database operations. In some cases, I need to use Stored procedures. So when I tried to do so, I get errors. The following is the code I used,

var result = await _context.Query<EmployeeResult>().FromSqlRaw("[usp_getEmployeedetails] @employeeID,@purpose", new SqlParameter("@employeeID", employeeID), new SqlParameter("@purpose", purpose)).ToListAsync();

Here the "EmployeeResult" is a ViewModel. Inside the Sp, I am using multiple tables to create the result select query.

The error message as follows "Cannot create a DbSet for 'EmployeeResult' because this type is not included in the model for the context."

Can anyone help me to resolve the issue?

Afshin · Accepted Answer · 2020-09-25 14:22:07Z

1

Add this code to you dbcontext

public DbSet<EmployeeResult> EmployeeResults { get; set; }

answered Sep 25, 2020 at 14:22

Afshin

1,50911 silver badges18 bronze badges

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

6 Comments

Eldho George Over a year ago

Does this EmployeeResult need to be present in the DB?

Afshin Over a year ago

No. Just class or viewmodel you are using like this should be added into your context.

Eldho George Over a year ago

Does the scaffolding the DB context again will remove these changes? Because in some cases the tables may alter or new tables may come. Since we are on the initial stage of the development.

Afshin Over a year ago

No need to scaffolding after adding this Dbset. Just build again your project. New scaffolding does not remove this.

Eldho George Over a year ago

Thanks, Afshin. Also if the stored procedure returns multiple select queries then how to handle that situation?

|

Collectives™ on Stack Overflow

how to use stored procedure in asp.net core using EF

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related