Linq to SQL : How do I get the property values from a query's results?

Question

I m just starting with microsoft (MVC,C#, LINQ), so far so good, but i have a question about LINQ uses, How do i get the value form a LINQ like this one?

            var x = from a in db.tablex
                    where a.eventID == eventID
                    select new
                    {
                       owner = a.owner,
                        shipper = a.shipper,
                        consignee = a.consignee
                    };

I try something like "r.owner" inside a foreach to get the value retrieved from DB

foreach (var r in x)

but its not working.. i dont get intellisense either.. how do i get the value??. I saw several examples and it seems to work like this, but for some reason its not working.. Thanks

JOBG · Accepted Answer · 2009-06-06 14:21:21Z

1

Ok guys here was the thing, (it wasnt the typo it was just in the post), i was missing a using :

using System.Reflection;

with this C# automatically creates a class from them, and now it works

What a noob of me =).

answered Jun 6, 2009 at 14:21

JOBG

4,6244 gold badges30 silver badges48 bronze badges

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

Comments

Arsen Mkrtchyan · Accepted Answer · 2009-06-06 08:06:37Z

0

foreach (var r in x)
{
 var owner = r.owner;// not x.owner
}

edited Jun 6, 2009 at 8:06

answered Jun 6, 2009 at 7:25

Arsen Mkrtchyan

50.9k33 gold badges155 silver badges187 bronze badges

1 Comment

Marc Gravell Over a year ago

introducing a again is probably only going to add confusion... "var owner = r.owner;" would probably be clearer...

Collectives™ on Stack Overflow

Linq to SQL : How do I get the property values from a query's results?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related