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?????