I have a company that contains an address object. The SQL return is flat, and I'm tring to get Query<> to load all the objects.

cnn.Query<Company,Mailing,Physical,Company>("Sproc", 
                    (org,mail,phy) =>
                    {
                        org.Mailing = mail;
                        org.Physical = phy;
                        return org;
                    },
                    new { ListOfPartyId = stringList }, null, true, commandTimeout: null,
                    commandType: CommandType.StoredProcedure, splitOn: "MailingId,PhyscialId").ToList();

I'm not sure if i have the SplitOn correct either. I'm getting the message:

When using the multi-mapping APIs ensure you set the splitOn param if you have keys other than Id Parameter name: splitOn

Suggestions would be great.

The examples in the Test.cs are not what the code asks for as parameters for the queries. These need to be updated

c# dapper
Edit
Report