Add Stored procedure to Entity Framework .Net 4.5

thilanka ishara

I create a Stored procedure with visual Studio 2008 R2 and it consist with a User define Table type

When Adding EF Model a Will appear and Say "Identifire is Null or Empty"

my Table Type

CREATE TYPE [dbo].[DeviceList] AS TABLE(

[Device] [int] NOT NULL

)

my Stored Procedure

ALTER PROCEDURE [Cen].[AllocateUsersToDevice]

(

--@TblDeviceList DeviceList READONLY

)

DECLARE @EmpNO varchar(50),

@DeviceNo int

DECLARE @cus_EmpList CURSOR

DECLARE @cus_DeviceList CURSOR

BEGIN

- ----Code Goes here

END

Anyone can help me with this?????

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

thilanka ishara12y ago
there are several tables i have, each and everyone have a primarykey,
i think this error
0
Nimit Joshi12y ago
would you please show me the script of creating table? Do you define primary key in the table?

You can review the following article for further reference:

http://www.c-sharpcorner.com/UploadFile/4b0136/working-with-stored-procedures-using-entity-framework-part/
0