Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXEC sp_executesql N'SELECT
- CASE WHEN ( EXISTS (SELECT
- 1 AS [C1]
- FROM [dbo].[User] AS [Extent1]
- WHERE ( EXISTS (SELECT
- 1 AS [C1]
- FROM [dbo].[UserFriends] AS [Extent2]
- WHERE ([Extent1].[UserKey] = [Extent2].[FrienderId]) AND ([Extent2].[FrienderId] = @p__linq__0) AND ([Extent2].[isApproved] = 1)
- )) OR ( EXISTS (SELECT
- 1 AS [C1]
- FROM [dbo].[User] AS [Extent3]
- WHERE EXISTS (SELECT
- 1 AS [C1]
- FROM [dbo].[UserFriends] AS [Extent4]
- WHERE ([Extent3].[UserKey] = [Extent4].[FrienderId]) AND ([Extent4].[FriendeeId] = @p__linq__1) AND ([Extent4].[isApproved] = 1)
- )
- ))
- )) THEN cast(1 as bit) WHEN ( NOT EXISTS (SELECT
- 1 AS [C1]
- FROM [dbo].[User] AS [Extent5]
- WHERE ( EXISTS (SELECT
- 1 AS [C1]
- FROM [dbo].[UserFriends] AS [Extent6]
- WHERE ([Extent5].[UserKey] = [Extent6].[FrienderId]) AND ([Extent6].[FrienderId] = @p__linq__0) AND ([Extent6].[isApproved] = 1)
- )) OR ( EXISTS (SELECT
- 1 AS [C1]
- FROM [dbo].[User] AS [Extent7]
- WHERE EXISTS (SELECT
- 1 AS [C1]
- FROM [dbo].[UserFriends] AS [Extent8]
- WHERE ([Extent7].[UserKey] = [Extent8].[FrienderId]) AND ([Extent8].[FriendeeId] = @p__linq__1) AND ([Extent8].[isApproved] = 1)
- )
- ))
- )) THEN cast(0 as bit) END AS [C1]
- FROM ( SELECT 1 AS X ) AS [SingleRowTable1]',N'@p__linq__0 uniqueidentifier,@p__linq__1 uniqueidentifier',@p__linq__0='1BB7438A-F0A4-45EE-9EC6-64CC3796FA2B',@p__linq__1='1BB7438A-F0A4-45EE-9EC6-64CC3796FA2B'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement