Return List<Object> from Linq SQL (Lambda) with join and where

Question

In C#, I need to retrieve a List<Object> using linq with lamba expression. This is the case:

List<TAB1> itemList = 
  context.TAB1.Join(
  context.TAB2, itm => itm.ItemCode, bcd => bcd.ItemCode, (itm, bcd) => new { ITM = itm, BCD = bcd })
                     .Where(i => i.ITM.ItemCode == (itemCode ?? i.ITM.ItemCode))
                     .Where(i => i.BCD.BcdCode.Contains(codeBars ?? i.BCD.BcdCode)).ToList();

At the moment that retrieves me a list<AnonymousType>, but I need a List<TAB1> that only return the values of that table.

EDIT: The returned List<TAB1> needs to replace one property (TAB1.Barcode) with TAB2.BcdCode (it's the same type). How can I do it?

Backs · Accepted Answer · 2016-06-10 02:45:36Z

4

Add Select statement after filters:

List<TAB1> itemList = 
  context.TAB1.Join(
  context.TAB2, itm => itm.ItemCode, bcd => bcd.ItemCode, (itm, bcd) => new { ITM = itm, BCD = bcd })
                     .Where(i => i.ITM.ItemCode == (itemCode ?? i.ITM.ItemCode))
                     .Where(i => i.BCD.BcdCode.Contains(codeBars ?? i.BCD.BcdCode))
.Select(i => i.ITM)
.ToList();

answered Jun 10, 2016 at 2:45

Backs

25k5 gold badges66 silver badges92 bronze badges

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

1 Comment

oldkefka Over a year ago

Thanks, but I have a new question: If I want to replace one property of the TAB1 (TAB1.CodeBars) with one in TAB2 (TAB2.BcdCode), what I need to change in the select.

Collectives™ on Stack Overflow

Return List<Object> from Linq SQL (Lambda) with join and where

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related