Dear All,
How to retreve output values from procedure using Entityfremework ..have look on bellow code please
CREATE PROCEDURE [dbo].[DeleteFriend]
@FriendDeviceId VARCHAR(Max),
@DeviceId VARCHAR(Max)
AS
BEGIN
BEGIN TRY
DELETE FROM Friends
WHERE DeviceId = @DeviceId AND FriendDeviceId = @FriendDeviceId
DELETE FROM Friends
WHERE DeviceId = @FriendDeviceId AND FriendDeviceId = @DeviceId
DECLARE @NotificationMsg VARCHAR(MAX)
SET @NotificationMsg = ''
DECLARE @Name VARCHAR(100)
DECLARE @FriendRegistrationId VARCHAR(MAX)
DECLARE @FriendOS VARCHAR(20)
SELECT @Name = Name
FROM DeviceMaster
WHERE DeviceId = @DeviceId
SET @NotificationMsg = @Name + ' has deleted you from the group'
SELECT @FriendRegistrationId = RegistrationId,
@FriendOS = OS
FROM dbo.DeviceMaster
WHERE DeviceId = @FriendDeviceId
SELECT @NotificationMsg AS STATUSMSG, 1 AS STATUSIND, @FriendRegistrationId AS FriendRegistrationId, @FriendOS AS OS
--EXEC GetFriendsList @DeviceId
END TRY
BEGIN CATCH
SELECT ERROR_MESSAGE() AS STATUSMSG, -1 AS STATUSIND
END CATCH
END
Above proc returns some output data please how to retreve to frantend using entityfreamework
Sujeet SumanPosted Sep 22, 2015, 5:19 AM
Prasad BhagatPosted Sep 22, 2015, 5:12 AM
Sujeet SumanPosted Sep 22, 2015, 5:06 AM
Prasad BhagatPosted Sep 22, 2015, 4:00 AM
Sujeet SumanPosted Sep 21, 2015, 1:02 PM