CODEWITHSUNDEEP
linq-to-sql
JOBG
JOBG

Reputation: 4624

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

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

Upvotes: 2

Views: 136

Answers (2)

JOBG
JOBG

Reputation: 4624

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 =).

Upvotes: 1

Arsen Mkrtchyan
Arsen Mkrtchyan

Reputation: 50712

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

Upvotes: 0

Related Questions