Selecting multiple from LINQ query

Question

I use this little piece of code to get the IDs I need, and put them in an array

var userids = from a in db.Person
              select a.idlist;

string[] idarray = userids.FirstOrDefault().ToString().Split(';');

How can I use this array of ids to select the matching rows in another query like this

[HttpGet]
public ActionResult GetStuff()
{
    var Item = from a in db.Table
               where a.id == idarray[0]
               and where a.id == idarray[1]
               and where a.id == idarray[2]
               etc...
               select new
                   {
                       a.itemid,
                       a.Element
                   };

    return Json(Item, JsonRequestBehavior.AllowGet);
}

Does this help you?

Siva Gopal
– Siva Gopal

2015-04-15 12:50:42 +00:00
Commented Apr 15, 2015 at 12:50 — Siva Gopal
– Siva Gopal, Commented Apr 15, 2015 at 12:50

Gardax · Accepted Answer · 2015-04-15 12:56:51Z

1

Try something like this:

var Item = from a in db.Table
           where idarray.Contains(a.id)
           select new
               {
                   a.itemid,
                   a.Element
               };

answered Apr 15, 2015 at 12:56

Gardax

3701 silver badge14 bronze badges

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

Comments

Shahzad Khan · Accepted Answer · 2015-04-15 13:05:32Z

0

var Item = from a in db.Table
           where idarray.Contains(a.id)
           select new
               {
                   a.itemid,
                   a.Element
               }.ToArray();

answered Apr 15, 2015 at 13:05

Shahzad Khan

5303 silver badges14 bronze badges

Comments

teo van kot · Accepted Answer · 2015-04-15 13:35:41Z

0

Don't you want to use Extension Method Lambda syntax? I is same Linq, but just has more code-like view:

var Item = db.Table.Where(x => x.Contains(a.id))
           .Select(x => new
               {
                   a.itemid,
                   a.Element
               }).ToArray();

answered Apr 15, 2015 at 13:35

teo van kot

12.5k10 gold badges41 silver badges73 bronze badges

Comments

Taylor Jones · Accepted Answer · 2015-04-16 23:37:27Z

0

Here's what I usually do.

Get the IDs you need:

var ids = something.Where(s => s.SomeCondition).Select(s => s.Id);

Now Lets get the data based on the Ids:

var response = anothertable.Where(a => ids.Contains(a.Id);

You then can make it a list, array, or whatever you want to do with it. It will go through all the records in anothertable and find the records where the a.Id matches any of the ids.

answered Apr 16, 2015 at 23:37

Taylor Jones

4004 silver badges10 bronze badges

Collectives™ on Stack Overflow

Selecting multiple from LINQ query

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related