How to do multiple Select Where in Linq

Question

I'm new in Linq, and I want to convert this sql Query to Linq Format.

This is the SQL format

select *
from investorwallets iw
where transactionid in 
(select investordepositid from investordeposits)
or transactionid in
(select withdrawalid from investorwithdrawals)
or transactionid in
(select paymentdistributionid from paymentdistributions)

I've looked on this SO Question too, but no luck for me

EDIT

This is what I have tried. I use Linqpad for testing it

from iw in  Investorwallets 
where   (
            from id in Investordeposits // I got error from here
            select id.investordepositid
        )

Anyone can help me?

Thank you

Add .Contains(iw.transactionid). Then do the similar for other criterias with || between and you are done. — Ivan Stoev
– Ivan Stoev, Commented Oct 18, 2016 at 12:06

Gilad Green · Accepted Answer · 2016-10-18 12:07:05Z

1

The most direct is:

from iw in investorwallets 
where investordeposits.Any(iten => item.investordepositid == iw.transactionid) ||
      investorwithdrawals.Any(iten => item.withdrawalid == iw.transactionid) ||
      paymentdistributions.Any(item => item.paymentdistributionid == iw.transactionid)
select iw;

However you can also union the results and then do .Contains:

var ids = investorwithdrawals.Select(item => item.investordepositid)
                             .Union(investorwithdrawals.Select(item => item.withdrawalid))
                             .Union(paymentdistributions.Select(item => item.paymentdistributionid));

var result = investorwallets.Where(item => ids.Contains(item.transactionid));

answered Oct 18, 2016 at 12:07

Gilad Green

37.3k7 gold badges67 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Webster Over a year ago

hi dude, will try it, and will update to you soon, thanks

Narek Arzumanyan · Accepted Answer · 2016-10-18 12:10:08Z

1

        List<investorwallet> investorwallets = GetInvestorwallets();
        List<investordeposit> investordeposits = GetInvestordeposits();
        List<investorwithdrawal> investorwithdrawals = GetInvestorwithdrawals();
        List<paymentdistribution> paymentdistributions = GetPaymentdistribution();

        List<investorwallet> newList = investorwallets.Where(x => investordeposits.Any(y=>y.investordepositid == x.transactionid)
                                        || investorwithdrawals.Any(y => y.withdrawalid == x.transactionid)
                                        || paymentdistributions.Any(y => y.paymentdistributionid == x.transactionid)).ToList();

answered Oct 18, 2016 at 12:10

Narek Arzumanyan

6163 silver badges11 bronze badges

1 Comment

Webster Over a year ago

thanks for the help dude, i have to mark gilad's answer, because he's the first. :)

Collectives™ on Stack Overflow

How to do multiple Select Where in Linq

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related