Class StoredProcedure

SQL stored procedure

Inheritance

Object

StoredProcedure

Implements

IEnumerable<QueryParam>

IEnumerable

Inherited Members

Object.Equals(Object)

Object.Equals(Object, Object)

Object.GetHashCode()

Object.GetType()

Object.MemberwiseClone()

Object.ReferenceEquals(Object, Object)

Namespace: XData.Database.Adapter

Assembly: XData.docfx.dll

Syntax

public sealed class StoredProcedure : IEnumerable<QueryParam>, IEnumerable

Constructors

StoredProcedure(String, QueryParam[])

Procedure constructor

Declaration

public StoredProcedure(string name, params QueryParam[] par)

Parameters

Type	Name	Description
String	name	Procedure name
QueryParam[]	par	Parameters

Properties

Hint

Procedure hint

Declaration

public HintInfo Hint { get; set; }

Property Value

Type	Description
HintInfo

Item[Int32]

Query parameters by index

Declaration

public QueryParam this[int i] { get; }

Parameters

Type	Name	Description
Int32	i	Parameter index

Property Value

Type	Description
QueryParam	Query parameter

Item[String]

Procedure parameters by name

Declaration

public QueryParam this[string name] { get; set; }

Parameters

Type	Name	Description
String	name	Parameter name

Property Value

Type	Description
QueryParam	Procedure parameter

Name

SQL stored procedure name

Declaration

public string Name { get; }

Property Value

Type	Description
String

ResultSets

Stored procedure result sets names

Declaration

public IList<string> ResultSets { get; }

Property Value

Type	Description
IList<String>

Methods

GetEnumerator()

Query parameters enumeration

Declaration

public IEnumerator<QueryParam> GetEnumerator()

Returns

Type	Description
IEnumerator<QueryParam>	Query parameters enumeration

ToString()

Returns a String that represents the current Object.

Declaration

public override string ToString()

Returns

Type	Description
String	A String that represents the current Object.

Overrides

Object.ToString()

Operators

Implicit(String to StoredProcedure)

Stored procedure name

Declaration

public static implicit operator StoredProcedure(string s)

Parameters

Type	Name	Description
String	s	Procedure name

Returns

Type	Description
StoredProcedure	Stored procedure

Explicit Interface Implementations

IEnumerable.GetEnumerator()

Query parameters enumeration

Declaration

IEnumerator IEnumerable.GetEnumerator()

Returns

Type	Description
IEnumerator	Query parameters enumeration

Implements

System.Collections.Generic.IEnumerable<T>

System.Collections.IEnumerable

Extension Methods

SerializationExtensions.ToXml<T>(T)

CollectionsExtensions.ToSortedSet<T>(IEnumerable<T>, IComparer<T>)

CollectionsExtensions.SetValue<TKey, T>(TKey, T)

CollectionsExtensions.AsEnum<T>(T)

DataObjectQueryableExtensions.CompareVariable(Object, FilterOperation, String)

JoinedEnumerable.Inner<TElement>(IEnumerable<TElement>)

JoinedEnumerable.Outer<TElement>(IEnumerable<TElement>)

JoinedEnumerable.LeftOuterJoin<TOuter, TInner, TKey, TResult>(IEnumerable<TOuter>, IEnumerable<TInner>, Func<TOuter, TKey>, Func<TInner, TKey>, Func<TOuter, TInner, TResult>, IEqualityComparer<TKey>)

JoinedEnumerable.RightOuterJoin<TOuter, TInner, TKey, TResult>(IEnumerable<TOuter>, IEnumerable<TInner>, Func<TOuter, TKey>, Func<TInner, TKey>, Func<TOuter, TInner, TResult>, IEqualityComparer<TKey>)

JoinedEnumerable.FullOuterJoin<TOuter, TInner, TKey, TResult>(IEnumerable<TOuter>, IEnumerable<TInner>, Func<TOuter, TKey>, Func<TInner, TKey>, Func<TOuter, TInner, TResult>, IEqualityComparer<TKey>)

Processing.Do<T>(T, Action<IProcess<T>>[])

TypeExtensions.TryConvert<T, TResult>(T, Func<T, TResult>)

TypeExtensions.TryConvert<T, TResult>(T, Func<T, TResult>, TResult)

TypeExtensions.ChangeType<T>(Object)

TypeExtensions.ChangeType(Object, Type)

TypeExtensions.InvokeMethod<TRet>(Object, Type[], Expression<Func<TRet>>, BindingFlags)

TypeExtensions.InvokeMethod(Object, Type[], Expression<Action>, BindingFlags)

TypeExtensions.InvokeMethod<TRet>(Object, Expression<Func<TRet>>, BindingFlags)

TypeExtensions.InvokeMethod(Object, Expression<Action>, BindingFlags)

SqlBlockExtensions.SetExpression<TTag, TResult>(TTag, Expression<Func<IBlockQueryAdapter, TResult>>)

QueryDescriptionExtensions.SetExpression<TTag, TResult>(TTag, Expression<Func<IQueryStructureAdapter, TResult>>)

QueryDescriptionExtensions.ToDataSet<T>(IEnumerable<T>, String, ISqlBuilder)