Articles

EF6 - Stored Procedure

EF Code First - Accessing Stored Procedures...I'll start this post by stating that Entity Framework Code First does not have native support for Stored Procedures, yet!...But if it is not supported natively, then how is it possible to access them? Through the context's ...SqlQuery()... method. But there is a drawback: access is linked to the database provider! Each database provider has a specific way of calling and treat stored procedure parameters....In our example, we will demonstrate how to a...

Stored Procedure

Stored Procedure...What is Stored Procedure?...A stored procedure a SQL code that you can save so that the code can be reused over and over again....If you have an SQL query that you write over and over again, save it as a stored procedure, and then call it to execute it....You can also pass parameters to a stored procedure so that the stored procedure can act based on the parameter value(s) that is passed....Stored Procedure in Entity Framework...The Entity Framework allows you to use stored pr...