Silverlight and linq/ria select how to, do the following

query_TMEditSheet = _
                    From tm In Context_DomainService1TMTM.GetTMTMSQuery()
                    From ts In Context_DomainService1TMTM.GetGECODsQuery()
                    Where tm.tmsDate = MainPage.TimeSheetDateSelect_selectdate.Date
                    Where tm.tmsUserI开发者_JS百科D = ts.codType

Defination method select many is not accessible in this context

want to select tmtms records whose userid is present in the codType(of the gecod table)

please guide

What I think you want to do is:

from tm in Context_DomainService1TMTM.GetTMTMSQuery()
join ts in Context_DomainService1TMTM.GetGECODsQuery() on tm.tmsUserID equals ts.codType
where tm.tmsDate = MainPage.TimeSheetDateSelect_selectdate.Date