Accessing all Records outside For Loop ASP.Net MVC 5

Question

I am trying to get all records as a List from For Loop. Inside that For Loop i have a query which returns single record everytime. Below is my code:

 IQueryable<MyClass> receive = null;
     for (int i = 0; i < selected_items.Count(); i++)
      {
        var idx = order_receive_id[selected_items[i]];
        receive = (from ors in db.item where ors.id == 
                   order_receive_idx 
                   select new MyClass()
                   {
                     quantity = ors.receive ?? 0,
                     total = ors.quantity * 250 ?? 0
                   });
      }

And then..

var com = new MyNewClass();
com.items_list = receive.ToList();

But this only shows the last record. I want all the records from above query outside the loop. I couldn't find any help according to my need.
Any help would be much appreciated.

Change `IQueryable` to `List`. Change `receive =` to `receive.AddRange`. — mjwills, Aug 13 '18 at 11:27
Because you keep overwriting `receive` in each iteration. But why are you not doing this with one single db call (using a `.Contains()` clause) ? — , Aug 13 '18 at 11:27
If you have an array of ids `[n..m]`, what keeps you from doing a simple `Select foo from x where id in array` — Marco, Aug 13 '18 at 11:29
@StephenMuecke Because i have multiple `ids` and i don't know another way of doing that — Azhar Hussain, Aug 13 '18 at 11:30
@mjwills Thank you so much. Your solution worked like a charm. Thanks a ton. — Azhar Hussain, Aug 13 '18 at 11:38

TBA · Accepted Answer · 2018-08-13T15:09:39.967

1

You Keep overwriting the variable receive.

recieve.AddRange((from ors in db.item where ors.id == 
                   order_receive_idx 
                   select new MyClass()
                   {
                     quantity = ors.receive ?? 0,
                     total = ors.quantity * 250 ?? 0
                   }));

Also if needed you can simplify the query with linq .

edited Aug 13 '18 at 15:09

answered Aug 13 '18 at 11:29

TBA

1,077
5
41
80

Can you please show me how to do it with `linq`? – Azhar Hussain Aug 13 '18 at 11:31

score 0 · Answer 2 · answered Aug 13 '18 at 11:49

0

You may try Contains in Linq query like this

(from p in GetProducts()
       where prodIDs.Contains(p.ProductID)
       select p).ToArray<Product>();

answered Aug 13 '18 at 11:49

Thirupathi cst

127
2
10

Accessing all Records outside For Loop ASP.Net MVC 5

2 Answers2