I've created an Entity Data Model and imported several stored procedures as Function Imports. I'm exposing the EDM through ADO.NET Data Services (ANDS). Does ANDS automatically expose the functions through its REST API, or do I need to manually add operations to the service?
R – How to call a stored procedure exposed as an Entity Framework Function Import through ADO.NET Data Services (Astoria)
entity-frameworkstored-procedureswcf-data-services
Related Topic
- .net – Cannot execute stored procedure with ADO.NET Entity Framework
- Sql – Function vs. Stored Procedure in SQL Server
- Entity-framework – How to view the SQL generated by the Entity Framework
- C# – Does Entity Framework Code First support stored procedures
- Entity-framework – No Entity Framework provider found for the ADO.NET provider with invariant name ‘System.Data.SqlClient’
- C# – How to call Stored Procedure in Entity Framework 6 (Code-First)
Best Answer
You will need to expose the sproc through a ServiceOperation. From what I can tell, all mapping to a FunctionImport does is make it usable within the service via CurrentDataSource. Think of it as only a link between the concept and store.