Deep nested classes

[john-aaron-owens]

Could someone take a look and tell me why Order.OrderDetails is returning as null after the map. The sql works and there is order details in the database. I can get nesting working for the 1 level, but not 2.

btw - I may have a typo as I had to rename the class and fields but the sql does work and no exceptions are being thrown. It just can't find the data which is nested a the 2nd level.

public class Project
{
public long ProjectId { get; set; }
public IEnumerable Orders { get; set; }
}

public class Order
{
public long OrderId { get; set; }
public IEnumerable OrderDetails{ get; set; }
}

public class OrderDetail
{
public long OrderDetailId { get; set; }
}

        var sql = $@"

SELECT
p.Project_ID AS ProjectId
o.Order_ID AS Order_OrderId,
od.Order_Detail_ID AS Order_OrderDetail_OrderDetailId,
FROM
Project AS p
LEFT JOIN Order AS o ON p.Order_ID = o.Order_ID
LEFT JOIN OrderDetail AS od ON o.Order_Detail_ID = od.Order_Detail_ID
";

        Slapper.AutoMapper.Cache.ClearInstanceCache();

        Slapper.AutoMapper.Configuration.AddIdentifiers(typeof(ProjectSampleSetLegacyPortal),
            new List<string> { "ProjectId" });
        Slapper.AutoMapper.Configuration.AddIdentifiers(typeof(StatsLegacyPortal),
            new List<string> { "OrderId" });
        Slapper.AutoMapper.Configuration.AddIdentifiers(typeof(StatsDetailLegacyPortal),
            new List<string> { "OrderDetailId" });

        var results =
            Slapper.AutoMapper.MapDynamic<Project>(query).First();

[randyburden]

The column alias in your SQL query is not correct. You need to change from “Order_OrderId” to “Orders_OrderId”. Essentially you need to make the alias match the name of the property name on your object which is plural “Orders”.