Search Results for

    Show / Hide Table of Contents

    Interface IQueryInfo

    Information pertaining to a particular data access query

    Namespace: LemonEdge.DataAccess.Core.Models
    Assembly: LemonEdge.DataAccess.Core.dll
    Syntax
    public interface IQueryInfo

    Properties

    CommandText

    The command text which will be used to execute the query

    Declaration
    string CommandText { get; }
    Property Value
    Type Description
    string

    CommandTimeout

    The query command timeout

    Declaration
    int CommandTimeout { get; }
    Property Value
    Type Description
    int

    CommandType

    The query CommandType

    Declaration
    CommandType CommandType { get; }
    Property Value
    Type Description
    CommandType

    Connection

    The IDbConnection to be used with the query

    Declaration
    IDbConnection Connection { get; }
    Property Value
    Type Description
    IDbConnection

    Parameters

    The collection of IDbDataParameter

    Declaration
    IEnumerable<IDbDataParameter> Parameters { get; }
    Property Value
    Type Description
    IEnumerable<IDbDataParameter>

    Transaction

    The IDbTransaction to be used with the query

    Declaration
    IDbTransaction? Transaction { get; }
    Property Value
    Type Description
    IDbTransaction

    Methods

    UpdateCommandText(string)

    Will update the current query command text with the provided commandText

    Declaration
    void UpdateCommandText(string commandText)
    Parameters
    Type Name Description
    string commandText

    UpdateCommandType(CommandType)

    Will update the current query command type with the provided commandType

    Declaration
    void UpdateCommandType(CommandType commandType)
    Parameters
    Type Name Description
    CommandType commandType

    UpdateParameters(IEnumerable<IDbDataParameter>?)

    Will update the current query parameters with the provided parameters. If null is provided, the parameters will be replaced with an empty array

    Declaration
    void UpdateParameters(IEnumerable<IDbDataParameter>? parameters)
    Parameters
    Type Name Description
    IEnumerable<IDbDataParameter> parameters

    UpdateTimeout(int)

    Will update the current query command timeout with the provided commandTimeout

    Declaration
    void UpdateTimeout(int commandTimeout)
    Parameters
    Type Name Description
    int commandTimeout

    Extension Methods

    LinqExtensions.AsArray<T>(T)
    LinqExtensions.ToArrayOfOne<T>(T)
    LinqExtensions.ToListOfOne<T>(T)
    MiscExtensions.SetIfNotEqual<T, TP>(T, Expression<Func<T, TP>>, TP)
    WeakReferenceExtensions.WeakReference(object)
    SQLExtensions.ToSQLValue(object, bool)
    ReflectionExtensions.ClearEventInvocations(object, string)
    StringExtensions.ToCSVFormatString(object, Type)
    In this article
    Back to top © LemonEdge Technologies. All rights reserved.