Linq Queries with array

Hi,

i got some int values like 1,4,9 lets say (an array) etc. and have a table Product. With Linq query i gotta check if ProducutID contains any value in that array.

i just did something by trial and error like below, and sure it doesn't work.

int[] nValue = new int[emlakListesi.Count];
            nValue[0] = 48;
            nValue[1] = 1;

            var query = from s in db.Emlaks
                        from n in nValue
                        where s.EmlakID.ToString().Contains(n)
                        select s;

thanks.

Here is example:

public class OneEmlak

{

public string EmlakID;

}

private void Test()

{

List<OneEmlak> dbEmlaks = new List<OneEmlak>();

for (int id = 0; id < 49; id++)

{

dbEmlaks.Add(new OneEmlak()

{

EmlakID = id.ToString()

});

}

int[] nValue = new int[5];

nValue[0] = 48;

nValue[1] = 1;

var resultEmlaks = from eachEml in dbEmlaks

where nValue.Contains(int.Parse(eachEml.EmlakID))

select eachEml;

foreach (var em in resultEmlaks)

{

Console.WriteLine(em.EmlakID);

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Danatas Gervi17y ago

Here is example:

public class OneEmlak

{

                public string EmlakID;

}

private void Test()

{

                List<OneEmlak> dbEmlaks = new List<OneEmlak>();

                for (int id = 0; id < 49; id++)

                {

                                dbEmlaks.Add(new OneEmlak()

                                {

                                                EmlakID = id.ToString()

                                });

                }

                int[] nValue = new int[5];

                nValue[0] = 48;

                nValue[1] = 1;

                var resultEmlaks = from eachEml in dbEmlaks

                                                                   where nValue.Contains(int.Parse(eachEml.EmlakID))

                                                                   select eachEml;

                foreach (var em in resultEmlaks)

                {

                                Console.WriteLine(em.EmlakID);

                }

}