|The underlying database connection - the |
this denotes an extension method; the connection does not need to be open - if it is not open, it is opened and closed automatically.
|(optional) The type of object to return; if the non-generic / non-|
Type API is used, a
dynamic object is returned per row, simulating a property named per column name returned from the query (this
dynamic object also implements
|The SQL to execute|
|(optional) The parameters to include.|
|(optional) The database transaction to associate with the command|
|(optional) Whether to pre-consume the data into a list (the default), versus exposing an open |
IEnumerable over the live reader
|(optional) The timeout to use on the command; if not specified, |
SqlMapper.Settings.CommandTimeout is assumed (if specified)
|The type of command being performed; defaults to |
The syntax for expressing parameters varies between RDBMS. All the examples above use SQL Server syntax, i.e.
:foo should also work fine.
This modified text is an extract of the original Stack Overflow Documentation created by following contributors
and released under CC BY-SA 3.0