EF: where..in clause with multiple columns [duplicate]

Question

just trying to get hold on EF. when we work with sql then we often write multiple value inside in clause

Select * from customer
Where countryCode in ('gb','us','fr')

i was searching how to write the same query with EF and LINQ. i found these code.

var countries= new[] {
    new {Country=…, City=…, Address=…},
    …
}

approach 1
------------
var result = locations.Where(l => keys.Any(k => 
                    k.Country == l.Country && 
                    k.City == l.City && 
                    k.Address == l.Address));

approach 2
------------
var result = from loc in Location
             where keys.Contains(new {
                 Country=loc.Country, 
                 City=loc.City, 
                 Address=loc.Address
             }
             select loc;

tell me how to translate below sql query to EF without using multiple contains keyword

Select * from customer
Where countryCode in ('gb','us','fr')

Please don't edit in answers to your question. Instead, post an answer on the duplicate post. — Rob
– Rob ♦, Commented Feb 10, 2018 at 10:43

TheGeneral · Accepted Answer · 2018-02-08 12:18:32Z

2

If i understand you correctly, you can just do this

var countryCodes = new List<string> {"gb","us","fr"}

var locations = Location.Where(loc => countryCodes.Contains(loc.Country));

answered Feb 8, 2018 at 12:18

TheGeneral

82k9 gold badges111 silver badges151 bronze badges

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

Collectives™ on Stack Overflow

EF: where..in clause with multiple columns [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related