使用 Linq to SQL 确定行是否存在的最快方法是什么?

问题描述

我对一行的内容不感兴趣，我只想知道一行是否存在.Name 列是主键，因此将有 0 或 1 个匹配行.目前，我正在使用:

I am not interested in the contents of a row, I just want to know if a row exists. The Name column is a primary key, so there will either be 0 or 1 matching rows. Currently, I am using:

if ((from u in dc.Users where u.Name == name select u).Count() > 0)
    // row exists
else
    // row doesn't exist

虽然上述工作正常，但它通过选择行的所有内容(如果存在)做了很多不必要的工作.以下是否会创建更快的查询:

While the above works, it does a lot of unnecessary work by selecting all the contents of the row (if it exists). Does the following create a faster query:

if (dc.Users.Where(u => u.Name == name).Any())

...或者有更快的查询吗?

...or is there an even faster query?

推荐答案

Count() 方法可能会做额外的工作，如(在 TSQL 中)EXISTS 或 TOP 1 通常要快得多；数据库可以优化是否至少有一行".就个人而言，我会使用 any/predicate 重载:

The Count() approach may do extra work, as (in TSQL) EXISTS or TOP 1 are often much quicker; the db can optimise "is there at least one row". Personally, I would use the any/predicate overload:

if (dc.Users.Any(u => u.Name == name)) {...}

当然，您可以通过观看 TSQL 来比较每个人的行为:

Of course, you can compare what each one does by watching the TSQL:

dc.Log = Console.Out;

这篇关于使用 Linq to SQL 确定行是否存在的最快方法是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！