entity framework - Multiple join query in eSql -

This is my first question to overflow the stack, but not really the first time to get the solution. I am struggling to get involved in multiple of institution structure 4. I have three tables (accounts, users, and accountants) who are finding it hard to query.

What all I want is to get all the users to the account provided, account creator can not get any problem for all the account users, but the difficult side for me is making account creator because it The account operator has not been added to the table.

Account

• Account ID
• UserId (Account Builder)
• Below is a quick preview.
• Users
• ... Other Columns

Users

AccountUsers

• UserId

I like the query as ESCL, but the links must be done in the unit.

I trust you people on the stack overflow, so I know that it will not take much time to get this 'answer' mark.

If I am reading your question correctly, are not you looking to join so much as a union? I'm not sure about Eskel, but I think the following linak query should work. Maybe it will take you in the right direction (or I may be completely shut down or missing from something):

  var users = (db.AccountUsers from the account user In the case where the accountUser.AccountId == select MyAccountId, the account user.USIRID) .OoList (). (Add the account account in the DB account (account id == myAccountId user ID). Single ());  

To make a lazy load, you can always create a method that uses foreach and yield returns : < / P>

  IEnumerable & LT; Integer & gt; Return to GetAccountUsers {// User Forex (in the var userId (in the account user, in the DB. ACCUsers where accountUser.cciid == select my ACCID account user user id) yield returns User ID; // Return owner too Return to the account (accounts in accounts in DB, where account accounts, select Account ID == myAccountId account, user ID), single ();}  

By curiosity, however, Code> account options Why not added in L'?