Joining two tables using LINQ

Question

I have two tables:

PlanMaster (PlanName, Product_ID)

and

ProductPoints (Entity_ID, Product_ID, Comm1, Comm2)

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

Click to copy

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

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

Entity_ID = getEntity

Here is my LINQ query:

Click to copy

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!

Answer 1

Try changing it to

Click to copy

 where s.Entity_ID == getEntity