How to load a collection of elements through a many-to-many relationship in Entity Framework?

Question

ASP.NET

Good day.
Now I am writing a program using Entity Framework 6 and I am binding data from the context to the DataGridView.
There are 3 entities: Wallet, WalletM2M, Account. Wallet and Account are related to WalletM2M by a many-to-many relationship. You need to get a list of Wallet records, knowing only the data about a particular Account record.
I do it like this:

var l = context.Wallet.Include(w => w.WalletM2M).Select(w => w.WalletM2M
               .Where(wM2M => wM2M.AccountId == CurrentUser.AccountId && wM2M.IsAdmin == true)).ToList();

But as a result I get a list of lists of Wallet records, with a dimension equal to the number of all Wallet records in the database
Wallet table
Received list
Entity diagram

Answer 1

If you want to get the wallet to the current userid, then just filter

context.Wallet.Include(w => w.WalletM2M)
               .Where(w => w.WalletM2M.AccountId == CurrentUser.AccountId && w.WalletM2M.IsAdmin == true).ToList();