Extracting data from two Tables using LINQ

Question

I got two tables OrderHead and Labeldata, both these two tables don't have any relationship. I want to extract data from these two table, I am using following LINQ:

var ODetail = (
    from o in oContext.OrderHeads
    join l in oContext.LIT04LABELDATA on o.CUSTORD equals l.ORDERNUMBER
    where l.ORDERNUMBER == oNumber
    select new { LIT04LABELDATA = l, OrderHead = o }
).ToList();

I want to use the data from both these tables, but I don't know how to extract data from the variable oDetail, any suggestions?

Can you specify the expected number of results from each table? — Henk Holterman
– Henk Holterman, Commented Nov 23, 2011 at 11:38

Dave · Accepted Answer · 2011-11-23 11:58:16Z

2

You're creating an anonymous type which has two types as its properties. Unlike in a SQL query, the hierarchy is preserved here so oDetail won't contain CUSTORD but oDetail.OrderHead will. You need to query as:

foreach(var detail in ODetail)
{
    Console.WriteLine( detail.LIT04LABELDATA.ORDERNUMBER + "   " + detail.ORDERHEAD.CUSTORD );
}

answered Nov 23, 2011 at 11:58

Dave

3,6311 gold badge24 silver badges25 bronze badges

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

Comments

Reza ArabQaeni · Accepted Answer · 2011-11-25 00:22:35Z

0

var b=oContext.OrderHeads
.Where(p => oContext.LIT04LABELDATA.Where(q=>q.ORDERNUMBER==oNumber)
      .Select(q => q.ORDERNUMBER).Contains(p.CUSTORD))
.Select(p => new
{
    LIT04LABELDATA = oContext.LIT04LABELDATA
       .FirstOrDefault(q=>q.ORDERNUMBER==p.CUSTORD),
    OrderHead =p,
}).ToList();

answered Nov 25, 2011 at 0:22

Reza ArabQaeni

4,91830 silver badges48 bronze badges

Collectives™ on Stack Overflow

Extracting data from two Tables using LINQ

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related