how to loop through a array of objects and match to a database and return matching with linq

Question

I need to pass in ids to a webapi controller and return the result. I am currently passing in the ids as a array of objects. I need to match the ids with a dataset and return the result. I found a couple of posts that I am trying to use.

 return db.markets.Where(x => db.markets.Contains(x.x_market_code));

this does not work because the it is not a string or list? I have tried to convert the array to a string or list and i have not got anywhere.

here is code

 public class marketIds
{
    public int x_market_code { get; set; }
}

    [HttpPost]
    [Route("getAssignedMarkets")]
    public IQueryable GetAssignedMarkets(marketIds[] arry)
    {
      return db.markets.Where(x => arry.Contains(x.x_market_code));
    }

I can change how i pass the ids in javascript if need be.

error message

What about .ToList(); at the end of your code??

cramopy
– cramopy

2015-12-25 16:51:58 +00:00
Commented Dec 25, 2015 at 16:51 — cramopy
– cramopy, Commented Dec 25, 2015 at 16:51
nope didnt do anything

texas697
– texas697

2015-12-25 16:53:01 +00:00
Commented Dec 25, 2015 at 16:53 — texas697
– texas697, Commented Dec 25, 2015 at 16:53

Shahar Shalev · Accepted Answer · 2015-12-25 17:11:33Z

2

I assume market code is int so:

[HttpPost]
[Route("getAssignedMarkets")]
public IQueryable GetAssignedMarkets(int[] arry)
{
  return db.markets.Where(x => arry.Contains(x.x_market_code));
}

but you can use string or whatever, however you can still use your class:

 public class marketIds
{
    public int x_market_code { get; set; }
}

    [HttpPost]
    [Route("getAssignedMarkets")]
    public IQueryable GetAssignedMarkets(marketIds[] arry)
    {
      return db.markets.Where(x => arry.where(t=>t.x_market_code == x.x_market_code).Any());
    }

based on your error message , maybe this will help you:

[HttpPost]
[Route("getAssignedMarkets")]
public IQueryable GetAssignedMarkets(int[] arry)
{
  return db.markets.Where(x => arry.Contains(x.x_market_code.Value)).ToList();
}

edited Dec 25, 2015 at 17:11

answered Dec 25, 2015 at 16:53

Shahar Shalev

363 bronze badges

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

1 Comment

texas697 Over a year ago

the watch is "Enumeration yielded no results"

Shyju · Accepted Answer · 2015-12-25 16:58:54Z

1

You can convert read all the market_codes from the array to a collection of strings and then use Contains() method in your LINQ query.

var codeList = arry.Select(s => s.x_market_code).ToList();
var result=db.markets.Where(x => codeList.Contains(x.x_market_code));
return result;

Assuming you are comparing it against the market_code column in your market table and it is of type Int.

edited Dec 25, 2015 at 16:58

answered Dec 25, 2015 at 16:53

Shyju

220k106 gold badges421 silver badges499 bronze badges

Collectives™ on Stack Overflow

how to loop through a array of objects and match to a database and return matching with linq

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related