dotarj / dapper.mapper Goto Github PK

could it be possible to support one to many mapping

Hi, i use dapper.mapper. It is so useful.
I want to 3 join mapping. Can i do it with dapper.mapper?

string query = @"SELECT      p.*,c.*, s.*
                            FROM            dbo.Product AS p INNER JOIN
                                dbo.Category AS c ON c.CategoryId = p.CategoryId
                            INNER JOIN dbo.Company s ON s.CompanyId = p.CompanyId";

var product = connection.Query<Product, Category, Company>(sql);

Hello,

Say I have this:

string sql = "SELECT ...; SELECT ... INNER JOIN ...";

I would execute this via connection.QueryMultiple and then get the different results via multi.Read. However, I noticed that in that particular case, "Mapper.Dapper" does not provide a Read extension method that would allow me to do something like:

var obj = multi.Read<T1, T2>();

In this case, I'm forced to do something like this:

var obj = multi.Read<T1, T2, T1>((o1, o2) => { o1.Property = o2; return o1; }).ToList();