.net - Cannot execute stored procedure with ADO.NET Entity Framework -
I have created a simple parameter stored procedure that I have pasted below I have imported the stored procedure into my unit model and the function Import made. The function is never made in the model and I have ADO. I'm unable to execute this archived process using the .NET entity framework. I have opened the .edmx file in the XML view and have confirmed that there is no error in relation to this stored procedure. What am I doing wrong? Is it really impossible to call such a simple stored procedure from the unit framework? I have set the return type for any import function. This stored procedure does not need to return any record sets or values.
Archived Procedure:
ALTER PROC [dbo]. Setting the @Inventory_Snapshot_ID integer declaration on the NOCOUNT as [Inventory_Snapshot_Create] set in the Inventory_Snapshots (snapshot_timestamp) values (GETDATE ()) set @Inventory_Snapshot_ID = SCOPE_IDENTITY () Inventory_Snapshot_Products insert (inventory_snapshot_id, idProduct, share) @Inventory_Snapshot_ID, idProduct, stock New Milk Model DB in the form of slow DB code with code
while trying to execute the stored procedure. Inventory_ShopShotcut ()
First add it to the model, then you go to the unit container , Import the function.
Full details here:
Comments
Post a Comment