LINQ to Entity RIA Query syntax? -

I am using RIA services with unit framework - I have a selection of the following squares:

Select * From TaskTable, MapTable mt where mt.SiteID = 1 and t.EndPointID = mt.EndPointID

How can I write this method using questions and lambda, or any other How Can I Use In My Domain Services?

All the examples, I see a new object back- do I really have to do this? I thought this would be a very simple thing, but I have not got the solution yet.

I have to do something like this:

  Public Zero IQueryable & lt; Work & gt; GetTasksFromID (Int ID) {return it. Objecttongest TaskTable.here (E = & gt; E.Site ID = ID) ... ???? }  

You do not not to launch By the end - but it seems that you have two tables in the all columns in your SQL query, pulling those people back from the map table. If you only want to work, you do not need them to try it:

  Return to Work in ObjectContext.TaskTable Join the ObjectContext.MapTable on the workspace. EndPoice ID is the same as the map. ENDPointID where map.SiteID == ID select function;  

(I am providing more support than the LINQ provided by you to SQL queries - it shows that the site id is part of the map rather than the work.) < / P>

You can write it in dot notation instead of a query expression, but this is a trick:

Back Object Contextable.Joined (object = contact.mattabile where (map = & gt; map. SiteID = id), function = & gt; function. Endpoint id, map = & gt; map. Endiid id, (work, map) => function );

(Note that I have moved the where section here, before making it easier for me to join it. But it does not look good again.)