var galleries = db.Query(@"SELECT from Galleries.Id, Galleries.Name, where UserId = @0, COUNT(Photos.Id) AS PhotoCount FROM Galleries, LEFT OUTER JOIN Photos ON Galleries.Id = Photos.GalleryId GROUP BY Galleries.Id, Galleries.Name", user).ToList();
Marked as answer by mclazarini on Apr 17, 2012 02:02 AM
GmGregori
Contributor
5440 Points
731 Posts
Re: Photo Gallery - User ID
Apr 13, 2012 09:12 PM|LINK
Try with:
var galleries = db.Query(@"SELECT from Galleries.Id, Galleries.Name, where UserId = @0, COUNT(Photos.Id) AS PhotoCount FROM Galleries, LEFT OUTER JOIN Photos ON Galleries.Id = Photos.GalleryId GROUP BY Galleries.Id, Galleries.Name", user).ToList();