Tests.DapperReadmeVsChain.Example6_Dapper C# (CSharp) Method

        public void Example6_Dapper()
        {

            SetupExample6();


            using (var connection = new SqlConnection(s_ConnectionString))
            {
                var sql =
  @"select * from Posts p 
            left join Users u on u.Id = p.OwnerId 
            Order by p.Id";

                var data = connection.Query<Post, User, Post>(sql, (p, user) => { p.Owner = user; return p; });
                var post = data.First();

                Assert.AreEqual("Sams Post1", post.Content);
                Assert.AreEqual(1, post.Id);
                Assert.AreEqual("Sam", post.Owner.Name);
                Assert.AreEqual(99, post.Owner.Id);
            }
        }