How to use Linq To Sql to get Users who has more than 2 photos?
- by Mike108
The scenario is I want to get the users who has more than 2 photos.
There are two table:
[Users] (UserId, UserName)
[UserPhotos] (PhotoId, PhotoName, UserId) and UserId is a Foreign Key.
A user may have none photo in the [UserPhotos] table.
How to use Linq To Sql to get List who has more than 2 photos?