Show / Hide Table of Contents

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
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top