hi all, i have two tables ('TableA', and 'TableC' with a join/cross reference ('TableB' in between them. i'd like to get all of the items from table 'TableA' that are joined to 'TableC', where TableC.SomeID = someID. the query should look something like this: var dbItems = (from i in db.TableA where i.ID == (from j in db.TableB where j.SomeID == someID select j.ID.GetValueOrDefault()) select i); but that doesn't work build because you can't convert IQueriable to int. which makes some sense. so how
Read More...