KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
var sql = @"SELECT a.id AS `Id`, a.thing AS `Name`, b.id AS `CategoryId`, b.something AS `CategoryName` FROM .."; var products = connection.Query<Product, Category, Product>(sql, (product, category) => { product.Category = category; return product; }, splitOn: "CategoryId"); foreach(var p in products) { System.Diagnostics.Debug.WriteLine("{0} (#{1}) in {2} (#{3})", p.Name, p.Id, p.Category.Name, p.Category.Id); } Results in: 'First (#1) in (#0)' 'Second (#2) in (#0)' CategoryId and CategoryName has values since the following var products = connection.Query(sql).Select<dynamic, Product>(x => new Product { Id = x.Id, Name = x.Name, Category = new Category { Id = x.CategoryId, Name = x.CategoryName } }); Results in: 'First (#1) in My Category (#10)' 'Second (#2) in My Category (#10)' I'm connecting to a MySQL database if that has anything to do with it.
Tags (comma-separated)
Save Edits
Cancel