使用 LINQ 连接两个表 [英] Joining two tables using LINQ

问题描述

我有两张桌子:

计划大师(计划名称、产品 ID)

PlanMaster (PlanName, Product_ID)

和

ProductPoints(Entity_ID、Product_ID、Comm1、Comm2)

ProductPoints (Entity_ID, Product_ID, Comm1, Comm2)

现在我将 Entity_ID 存储到一个存储在int"中的会话中:

Now I am storing Entity_ID into a Session which is stored into an 'int':

int getEntity = Int16.Parse(Session["EntitySelected"].ToString());

我想在我的 LINQ 查询中显示上面表格中所有具有

I want to show in my LINQ query all of the items from above tables which has

Entity_ID = getEntity

Entity_ID = getEntity

这是我的 LINQ 查询:

Here is my LINQ query:

var td = from s in cv.Entity_Product_Points join r in dt.PlanMasters on s.Product_ID equals r.Product_ID
         where s.Entity_ID = getEntity
         select s;

现在它给了我一个错误，上面写着:

Now its giving me an error which says:

不能隐式转换类型'int?''布尔'

Cannot implicitly convert type 'int?' to 'bool'

这里出了什么问题?提前感谢您的评论！

What is going wrong here? Thank you for your comments in advance!

推荐答案

尝试将其更改为

 where s.Entity_ID == getEntity

这篇关于使用 LINQ 连接两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！