Class QueryInfo

Inheritance

object

QueryInfo

Implements

IQueryInfo

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Namespace: LemonEdge.DataAccess.Core.Models

Assembly: LemonEdge.DataAccess.Core.dll

Syntax

public class QueryInfo : IQueryInfo

Constructors

QueryInfo(IDbConnection, IDbTransaction, string)

Declaration

public QueryInfo(IDbConnection connection, IDbTransaction transaction, string commandText)

Parameters

Type	Name	Description
IDbConnection	connection
IDbTransaction	transaction
string	commandText

QueryInfo(IDbConnection, IDbTransaction, string, IEnumerable<IDbDataParameter>)

Declaration

public QueryInfo(IDbConnection connection, IDbTransaction transaction, string commandText, IEnumerable<IDbDataParameter> parameters)

Parameters

Type	Name	Description
IDbConnection	connection
IDbTransaction	transaction
string	commandText
IEnumerable<IDbDataParameter>	parameters

QueryInfo(IDbConnection, IDbTransaction, string, IEnumerable<IDbDataParameter>, CommandType)

Declaration

public QueryInfo(IDbConnection connection, IDbTransaction transaction, string commandText, IEnumerable<IDbDataParameter> parameters, CommandType commandType)

Parameters

Type	Name	Description
IDbConnection	connection
IDbTransaction	transaction
string	commandText
IEnumerable<IDbDataParameter>	parameters
CommandType	commandType

QueryInfo(IDbConnection, IDbTransaction?, string, IEnumerable<IDbDataParameter>, CommandType, int)

Declaration

public QueryInfo(IDbConnection connection, IDbTransaction? transaction, string commandText, IEnumerable<IDbDataParameter> parameters, CommandType commandType, int commandTimeout)

Parameters

Type	Name	Description
IDbConnection	connection
IDbTransaction	transaction
string	commandText
IEnumerable<IDbDataParameter>	parameters
CommandType	commandType
int	commandTimeout

QueryInfo(IDbConnection, IDbTransaction, string, int)

Declaration

public QueryInfo(IDbConnection connection, IDbTransaction transaction, string commandText, int commandTimeout)

Parameters

Type	Name	Description
IDbConnection	connection
IDbTransaction	transaction
string	commandText
int	commandTimeout

QueryInfo(IDbConnection, string)

Declaration

public QueryInfo(IDbConnection connection, string commandText)

Parameters

Type	Name	Description
IDbConnection	connection
string	commandText

QueryInfo(IDbConnection, string, IEnumerable<IDbDataParameter>)

Declaration

public QueryInfo(IDbConnection connection, string commandText, IEnumerable<IDbDataParameter> parameters)

Parameters

Type	Name	Description
IDbConnection	connection
string	commandText
IEnumerable<IDbDataParameter>	parameters

QueryInfo(IDbConnection, string, IEnumerable<IDbDataParameter>, CommandType)

Declaration

public QueryInfo(IDbConnection connection, string commandText, IEnumerable<IDbDataParameter> parameters, CommandType commandType)

Parameters

Type	Name	Description
IDbConnection	connection
string	commandText
IEnumerable<IDbDataParameter>	parameters
CommandType	commandType

QueryInfo(IDbConnection, string, int)

Declaration

public QueryInfo(IDbConnection connection, string commandText, int commandTimeout)

Parameters

Type	Name	Description
IDbConnection	connection
string	commandText
int	commandTimeout

Properties

CommandText

The command text which will be used to execute the query

Declaration

public string CommandText { get; }

Property Value

Type	Description
string

CommandTimeout

The query command timeout

Declaration

public int CommandTimeout { get; }

Property Value

Type	Description
int

CommandType

The query CommandType

Declaration

public CommandType CommandType { get; }

Property Value

Type	Description
CommandType

Connection

The IDbConnection to be used with the query

Declaration

public IDbConnection Connection { get; }

Property Value

Type	Description
IDbConnection

Parameters

The collection of IDbDataParameter

Declaration

public IEnumerable<IDbDataParameter> Parameters { get; }

Property Value

Type	Description
IEnumerable<IDbDataParameter>

Transaction

The IDbTransaction to be used with the query

Declaration

public IDbTransaction? Transaction { get; }

Property Value

Type	Description
IDbTransaction

Methods

UpdateCommandText(string)

Will update the current query command text with the provided commandText

Declaration

public void UpdateCommandText(string commandText)

Parameters

Type	Name	Description
string	commandText

UpdateCommandType(CommandType)

Will update the current query command type with the provided commandType

Declaration

public 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

public 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

public void UpdateTimeout(int commandTimeout)

Parameters

Type	Name	Description
int	commandTimeout

Implements

IQueryInfo

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)