Mappings of different types, but same property name, conflict. about linqtoexcel

[paulyoder]

For this situation you will have to have separate instance of the ExcelQueryFactory.

An easy workaround for the transformations needed for the relationships is to select the data from each spreadsheet and convert it to a list before you do a transformation

var instance1 = new ExcelQueryFactory("worksheetFile");
instance1.AddMapping<Type1>(x => x.IdentificationName, "Type1 Identification Name");
var data1 = (from row in instance1.Worksheet<Type1>()
                  select row).ToList();

var instance2 = new ExcelQueryFactory("worksheetFile");
instance2.AddMapping<Type2>(x => x.IdentificationName, "Type2 Identification Name");
var data2 = (from row in instance2.Worksheet<Type1>()
                  select row).ToList();

Now that these are 2 in memory lists, you should have no problem with the transformation

[paqogomez]

Yes, my issue might have been better explained with these examples.

    instance.AddMapping<Type1>(x => x.IdentificationName, "Type1 Identification Name", x=> CreateType1WithType2(x));
    instance.AddMapping<Type2>(x => x.IdentificationName, "Type2 Identification Name");

This structure however was extremely slow with the recursive nature of my problem. Pulling the data out into lists as you suggest above and transforming in memory was a much better solution. Thanks!