Class SqlDataManager

The SqlDataManager is the primary class of the Cuemon.Data.SqlClient namespace that can be used to execute commands targeted Microsoft SQL Server.

Inheritance
System.Object
DataManager
SqlDataManager
Inherited Members
Namespace: Cuemon.Data.SqlClient
Assembly: Cuemon.Data.dll
Syntax
public class SqlDataManager : DataManager

Constructors

| Improve this Doc

SqlDataManager()

Initializes a new instance of the SqlDataManager class. Will resolve the default data connection element from the calling application, using the ConfigurationManager to get a CuemonDataSection.

Declaration
protected SqlDataManager()
| Improve this Doc

SqlDataManager(String)

Initializes a new instance of the SqlDataManager class.

Declaration
public SqlDataManager(string connectionString)
Parameters
Type Name Description
System.String connectionString

The connection string used to establish the connection.

Properties

| Improve this Doc

ConnectionString

Gets the string used to open a SQL Server database.

Declaration
public override string ConnectionString { get; }
Property Value
Type Description
System.String

The connection string that includes the source database name, and other parameters needed to establish the initial connection.
Overrides
| Improve this Doc

TransientFaultHandlingOptionsCallback

Gets or sets the callback delegate that will provide options for transient fault handling.

Declaration
public override Action<TransientOperationOptions> TransientFaultHandlingOptionsCallback { get; set; }
Property Value
Type Description
System.Action<TransientOperationOptions>

An System.Action<T> with the options for transient fault handling.
Overrides
Remarks

This implementation is compatible with transient related faults on Microsoft SQL Azure including the latest addition of error code 10928 and 10929.
Microsoft SQL Server is supported as well.

Methods

| Improve this Doc

Clone()

Creates a new object that is a copy of the current instance.

Declaration
public override DataManager Clone()
Returns
Type Description
DataManager

A new object that is a copy of this instance.
Overrides
| Improve this Doc

ExecuteIdentityDecimal(IDataCommand, DbParameter[])

Executes the command statement and returns an identity value as decimal.

Declaration
public override decimal ExecuteIdentityDecimal(IDataCommand dataCommand, params DbParameter[] parameters)
Parameters
Type Name Description
IDataCommand dataCommand

The data command to execute.
System.Data.Common.DbParameter[] parameters

The parameters to use in the command.
Returns
Type Description
System.Decimal

System.Decimal
Overrides
| Improve this Doc

ExecuteIdentityInt32(IDataCommand, DbParameter[])

Executes the command statement and returns an identity value as int.

Declaration
public override int ExecuteIdentityInt32(IDataCommand dataCommand, params DbParameter[] parameters)
Parameters
Type Name Description
IDataCommand dataCommand

The data command to execute.
System.Data.Common.DbParameter[] parameters

The parameters to use in the command.
Returns
Type Description
System.Int32

System.Int32
Overrides
| Improve this Doc

ExecuteIdentityInt64(IDataCommand, DbParameter[])

Executes the command statement and returns an identity value as long.

Declaration
public override long ExecuteIdentityInt64(IDataCommand dataCommand, params DbParameter[] parameters)
Parameters
Type Name Description
IDataCommand dataCommand

The data command to execute.
System.Data.Common.DbParameter[] parameters

The parameters to use in the command.
Returns
Type Description
System.Int64

System.Int64
Overrides
| Improve this Doc

GetCommandCore(IDataCommand, DbParameter[])

Gets the command object used by all execute related methods.

Declaration
protected override DbCommand GetCommandCore(IDataCommand dataCommand, params DbParameter[] parameters)
Parameters
Type Name Description
IDataCommand dataCommand

The data command to execute.
System.Data.Common.DbParameter[] parameters

The parameters to use in the command.
Returns
Type Description
System.Data.Common.DbCommand
Overrides

Extension Methods