Class BaseStoredProcedure

Inheritance

System.Object

BaseStoredProcedure

StoredProcedure

UserDefinedFunction

Implements

IParametrizedQuery

ISqlGenerating

IDBReadableCommand

System.ICloneable

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Terrasoft.Core.DB

Assembly: Terrasoft.Core.dll

Syntax

public abstract class BaseStoredProcedure : IParametrizedQuery, ISqlGenerating, IDBReadableCommand, ICloneable

Constructors

BaseStoredProcedure(BaseStoredProcedure)

Declaration

protected BaseStoredProcedure(BaseStoredProcedure source)

Parameters

Type	Name	Description
BaseStoredProcedure	source

BaseStoredProcedure(UserConnection)

Declaration

protected BaseStoredProcedure(UserConnection userConnection)

Parameters

Type	Name	Description
UserConnection	userConnection

BaseStoredProcedure(UserConnection, String)

Declaration

protected BaseStoredProcedure(UserConnection userConnection, string name)

Parameters

Type	Name	Description
UserConnection	userConnection
System.String	name

Properties

BuildParametersAsValue

Declaration

public bool BuildParametersAsValue { get; set; }

Property Value

Type	Description
System.Boolean

CachedSqlText

Declaration

public string CachedSqlText { get; set; }

Property Value

Type	Description
System.String

DBEngine

Declaration

protected DBEngine DBEngine { get; }

Property Value

Type	Description
DBEngine

Expressions

Declaration

public QueryColumnExpressionCollection Expressions { get; }

Property Value

Type	Description
QueryColumnExpressionCollection

HasExpressions

Declaration

public bool HasExpressions { get; }

Property Value

Type	Description
System.Boolean

HasParameters

Declaration

public bool HasParameters { get; }

Property Value

Type	Description
System.Boolean

IsCacheEnabled

Declaration

public bool IsCacheEnabled { get; set; }

Property Value

Type	Description
System.Boolean

Name

Declaration

public string Name { get; set; }

Property Value

Type	Description
System.String

PackageName

Declaration

public string PackageName { get; set; }

Property Value

Type	Description
System.String

Parameters

Declaration

public QueryParameterCollection Parameters { get; }

Property Value

Type	Description
QueryParameterCollection

UserConnection

Declaration

protected UserConnection UserConnection { get; set; }

Property Value

Type	Description
UserConnection

Methods

BuildSqlText(StringBuilder)

Declaration

public abstract void BuildSqlText(StringBuilder sb)

Parameters

Type	Name	Description
System.Text.StringBuilder	sb

Clone()

Declaration

public abstract object Clone()

Returns

Type	Description
System.Object

ExecuteReader(DBExecutor)

Declaration

public virtual IDataReader ExecuteReader(DBExecutor dbExecutor)

Parameters

Type	Name	Description
DBExecutor	dbExecutor

Returns

Type	Description
System.Data.IDataReader

ExecuteScalar<TResult>()

Declaration

public virtual TResult ExecuteScalar<TResult>()

Returns

Type	Description
TResult

Type Parameters

Name	Description
TResult

ExecuteScalar<TResult>(DBExecutor)

Declaration

public virtual TResult ExecuteScalar<TResult>(DBExecutor dbExecutor)

Parameters

Type	Name	Description
DBExecutor	dbExecutor

Returns

Type	Description
TResult

Type Parameters

Name	Description
TResult

GetSqlText()

Declaration

public abstract string GetSqlText()

Returns

Type	Description
System.String

GetUsingParameters()

Declaration

public QueryParameterCollection GetUsingParameters()

Returns

Type	Description
QueryParameterCollection

InitializeParameters()

Declaration

public void InitializeParameters()

ResetCachedSqlText()

Declaration

public void ResetCachedSqlText()

ResetParameters()

Declaration

public void ResetParameters()

WithOutputParameter(String, DataValueType)

Declaration

public BaseStoredProcedure WithOutputParameter(string name, DataValueType type)

Parameters

Type	Name	Description
System.String	name
DataValueType	type

Returns

Type	Description
BaseStoredProcedure

WithParameter(IEnumerable<IQueryColumnExpressionConvertible>)

Declaration

public BaseStoredProcedure WithParameter(IEnumerable<IQueryColumnExpressionConvertible> expressions)

Parameters

Type	Name	Description
System.Collections.Generic.IEnumerable<IQueryColumnExpressionConvertible>	expressions

Returns

Type	Description
BaseStoredProcedure

WithParameter(Stream)

Declaration

public BaseStoredProcedure WithParameter(Stream value)

Parameters

Type	Name	Description
System.IO.Stream	value

Returns

Type	Description
BaseStoredProcedure

WithParameter(Object)

Declaration

public BaseStoredProcedure WithParameter(object value)

Parameters

Type	Name	Description
System.Object	value

Returns

Type	Description
BaseStoredProcedure

WithParameter(String, Stream)

Declaration

public BaseStoredProcedure WithParameter(string name, Stream value)

Parameters

Type	Name	Description
System.String	name
System.IO.Stream	value

Returns

Type	Description
BaseStoredProcedure

WithParameter(String, Object)

Declaration

public BaseStoredProcedure WithParameter(string name, object value)

Parameters

Type	Name	Description
System.String	name
System.Object	value

Returns

Type	Description
BaseStoredProcedure

WithParameter(IQueryColumnExpressionConvertible)

Declaration

public BaseStoredProcedure WithParameter(IQueryColumnExpressionConvertible expression)

Parameters

Type	Name	Description
IQueryColumnExpressionConvertible	expression

Returns

Type	Description
BaseStoredProcedure

WithParameter(QueryColumnExpression)

Declaration

public BaseStoredProcedure WithParameter(QueryColumnExpression columnExpression)

Parameters

Type	Name	Description
QueryColumnExpression	columnExpression

Returns

Type	Description
BaseStoredProcedure

WithParameter(QueryParameter)

Declaration

public BaseStoredProcedure WithParameter(QueryParameter parameter)

Parameters

Type	Name	Description
QueryParameter	parameter

Returns

Type	Description
BaseStoredProcedure

WithParameters(IEnumerable<QueryColumnExpression>)

Declaration

public BaseStoredProcedure WithParameters(IEnumerable<QueryColumnExpression> columnExpressions)

Parameters

Type	Name	Description
System.Collections.Generic.IEnumerable<QueryColumnExpression>	columnExpressions

Returns

Type	Description
BaseStoredProcedure

WithParameters(IEnumerable<QueryParameter>)

Declaration

public BaseStoredProcedure WithParameters(IEnumerable<QueryParameter> parameters)

Parameters

Type	Name	Description
System.Collections.Generic.IEnumerable<QueryParameter>	parameters

Returns

Type	Description
BaseStoredProcedure

WithVarParameter(String, Stream)

Declaration

public BaseStoredProcedure WithVarParameter(string name, Stream value)

Parameters

Type	Name	Description
System.String	name
System.IO.Stream	value

Returns

Type	Description
BaseStoredProcedure

WithVarParameter(String, Object, DataValueType)

Declaration

public BaseStoredProcedure WithVarParameter(string name, object value, DataValueType type)

Parameters

Type	Name	Description
System.String	name
System.Object	value
DataValueType	type

Returns

Type	Description
BaseStoredProcedure

Implements

IParametrizedQuery

ISqlGenerating

IDBReadableCommand

System.ICloneable

Extension Methods

ReflectionUtilities.GetPropertyValue(Object, String)

ReflectionUtilities.GetPropertyDefValue(Object, String, Object)

ReflectionUtilities.TryGetPropertyValue(Object, String, out Object)

ReflectionUtilities.HasProperty(Object, String)

ReflectionUtilities.GetPropertyValue(Object, String, BindingFlags)

ReflectionUtilities.GetPropertyValueByPath(Object, String)

ReflectionUtilities.SetPropertyValue(Object, String, Object)

ReflectionUtilities.TrySetPropertyValue(Object, String, Object)

ValidateUtilities.CheckArgumentNull(Object, String)

ValidateUtilities.CheckDependencyNull(Object, String)

ValidateUtilities.EnsureDependencyNotNull<T>(T, String)