6
Answers

Select query in Claims Table.

Rohan

Rohan

2y
729
1

Hello every one Please let me know how to Implement select query in claims table. My claims table this type

Id UserId ClaimType ClaimValue

1  2           ABC           1

2 3            XYZ             2

Now how to get record based on ClaimType XYZ. I have try this query but not working

select * from Auth.AspNetUserClaims where ClaimType.XYZ='2'     

Answers (6)