Getting data from stored procedure with Entity Framework

by

Use the following steps to solve this issue:

  1. You need to Import the stored procedure as a Function. Right-click on the workspace area of your Entity model and choose Add -> Function Import.
  2. In the Add Function Import dialog, enter the name you want your stored procedure to be referred to in your model for example Search_Products, choose your procedure from the drop down list, and choose the return value of the procedure to be Entities and choose Products from the drop down list.

  3. Then in the code behind:

    var db = new MyEntities();
var TEST_SEARCH_TERM = "product";
var result = db.Search_Products(TEST_SEARCH_TERM);//Search_Products is the name that you specified in Function Import dialog

MyGridView.DataSource = result;
MyGridView.DataBind();

The reason that you get -1 for result is that Entity Framework cannot support Stored Procedure Return values out of the box. I think support of stored procedure return values depends on version of Entity framework. Also Entity Framework doesn’t have rich stored procedure support because its an ORM, not a SQL replacement.

More Related Contents:

  1. Procedure or function xxxxx has too many arguments specified [duplicate]
  2. Call a stored procedure with parameter in c#
  3. What is passing parameters to SQL and why do I need it?
  4. An unhandled exception of type ‘System.InvalidOperationException’ occurred in System.Data.dll?
  5. How to execute a stored procedure within C# program
  6. Entering keys manually with Entity Framework
  7. Using stored procedure output parameters in C#
  8. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  9. Passing List to SQL Stored Procedure
  10. The result of a query cannot be enumerated more than once
  11. Entity Framework – retrieve ID before ‘SaveChanges’ inside a transaction
  12. Queuing in OneWay WCF Messages using Windows Service and SQL Server
  13. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  14. EF 6 – How to correctly perform parallel queries
  15. Entity-framework code is slow when using Include() many times
  16. ‘datetime2’ error when using entity framework in VS 2010 .net 4.0
  17. What SqlDbType maps to varBinary(max)?
  18. Delete a single record from Entity Framework?
  19. How to pass XML from C# to a stored procedure in SQL Server 2008?
  20. How can I convert ticks to a date format?
  21. Retrieve image from database in asp.net
  22. The entity type ApplicationUser is not part of the model for the current context
  23. User in Entity type MVC5 EF6
  24. Entity Framework | Sequence contains more than one matching element
  25. Keyword Not Supported: Metadata
  26. Why is EF generating SQL queries with unnecessary null-checks?
  27. How to Identify the primary key duplication from a SQL Server 2008 error code?
  28. Unable to find the requested .Net Framework Data Provider. It may not be installed
  29. Should the order of LINQ query clauses affect Entity Framework performance?
  30. Watch for a table new records in sql database

Leave a Comment