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'