dapper aggregation function error

Question

have this aggregation function in my code using Dapper

var sql = (@"SELECT *  
                  FROM [pubs].[dbo].[authors] as a
                  right join pubs.dbo.titleauthor as b 
                  ON a.au_id = b.au_idT");

 var data = connection.QueryMultiple(sql).Map<authors, titleauthor, string>(
     au=> au.au_id,
     tit=> tit.au_idT,
     (au,tits)=>{au.titleauthor=tits};);

there is no cast error and every objects fits well but i keep have this error

} expected or ; expected and Invalid expression term ')'

i have no idea why. any help is appreciated.

this was taken from the solution in [link](http://stackoverflow.com/questions/6379155/help-with-multi-mapper-to-create-object-hierarchy/6380756#6380756) — MuhanadY, Oct 09 '13 at 07:23

score 3 · Accepted Answer · edited Oct 09 '13 at 07:31

3

Swap the } and ;:

var data = connection.QueryMultiple(sql).Map<authors, titleauthor, string>(
     au=> au.au_id,
     tit=> tit.au_idT,
     (au,tits)=>{au.titleauthor=tits;}); // <=== this line

edited Oct 09 '13 at 07:31

Marc Gravell

1,026,079
266
2,566
2,900

answered Oct 09 '13 at 07:15

Phillip Ngan

15,482
8
63
79

1

(added an example, but basically: this) – Marc Gravell Oct 09 '13 at 07:32

dapper aggregation function error

1 Answers1