var sql = @"select p.ProductName,p.CreateTime,u.UserName
from Product as p
join Users as u
on p.UserID = u.UserID
where p.CreateTime > '2015-12-12'; ";
var result = connection.Query<Product, Users, Product>(sql,
(product, users) =>
{
product.UserOwner = users; return product;
},splitOn: "UserName");