Hi

When creating an anonymous type with the following code

.....

var allShips = from ship in myDataContext.CruiseShips
select new { ship.Name, ship.CruiseLine.Name};

........

I get the following error 'An anonymous type cannot have multiple properties with the same name.' I could avoid this my renaming the fields (LineName & ShipName) but am loathe to mess about with my naming conventions for the sake of making it work. Is it possible to use aliases, or is there a simpler solution?

regards, Guy

Try this;

var allShips = from ship in myDataContext.CruiseShips
select new { ShipName=ship.Name, CruiseName=ship.CruiseLine.Name};


Rajeev.

Thanks Rajeev,

It works. Can you recommend a site/resource which covers Linq (for beginners!) matters like this?

regards, Guy

Try this link brother,

http://msdn.microsoft.com/en-us/vcsharp/aa336746.aspx

there are very helpful examples here.

Rajeev Rajput.

Thanks Rajeev,

That's exactly what I needed.

regards, Guy