8

I see the example of using Dapper in executing stored procedures with dynamic parameters, and returning the results of the procedure. Usually, the examples use .Execute, but a few of them use .Query. I have difficulty in using .Execute. Which am I supposed to use in the case described above--query or execute AND in what cases would I use each?

svick
  • 236,525
  • 50
  • 385
  • 514
Kevin Earley
  • 165
  • 2
  • 8

1 Answers1

14

If you need to return a value, then use Query(). If you need to execute a query that does not return anything, an update for example, then use Execute().

Query example:

var myList = connection.Query("select * from myTable")

Execute example:

connection.Execute("update myTable set columnA = @value", new {value = "ABC"})
Void Ray
  • 9,849
  • 4
  • 33
  • 53