Class QueryExectionExtensions

Inheritance

Object

QueryExectionExtensions

Inherited Members

Object.ToString()

Object.Equals(Object)

Object.Equals(Object, Object)

Object.ReferenceEquals(Object, Object)

Object.GetHashCode()

Object.GetType()

Object.MemberwiseClone()

Namespace: SuperOffice.Data

Assembly: SoDataBase.dll

Syntax

public static class QueryExectionExtensions

Methods

ExecuteNonQuery(SqlCommand)

Declaration

public static void ExecuteNonQuery(this SqlCommand command)

Parameters

Type	Name	Description
SqlCommand	command

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
Boolean	ignoreSentry

Returns

Type	Description
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

Type	Name	Description
SqlCommand	command

Returns

Type	Description
T

Type Parameters

Name	Description
T