select statement without where clause in Dapper targeting .net3.5 framework

Question

I am using Dapper micro-ORM in my project where i want to select all the records from table. Below is my code.

 var result = connection.Query<Department>("Select * From Department");

and i am getting the following error

No Overload for method 'Query' takes 1 argument

My project's target framework is .net 3.5. If i just change the project's target framework to .net 4.0, and re-install dapper (using nuget) everything is working good.

i don't want to use where clause (i.e. no additional parameter for query method). Is there a way to run this query using dapper targeting .net 3.5 framework?

Marc Gravell · Accepted Answer · 2012-08-13 19:36:06Z

2

In the current code, you must pass a param argument in the NET35 build. This can be null. Try:

var result = connection.Query<Department>("select * from Department", null);

answered Aug 13, 2012 at 19:36

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Marc Gravell Over a year ago

and if that doesn't work, let me know and I'll deploy the code to NuGet

Collectives™ on Stack Overflow

select statement without where clause in Dapper targeting .net3.5 framework

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related