Using Stored Procedure In Entity Framework 7

Question

How to use stored procedure in Entity framework 7 in MVC 6 to select multiple table field value?

karunapriya k · Answer

Is it possible yet to execute a stored procedure or execute a piece of SQL in EF7? To do this in earlier EF versions we have a variety of options such as those detailed on MSDN here If not is there a plan to allow this through one of the Extension namespaces (eg EntityFramework.Relational or EntityFramework.SqlServer). At the moment I'm making this call via straight Ado.Net however that has the disadvantage that it isn't (currently) supported for my requirement

karunapriya k · Answer

Its for creating but i want my result set as i have User and Employee table in my SQL server. In GetJoinTable storedprocedure i want to fetch data from both user and Employee table . I couldnot retain this.. If i use DBSET i can able to attain but i shouldnot use DBset without it i need solution for this eg: var joinTable = db .Set () .FromSql(GetJoinTable) .ToList();

Manas Mohapatra · Answer

Please go through below link that will help you: http://mvc.readthedocs.org/en/latest/tutorials/mvc-with-entity-framework.html