C# How to access fields tables in joint tables in linq query?

Question

Supposing i have 3 tables in the below picture that joined together. how can i access 'Email' field in 'Users' table in my query on 'UserReferralJoins' table ?

can any one help me?

var referalId = await _dbContext.UserReferrals.Where(x => x.UserId == CurrentUserId).Select(x => x.UserReferralId).FirstOrDefaultAsync();
        var list = await _dbContext.UserReferralJoins
            .Where(i => i.UserReferralId == referalId)
            .Select(x => new
            {
                Id = x.UserReferralJoinId,
                UserEmail = ???
                x.JoinDate
            }).ToListAsync(cancellationToken);

Please check the link https://stackoverflow.com/questions/21051612/entity-framework-join-3-tables . Should be helpful. — Sharath N S, Jul 05 '22 at 11:38

score 0 · Answer 1 · edited Jul 05 '22 at 11:48

0

The name of field in your table is very important I see that your join field name is correct in your database as I see in picture very simply you can use linq query for fetching your purpose for example use 'userreferral'. user and fetch the field of user table. if you want more help plz comment me.

edited Jul 05 '22 at 11:48

Javad A salehi

31
1
6

answered Jul 05 '22 at 11:42

Mehrdad Noroozi

620
2
13

i can't exactly what you say ? can you guide me more clear?! – Javad A salehi Jul 05 '22 at 11:48

score 0 · Answer 2 · answered Jul 05 '22 at 11:51

0

Use this pattern in your select query

 UserEmail =x.UserReferral.ReferralCode

answered Jul 05 '22 at 11:51

Mehrdad Noroozi

620
2
13

C# How to access fields tables in joint tables in linq query?

2 Answers2