Breaking News: Grepper is joining You.com. Read the official announcement!

dapper multimap splitOn one to many

Inexpensive Ibis answered on July 11, 2022 Popularity 5/10 Helpfulness 1/10

answer dapper multimap splitOn one to many

dapper multimap splitOn one to many

Comment

using (var connection = new SQLiteConnection(connString))
{
    var sql = @"select productid, productname, p.categoryid, categoryname 
                from products p 
                inner join categories c on p.categoryid = c.categoryid";
    var products = await connection.QueryAsync<Product, Category, Product>(sql, (product, category) => {
        product.Category = category;
        return product;
    }, 
    splitOn: "CategoryId" );
    products.ToList().ForEach(product => Console.WriteLine($"Product: {product.ProductName}, Category: {product.Category.CategoryName}"));
    Console.ReadLine();
}

Popularity 5/10 Helpfulness 1/10 Language whatever

Source: www.learndapper.com

Tags: dapper multimap one-to-many whatever

Link to this answer
Share Copy Link