thilanka ishara

thilanka ishara

  • 2.1k
  • 16
  • 9.4k

Add Stored procedure to Entity Framework .Net 4.5

Aug 21 2014 11:20 PM
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
)
AS
 
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?????

Answers (2)