Class DataCommand

Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database.

Inheritance

System.Object

DataCommand

Implements

IDataCommand

Namespace: Cuemon.Data

Assembly: Cuemon.Data.dll

Syntax

public class DataCommand : IDataCommand

Constructors

| Improve this Doc

DataCommand()

Initializes a new instance of the DataCommand class.

Declaration

public DataCommand()

| Improve this Doc

DataCommand(String)

Initializes a new instance of the DataCommand class.

Declaration

public DataCommand(string text)

Parameters

Type	Name	Description
System.String	text	The command text to execute.

| Improve this Doc

DataCommand(String, CommandType)

Initializes a new instance of the DataCommand class.

Declaration

public DataCommand(string text, CommandType type)

Parameters

Type	Name	Description
System.String	text	The command text to execute.
System.Data.CommandType	type	The command type value to execute.

| Improve this Doc

DataCommand(String, CommandType, Object[])

Initializes a new instance of the DataCommand class.

Declaration

public DataCommand(string textFormat, CommandType type, params object[] args)

Parameters

Type	Name	Description
System.String	textFormat	The command text to execute as a composite format string (see Remarks).
System.Data.CommandType	type	The command type value to execute.
System.Object[]	args	An object array that contains zero or more objects to format.

Remarks

For more information regarding the textFormat, have a look here: http://msdn.microsoft.com/en-us/library/txafckwd(v=vs.80).aspx.

| Improve this Doc

DataCommand(String, CommandType, TimeSpan)

Initializes a new instance of the DataCommand class.

Declaration

public DataCommand(string text, CommandType type, TimeSpan timeout)

Parameters

Type	Name	Description
System.String	text	The command text to execute.
System.Data.CommandType	type	The command type value to execute.
System.TimeSpan	timeout	The timeout for the command to execute.

| Improve this Doc

DataCommand(String, CommandType, TimeSpan, Object[])

Initializes a new instance of the DataCommand class.

Declaration

public DataCommand(string textFormat, CommandType type, TimeSpan timeout, params object[] args)

Parameters

Type	Name	Description
System.String	textFormat	The command text to execute as a composite format string (see Remarks).
System.Data.CommandType	type	The command type value to execute.
System.TimeSpan	timeout	The timeout for the command to execute.
System.Object[]	args	An object array that contains zero or more objects to format.

Remarks

For more information regarding the textFormat, have a look here: http://msdn.microsoft.com/en-us/library/txafckwd(v=vs.80).aspx.

| Improve this Doc

DataCommand(String, Object[])

Initializes a new instance of the DataCommand class.

Declaration

public DataCommand(string textFormat, params object[] args)

Parameters

Type	Name	Description
System.String	textFormat	The command text to execute as a composite format string (see Remarks).
System.Object[]	args	An object array that contains zero or more objects to format.

Remarks

For more information regarding the textFormat, have a look here: http://msdn.microsoft.com/en-us/library/txafckwd(v=vs.80).aspx.

| Improve this Doc

DataCommand(String, TimeSpan)

Initializes a new instance of the DataCommand class.

Declaration

public DataCommand(string text, TimeSpan timeout)

Parameters

Type	Name	Description
System.String	text	The command text to execute.
System.TimeSpan	timeout	The timeout for the command to execute.

| Improve this Doc

DataCommand(String, TimeSpan, Object[])

Initializes a new instance of the DataCommand class.

Declaration

public DataCommand(string textFormat, TimeSpan timeout, params object[] args)

Parameters

Type	Name	Description
System.String	textFormat	The command text to execute as a composite format string (see Remarks).
System.TimeSpan	timeout	The timeout for the command to execute.
System.Object[]	args	An object array that contains zero or more objects to format.

Remarks

For more information regarding the textFormat, have a look here: http://msdn.microsoft.com/en-us/library/txafckwd(v=vs.80).aspx.

Properties

| Improve this Doc

DefaultTimeout

Gets or sets the default wait time before terminating the attempt to execute a command and generating an error.

Declaration

public static TimeSpan DefaultTimeout { get; set; }

Property Value

Type	Description
System.TimeSpan	The System.TimeSpan to wait for the command to execute. Default value is 1 minute and 30 seconds.

| Improve this Doc

Text

Gets or sets the command text to execute.

Declaration

public string Text { get; set; }

Property Value

Type	Description
System.String	The command text to execute.

| Improve this Doc

Timeout

Gets or sets the wait time before terminating the attempt to execute a command and generating an error.

Declaration

public TimeSpan Timeout { get; set; }

Property Value

Type	Description
System.TimeSpan	The timespan to wait for the command to execute. Default value is 1 minute and 30 seconds.

| Improve this Doc

Type

Gets or sets the command type value to execute.

Declaration

public CommandType Type { get; set; }

Property Value

Type	Description
System.Data.CommandType	The command type value to exceute. Default type value is Text.

Implements

IDataCommand

Extension Methods

ConverterExtensions.ParseWith<TSource, TResult>(TSource, Func<TSource, TResult>)

ConverterExtensions.ParseWith<TSource, T, TResult>(TSource, Func<TSource, T, TResult>, T)

ConverterExtensions.ParseWith<TSource, T1, T2, TResult>(TSource, Func<TSource, T1, T2, TResult>, T1, T2)

ConverterExtensions.ParseWith<TSource, T1, T2, T3, TResult>(TSource, Func<TSource, T1, T2, T3, TResult>, T1, T2, T3)

ConverterExtensions.ParseWith<TSource, T1, T2, T3, T4, TResult>(TSource, Func<TSource, T1, T2, T3, T4, TResult>, T1, T2, T3, T4)

ConverterExtensions.ParseWith<TSource, T1, T2, T3, T4, T5, TResult>(TSource, Func<TSource, T1, T2, T3, T4, T5, TResult>, T1, T2, T3, T4, T5)

ConverterExtensions.ParseWith<TSource, T1, T2, T3, T4, T5, T6, TResult>(TSource, Func<TSource, T1, T2, T3, T4, T5, T6, TResult>, T1, T2, T3, T4, T5, T6)

ConverterExtensions.ParseWith<TSource, T1, T2, T3, T4, T5, T6, T7, TResult>(TSource, Func<TSource, T1, T2, T3, T4, T5, T6, T7, TResult>, T1, T2, T3, T4, T5, T6, T7)

ConverterExtensions.ParseWith<TSource, T1, T2, T3, T4, T5, T6, T7, T8, TResult>(TSource, Func<TSource, T1, T2, T3, T4, T5, T6, T7, T8, TResult>, T1, T2, T3, T4, T5, T6, T7, T8)

ConverterExtensions.ParseWith<TSource, T1, T2, T3, T4, T5, T6, T7, T8, T9, TResult>(TSource, Func<TSource, T1, T2, T3, T4, T5, T6, T7, T8, T9, TResult>, T1, T2, T3, T4, T5, T6, T7, T8, T9)

ConverterExtensions.As<TResult>(Object)

ConverterExtensions.As<TResult>(Object, TResult)

ConverterExtensions.As<TResult>(Object, TResult, IFormatProvider)

DelegateUtilityExtensions.Wrap<TResult>(TResult)

DelegateUtilityExtensions.DynamicWrap<TResult>(TResult)

TweakerExtensions.Adjust<T>(T, Func<T, T>)

TypeUtilityExtensions.Is<T>(Object)

TypeUtilityExtensions.IsNot<T>(Object)

TypeUtilityExtensions.IsNullable<T>(T)

WrapperExtensions.UseWrapper<T>(T, Action<IDictionary<String, Object>>)

WrapperExtensions.UseWrapper<T>(T, MemberInfo, Action<IDictionary<String, Object>>)

EnumerableUtilityExtensions.Yield<TSource>(TSource)

HashUtilityExtensions.ComputeHash(Object, Action<HashOptions>)

HmacUtilityExtensions.ComputeKeyedHash(Object, Byte[], Action<KeyedHashOptions>)