Doing a IN statement with LINQ

Question

Possible Duplicate:
Use dictionary inside linq query

How can I make a IN statement with LINQ ?

What I have

    var t = from i in emails
            where i.Credencials_Id == agenciaid
            select new
            {
                i.Alias,
                i.Name,
                i.Description,
                i.Comentas,
                i.DateHour,
                i.Imovel_Id,
                i.Email,
                i.EmailCaptador
            };

What I Want (Something like this)

    var t = from i in emails
            where i.Credencials_Id IN (agenciaid)
            select new
            {
                i.Alias,
                i.Name,
                i.Description,
                i.Comentas,
                i.DateHour,
                i.Imovel_Id,
                i.Email,
                i.EmailCaptador
            };

int imovel = Convert.ToInt32(t.First().Imovel_Id);

If you use Linq2Objects: `where agenciaid.Contains(i.Credencials_Id)`, Linq2Sql can encounter a parameter limit. — mbx, Dec 05 '12 at 15:37

score 1 · Accepted Answer · answered Dec 05 '12 at 15:38

1

When you are using LINQ to Objects you can use this:

from i in emails
where agenciaid.Contains(i.Credencials_Id)
select new
{
    i.Alias,
    i.Name,
    i.Description,
    i.Comentas,
    i.DateHour,
    i.Imovel_Id,
    i.Email,
    i.EmailCaptador
};

answered Dec 05 '12 at 15:38

Daniel Hilgarth

171,043
40
335
443

I got the following error `System.NotSupportedException: LINQ to Entities does not recognize the method 'Boolean Contains (System.Object)' which can not be converted to an expression Storage` – Lucas_Santos Dec 05 '12 at 15:50
In that case you are not using LINQ to Objects. I mark your question as a duplicate. See the accepted answer of the linked question on how to do it. – Daniel Hilgarth Dec 05 '12 at 15:54
But how can I call the `WhereIN` method in my case ? – Lucas_Santos Dec 05 '12 at 16:10
EF supports the contains keyword. agenciaid needs to be some kind of collection, int[] or List etc... – TGnat Dec 05 '12 at 16:17
TGnat agenciaid is a `ArrayList` but occurs the error that I told above. – Lucas_Santos Dec 05 '12 at 16:19
@Lucas_Santos which version of EF are you using? – TGnat Dec 05 '12 at 16:20
@TGnat I'm using EF version 3.5 – Lucas_Santos Dec 05 '12 at 16:24
@Lucas_Santos Can you use a more strongly typed collection... List for example. – TGnat Dec 05 '12 at 16:42

Doing a IN statement with LINQ

1 Answers1