Dapper invalid type owner

Question

I was just trying out Dapper for the very first time.

When I try to execute a query like the following, I encounter an ArgumentException "invalid type owner for DynamicMethod". Unlinke in this question, inserts work just fine when using Execute().

var parameters = new[] { new { accountName = name, accountPassword = password } };
var accounts = connection.Query<Account>(@"SELECT * FROM " + this.TableName + " WHERE name = @accountName AND password = @accountPassword", parameters);

I am building against .NET 4.5 on Win7.

Can anybody tell what I am doing wrong?

Have you tried passing `parameters` in as basic anonymous type (not in an array)? — SteveChapman, May 26 '14 at 09:09
That's it! Thank you very much! I cayrried this over from the insert example ^^ Care to write it as an answer so I can accept it? — Structed, May 26 '14 at 09:14
I'll have to check where that exception message comes from, but I'm glad the issue is fixed. — Marc Gravell, May 26 '14 at 09:57

E.J. Brennan · Accepted Answer · 2014-05-26T11:42:34.413

10

Your parameters should just be:

var parameters = new { accountName = name, accountPassword = password };

Not sure what you are trying to do with the new[] new

edited May 26 '14 at 11:42

answered May 26 '14 at 09:16

E.J. Brennan

45,870
7
88
116

Thank you and @chappoo for this hint. Carried it over from the insert example. But of course, it doesn't make sense here. Thanks a lot! – Structed May 26 '14 at 09:20

Dapper invalid type owner

1 Answers1