Is there a way to do a 'select all' inside a select that returns an anon' object?

[Red_Wizard_Shot_The_Food]

Lets say "Things" is a table with 100+ columns and I want to pull back an anonymous object that is a combination of an entire "Thing" plus 3 or 4 related entries from Thing.Stuff.Blah e.g

database.Thing.Select(thing=> new {Name = thing.Stuff.Blah.Name, Age = thing.Stuff.Blah.Age, Car = thing.Stuff.Blah.Car, thing});

To produce an object like so: Name, Age, Car, ... plus another 100 properties from the Things table Or do i have to type out all those columns names eg: thing.x, thing .y and so on?? Thanks :)

[Howard Richards]

Not clear on why this is required, I'd probably just return the "thing" myself to access the properties that way. You could try writing a dynamic expression to do the select: google "LINQ dynamic expressions" for more info. You'd have to write a function that uses reflection to iterate through the properties and any sub-properties to populate the select.

'Howard