Class QueryExectionExtensions
Inheritance
System.Object
QueryExectionExtensions
Assembly: SoDataBase.dll
Syntax
public static class QueryExectionExtensions : Object
Methods
ExecuteNonQuery(SqlCommand)
Declaration
public static int ExecuteNonQuery(this SqlCommand command)
Parameters
Returns
Type |
Description |
System.Int32 |
|
ExecuteReader(SqlCommand, Boolean)
Execute a SELECT statement against the database and return the results as an IEnumerable, suitable for linq expressions and iteration.
But please DON'T use the anti-pattern 'fetch everything then post-filter using Linq'; put all the restrictions you can
into the select before Fetch'ing the results.
Declaration
public static IEnumerable<ISoDataRecord> ExecuteReader(this SqlCommand command, bool ignoreSentry = false)
Parameters
Type |
Name |
Description |
SqlCommand |
command |
An SqlCommand that is a select
|
System.Boolean |
ignoreSentry |
|
Returns
Type |
Description |
System.Collections.Generic.IEnumerable<ISoDataRecord> |
Enumerable result, which contains FieldInfo-based Get methods for all common data types
|
ExecuteScalar<T>(SqlCommand)
Declaration
public static T ExecuteScalar<T>(this SqlCommand command)
Parameters
Returns
Type Parameters