I have a problem. When I run the code below:
var data = context.TableX.Where(w => w.userId == 9999&& w.id == 9999) .Distinct().ToList();
这是生成的查询:
SELECT [Extent1].[id] AS [id], [Extent1].[name] AS [name], [Extent1].[companyId] AS [companyId], [Extent1].[userId] AS [userId] FROM [TableX] AS [Extent1] WHERE (9999 = [Extent1].[userId]) AND (9999= [Extent1].[id]) -- Executing at 01/06/2016 17:28:01 -03:00 -- Completed in 271 ms with result: SqlDataReader
我想知道您是否能使“Distinct”与以下查询一起运行:
SELECT DISTINCT id, name, companyId AS type FROM TableX WHERE id=9999 AND userId=9999
感谢您的选择。
id
是唯一的吗?(通常应该是)因为如果是,那么所有结果都将具有不同的特点,无论是否使用DISTINCT
关键字。也许 EF 正在识别并且不使用它。 - Andy Nichols