加入使用LINQ两个表 [英] Joining two tables using LINQ

问题描述

我有两个表：

PlanMaster（PlanName，PRODUCT_ID）

PlanMaster (PlanName, Product_ID)

和

ProductPoints（ENTITY_ID，PRODUCT_ID，COM​​M1，COMM2）

ProductPoints (Entity_ID, Product_ID, Comm1, Comm2)

现在我存储ENTITY_ID成被存储到一个'诠释'会话

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:

无法隐式转换类型'诠释？以布尔

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屋！