EF: where..in clause with multiple columns

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')

https://blogs.msdn.microsoft.com/alexj/2009/03/25/tip-8-how-to-write-where-in-style-queries-using-linq-to-entities/ — Monojit Sarkar, Feb 08 '18 at 12:59
Please don't edit in answers to your question. Instead, post an answer on the duplicate post. — Rob, Feb 10 '18 at 10:43

score 2 · Accepted Answer · answered Feb 08 '18 at 12:18

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 08 '18 at 12:18

TheGeneral

79,002
9
103
141

EF: where..in clause with multiple columns

1 Answers1