Class SqlContext

Represents a Sql context.

Inheritance

System.Object

SqlContext

Implements

System.IDisposable

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: Mediachase.BusinessFoundation.Data.Sql

Assembly: Mediachase.BusinessFoundation.Data.dll

Version: 10.8.0

Syntax

public class SqlContext : IDisposable

Constructors

SqlContext()

Initializes a new instance of the SqlContext class.

Declaration

protected SqlContext()

SqlContext(String)

Initializes a new instance of the SqlContext class.

Declaration

public SqlContext(string connectionString)

Parameters

Type	Name	Description
System.String	connectionString	The connection string.

Properties

CommandTimeout

Gets or sets the command timeout.

Declaration

public int CommandTimeout { get; set; }

Property Value

Type	Description
System.Int32	The command timeout.

ConnectionString

Gets or sets the connection string.

Declaration

public virtual string ConnectionString { get; protected set; }

Property Value

Type	Description
System.String	The connection string.

Current

Gets or sets the current.

Declaration

public static SqlContext Current { get; set; }

Property Value

Type	Description
SqlContext	The current.

Database

Declaration

public Database Database { get; }

Property Value

Type	Description
Database

Transaction

Gets or sets the transaction.

Declaration

public virtual SqlTransaction Transaction { get; set; }

Property Value

Type	Description
System.Data.SqlClient.SqlTransaction	The transaction.

TransactionScope

Declaration

public virtual SqlTransactionScope TransactionScope { get; }

Property Value

Type	Description
SqlTransactionScope

Methods

BeginTransaction()

Begins the transaction.

Declaration

public virtual SqlTransactionScope BeginTransaction()

Returns

Type	Description
SqlTransactionScope

Dispose()

Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.

Declaration

public void Dispose()

Dispose(Boolean)

Declaration

protected virtual void Dispose(bool disposing)

Parameters

Type	Name	Description
System.Boolean	disposing

FromConfig()

Froms the config.

Declaration

public static SqlContext FromConfig()

Returns

Type	Description
SqlContext

GetTable(String)

Gets the table.

Declaration

public Table GetTable(string tableName)

Parameters

Type	Name	Description
System.String	tableName	Name of the table.

Returns

Type	Description
Table

Events

TransactionCommited

Occurs when [transaction commited].

Declaration

public static event EventHandler TransactionCommited

Event Type

Type	Description
System.EventHandler

TransactionCreated

Occurs when [transaction created].

Declaration

public static event EventHandler TransactionCreated

Event Type

Type	Description
System.EventHandler

TransactionRollbacked

Occurs when [transaction rollbacked].

Declaration

public static event EventHandler TransactionRollbacked

Event Type

Type	Description
System.EventHandler

Implements

System.IDisposable