LinqToSql基本问题:为什么不编译? [英] Basic LinqToSql question: Why won't this compile?

问题描述

我最近通过一个做工不好的项目向LinqToSQL自我介绍.我很好奇这为什么起作用:

I've been introducing myself to LinqToSQL lately through a poorly-made project at work. I'm curious as to why this works:

var territories = db.Territories.Where(t => t.PendingUserCount > 0);

但这会导致编译错误:

var territories = db.Territories;
if (someCondition)
    territories = territories.Where(t => t.PendingUserCount > 0);
// Cannot implicitly convert 'System.Linq.IQueryable<Territory> to System.Data.Linq.Table<Territory>

我也曾尝试调用 db.Territories.ToList()，但无济于事.

I've also tried to call db.Territories.ToList(), but to no avail.

我确定这只是对Linq的工作方式的误解，但如果有人可以帮助我，我将不胜感激.

I'm sure it's just a misunderstanding of how Linq works, but I'd be appreciative if someone could help me out.

推荐答案

替代方案:

var territories = db.Territories.AsQueryable();
if (someCondition)
    territories = territories.Where(t => t.PendingUserCount > 0);

这篇关于LinqToSql基本问题:为什么不编译?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！