System.Data.SqlClient.SqlConnection does not contain a definition for Query with dapper and c#

Question

The following code when compiling gives the error message below:

'System.Data.SqlClient.SqlConnection' does not contain a definition for 'Query' and no extension method 'Query' accepting a first argument of type 'System.Data.SqlClient.SqlConnection' could be found (are you missing a using directive or an assembly reference?)

I have added Dapper using the nuget packager.

Any ideas? Thanks,

CODE:

using (SqlConnection sqlConnection = new SqlConnection(Connectionstring))
{
    sqlConnection.Open();
    Member customer = sqlConnection.Query<Member>("SELECT * FROM member");
    return customer;
}

You are most likely missing a using statement at the beginning of your file where the Query extension method is defined. — Ameen, Dec 26 '12 at 15:39

score 54 · Accepted Answer · answered Dec 26 '12 at 15:42

54

You need to place a using statement in your .cs file to make the Dapper extension methods available.

using ...;
using Dapper;
using ...;

answered Dec 26 '12 at 15:42

Fls'Zen

4,594
1
29
37

15

This should be part of Dapper docs. I don't understand why they assume that people should know this. – Jaylen Jul 26 '16 at 14:49
just spent 30 minutes on this T_T – Michael Snytko Jul 23 '21 at 08:05

System.Data.SqlClient.SqlConnection does not contain a definition for Query with dapper and c#

1 Answers1