sql和linq查询 [英] sql and linq query

问题描述

数据库具有表格Photos和PhotoAlbums.我需要一个查询，该查询将选择所有相册，并且每个相册仅选择一张照片.我需要此查询的SQL和LINQ版本.预先感谢.

Database has tables Photos and PhotoAlbums. I need a query that will select all albums and only one photo from each album. I need SQL and LINQ version of this query. Thanks in advance.

推荐答案

在Linq中我没有那么丰富的经验，所以我只会给出SQL Server查询

In Linq I'm not that experienced in it so I'll only give the SQL Server Query

SELECT a.*,b.MyPhoto FROM PhotoAlbums a,(SELECT Top 1 myPhoto from Photos Where AlbumID = a.ID) b

或者这个

SELECT a.AlbumID, a.Title, a.Date, (SELECT TOP (1) c.PhotoID FROM Photos c WHERE(c.AlbumID = a.AlbumID)) AS PhotoID FROM PhotoAlbums as a

这篇关于sql和linq查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！