Show / Hide Table of Contents

Class QueryExectionExtensions

Inheritance
Object
QueryExectionExtensions
Namespace: SuperOffice.Data
Assembly: SoDataBase.dll
Syntax
public static class QueryExectionExtensions : Object

Methods

ExecuteNonQuery(SqlCommand)

Declaration
public static int ExecuteNonQuery(this SqlCommand command)
Parameters
Type Name Description
SqlCommand command
Returns
Type Description
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

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

ExecuteScalar<T>(SqlCommand, Boolean)

Declaration
public static T ExecuteScalar<T>(this SqlCommand command, bool ignoreSentry)
Parameters
Type Name Description
SqlCommand command
Boolean ignoreSentry
Returns
Type Description
T
Type Parameters
Name Description
T

GetFieldPropertyRead(QueryExecutionHelper, FieldInfo)

Declaration
public static FieldProperty GetFieldPropertyRead(this QueryExecutionHelper qeh, FieldInfo field)
Parameters
Type Name Description
QueryExecutionHelper qeh
FieldInfo field
Returns
Type Description
FieldProperty
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top