如何将SQL查询转换为LINQ? [英] How to convert SQL query into LINQ?

问题描述

如何将以下SQL查询转换为linq?这是尝试过的

How can I convert the following SQL query into linq? This is what is tried

    SELECT COUNT(DISTINCT SampleDateTime) AS Total
    FROM dbo.PrecisionArchive
    WHERE AgencySourceId = 7 AND EventType IN('R', 'ONS')

推荐答案

您可以使用:

var total = dbo.PrecisionArchive.Where(p => p.AgencySourceId == 7)
                                .Where(p => p.EventType == "R" || p.EventType == "ONS")
                                .Select(p => p.SampleDateTime)
                                .Distinct()
                                .Count();

这篇关于如何将SQL查询转换为LINQ?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！