using stored procedure in entity framework

by

You need to create a model class that contains all stored procedure properties like below.
Also because Entity Framework model class needs primary key, you can create a fake key by using Guid.

public class GetFunctionByID
{
    [Key]
    public Guid? GetFunctionByID { get; set; }

    // All the other properties.
}

then register the GetFunctionByID model class in your DbContext.

public class FunctionsContext : BaseContext<FunctionsContext>
{
    public DbSet<App_Functions> Functions { get; set; }
    public DbSet<GetFunctionByID> GetFunctionByIds {get;set;}
}

When you call your stored procedure, just see below: 

var functionId = yourIdParameter;
var result =  db.Database.SqlQuery<GetFunctionByID>("GetFunctionByID @FunctionId", new SqlParameter("@FunctionId", functionId)).ToList());

More Related Contents:

  1. One DbContext per request in ASP.NET MVC (without IOC container)
  2. Why LINQ to Entities does not recognize the method ‘System.String ToString()?
  3. Difference between Repository and Service Layer?
  4. Multiple DB Contexts in the Same DB and Application in EF 6 and Code First Migrations
  5. Should services always return DTOs, or can they also return domain models?
  6. ASP.NET MVC3 and Entity Framework Code first architecture
  7. How to change type of id in Microsoft.AspNet.Identity.EntityFramework.IdentityUser
  8. Saving Many to Many relationship data on MVC Create view
  9. Defining multiple Foreign Key for the Same table in Entity Framework Code First
  10. ‘Microsoft.SqlServer.Types’ version 10 or higher could not be found on Azure
  11. Converting flattened hierarchical data from SQL Server into a structured JSON object with C#/Linq
  12. Entity Framework Include OrderBy random generates duplicate data
  13. Use Entity framework I want to include only first children objects and not child of child(sub of sub)
  14. keyword not supported data source
  15. Model backing a DB Context has changed; Consider Code First Migrations
  16. Incompatible Data Reader Exception From EF Mapped Objects
  17. There is already an object named ‘AspNetRoles’ in the database
  18. The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value
  19. The type or namespace name ‘DbContext’ could not be found [closed]
  20. EntityType ‘Category’ has no key defined. Define the key for this EntityType [duplicate]
  21. Where to convert business model to view model?
  22. Strongly-Typed ASP.NET MVC with ADO.NET Entity Framework [closed]
  23. What is ViewModel in MVC?
  24. Adding another “Pet” to a Model Form
  25. MVC [HttpPost/HttpGet] for Action
  26. Generate POCO classes in different project to the project with Entity Framework model
  27. Role-based access control (RBAC) vs. Claims-based access control (CBAC) in ASP.NET MVC
  28. ASP.net MVC – Display Template for a collection
  29. How to reuse Areas, Controllers, Views, Models, Routes in multiple apps or websites
  30. How do I create a MVC Razor template for DisplayFor()

Leave a Comment