Projecting related child tables where child tables have columns with the same name

I was wondering how I can tell LightSpeed to map the [Role].[Name] column on the RoleName property, and [Committee].[Name] column onto the ComitteeName property during Project(...);

Trying to avoid using the IDataReader version.

public class MemberResult
{
    string Name { get; set; }
    string RoleName { get; set; }
    string CommitteeName { get; set; }
}

Cheers

Andy

Unfortunately you cant since we are just performing a reflection based load against the IDataReader based overload when using Project against a known type so you will have to write something yourself to perform the mapping Im afraid.

You have probably noticed that this does work happily though if you use a LINQ based projection as we have a more sophisticated projection mapper in the LINQ side of the world so not sure if you can look at using that type of approach here instead?

Jeremy

Unfortunately I can't use LINQ in this situation as the query is built from a DSL.

Turns out, building a custom mapper wasn't that bad as the DSL knows what columns are being selected, in what order and where they appear on the result object.