开发者社区> 问答> 正文

Entity Framework使用Where方法查询单行记录,但生成的SQL语句没有Where子句是为什么?

在使用ENtityFramework查询数据的时候,其中有一个表,即使在Where方法中传入了查询条件,生成的SQL语句中始终不带Where子句,请问这是为什么?

调用栈:

public IList<Device> GetDeviceByNodeId(string nodeId)
            => GetModels(device => device.DeviceNodeId == nodeId).ToList();

public virtual IEnumerable<T> GetModels(Func<T, bool> exp)
            => EntitySet.Where(exp);
生成的SQL语句:

SELECT 
    [Extent1].[Id] AS [Id], 
    [Extent1].[DeviceTypeId] AS [DeviceTypeId], 
    [Extent1].[OriginalDeviceId] AS [OriginalDeviceId], 
    [Extent1].[DeviceCode] AS [DeviceCode], 
    [Extent1].[StatCode] AS [StatCode], 
    [Extent1].[DevicePassword] AS [DevicePassword], 
    [Extent1].[DeviceModuleGuid] AS [DeviceModuleGuid], 
    [Extent1].[DeviceNodeId] AS [DeviceNodeId], 
    [Extent1].[FirmwareSetId] AS [FirmwareSetId], 
    [Extent1].[ProjectId] AS [ProjectId], 
    [Extent1].[StartTime] AS [StartTime], 
    [Extent1].[PreEndTime] AS [PreEndTime], 
    [Extent1].[EndTime] AS [EndTime], 
    [Extent1].[Status] AS [Status], 
    [Extent1].[CameraId] AS [CameraId], 
    [Extent1].[DomainId] AS [DomainId], 
    [Extent1].[CreateDateTime] AS [CreateDateTime], 
    [Extent1].[CreateUserId] AS [CreateUserId], 
    [Extent1].[LastUpdateDateTime] AS [LastUpdateDateTime], 
    [Extent1].[LastUpdateUserId] AS [LastUpdateUserId], 
    [Extent1].[IsDeleted] AS [IsDeleted], 
    [Extent1].[IsEnabled] AS [IsEnabled]
    FROM [dbo].[Devices] AS [Extent1]
其他同样的方法:

全选复制放进笔记SELECT 
    [Extent1].[Id] AS [Id], 
    [Extent1].[FirmwareSetName] AS [FirmwareSetName], 
    [Extent1].[CreateDateTime] AS [CreateDateTime], 
    [Extent1].[CreateUserId] AS [CreateUserId], 
    [Extent1].[LastUpdateDateTime] AS [LastUpdateDateTime], 
    [Extent1].[LastUpdateUserId] AS [LastUpdateUserId], 
    [Extent1].[IsDeleted] AS [IsDeleted], 
    [Extent1].[IsEnabled] AS [IsEnabled]
    FROM [dbo].[FirmwareSets] AS [Extent1]
    WHERE [Extent1].[Id] = @EntityKeyValue1
-- EntityKeyValue1: '6c36fddf-d3d9-416b-84df-cd849006eef1' (Type = Guid, IsNullable = false)

展开
收起
a123456678 2016-07-04 17:42:17 2467 0
1 条回答
写回答
取消 提交回答
  • 把参数换成Expression>
    public virtual IEnumerable GetModels(Expression> exp)

    如果参数是Func,则查询所有数据,筛选是在内存中进行的。
    Expression> 筛选是在数据库中进行的。

    2019-07-17 19:51:00
    赞同 展开评论 打赏
问答分类:
SQL
问答地址:
问答排行榜
最热
最新

相关电子书

更多
SQL Server在电子商务中的应用与实践 立即下载
GeoMesa on Spark SQL 立即下载
原生SQL on Hadoop引擎- Apache HAWQ 2.x最新技术解密malili 立即下载