Class SqlSession

SQL Server implementation of database session.

Inheritance

System.Object

AddonBag

DbSession

DbSession<System.Data.SqlClient.SqlConnection, System.Data.SqlClient.SqlCommand, SqlReader>

SqlSession

Implements

System.IDisposable

Inherited Members

DbSession<SqlConnection, SqlCommand, SqlReader>.Connection

DbSession<SqlConnection, SqlCommand, SqlReader>.OpenConnectionAsync(CancellationToken)

DbSession<SqlConnection, SqlCommand, SqlReader>.CloseConnection()

DbSession<SqlConnection, SqlCommand, SqlReader>.ExecuteNonQueryAsync(SqlCommand, CancellationToken)

DbSession<SqlConnection, SqlCommand, SqlReader>.GetCreateTableCommand(Model, Boolean)

DbSession<SqlConnection, SqlCommand, SqlReader>.GetQueryCommand(DbQueryStatement)

DbSession<SqlConnection, SqlCommand, SqlReader>.CreateReaderInvoker(Model, SqlCommand)

DbSession<SqlConnection, SqlCommand, SqlReader>.ExecuteReaderAsync(IDbSet, CancellationToken)

DbSession<SqlConnection, SqlCommand, SqlReader>.CreateLogger()

DbSession<SqlConnection, SqlCommand, SqlReader>.SetLogger(Action<String>, LogCategory)

DbSession<SqlConnection, SqlCommand, SqlReader>.GetInsertCommand(DbSelectStatement)

DbSession<SqlConnection, SqlCommand, SqlReader>.GetUpdateCommand(DbSelectStatement)

DbSession<SqlConnection, SqlCommand, SqlReader>.GetDeleteCommand(DbSelectStatement)

DbSession<SqlConnection, SqlCommand, SqlReader>.TransactionCount

DbSession<SqlConnection, SqlCommand, SqlReader>.CurrentTransaction

DbSession<SqlConnection, SqlCommand, SqlReader>.BeginTransaction(String)

DbSession<SqlConnection, SqlCommand, SqlReader>.BeginTransaction(Nullable<IsolationLevel>, String)

DbSession<SqlConnection, SqlCommand, SqlReader>.PerformBeginTransaction(Nullable<IsolationLevel>, String)

DbSession.Dispose()

DbSession.Dispose(Boolean)

DbSession.Connection

DbSession.OpenConnectionAsync(CancellationToken)

DbSession.CloseConnection()

DbSession.GetTable<T>(DbTable<T>, String)

DbSession.CreateTempTableAsync<T>(CancellationToken)

DbSession.CreateTempTableAsync<T>(T, CancellationToken)

DbSession.CreateTempTableAsync<T>(Action<T>, CancellationToken)

DbSession.CreateTempTableAsync<T>(T, Action<T>, CancellationToken)

DbSession.CreateQuery<T>(Action<DbQueryBuilder, T>)

DbSession.CreateQuery<T>(T, Action<DbQueryBuilder, T>)

DbSession.CreateQuery<T>(Action<T>, Action<DbQueryBuilder, T>)

DbSession.CreateQuery<T>(T, Action<T>, Action<DbQueryBuilder, T>)

DbSession.CreateAggregateQuery<T>(Action<DbAggregateQueryBuilder, T>)

DbSession.CreateAggregateQuery<T>(T, Action<DbAggregateQueryBuilder, T>)

DbSession.CreateAggregateQuery<T>(Action<T>, Action<DbAggregateQueryBuilder, T>)

DbSession.CreateAggregateQuery<T>(T, Action<T>, Action<DbAggregateQueryBuilder, T>)

DbSession.SetLogger(Action<String>)

DbSession.SetLogger(Action<String>, LogCategory)

System.Object.Equals(System.Object)

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

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

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

System.Object.ToString()

Namespace: DevZest.Data.SqlServer

Assembly: DevZest.Data.SqlServer.dll

Syntax

public abstract class SqlSession : DbSession<SqlConnection, SqlCommand, SqlReader>, IDisposable

Constructors

Name	Description
SqlSession(SqlConnection)	Initializes a new instance of SqlSession.

Properties

Name	Description
CurrentTransaction
SqlVersion	Gets or sets the SQL Server version.
TransactionCount

Methods

Name	Description
AssignTempTableName(Model)
CreateMockDbAsync(CancellationToken)
CreateReaderInvoker(Model, SqlCommand)
DeleteAsync<TSource, TTarget>(DataSet<TSource>, DbTable<TTarget>, CandidateKey, CancellationToken)
GetCreateTableCommand(Model, Boolean)
GetDeleteCommand(DbSelectStatement)
GetInsertCommand(DbSelectStatement)
GetMockTableName(String, Object)
GetQueryCommand(DbQueryStatement)
GetSqlString(DbQueryStatement)
GetUpdateCommand(DbSelectStatement)
InsertAsync<TSource, TTarget>(DataSet<TSource>, DbTable<TTarget>, Action<ColumnMapper, TSource, TTarget>, Boolean, CancellationToken)
InsertScalarAsync(DbSelectStatement, Boolean, CancellationToken)
OpenJson<T>(String, String)	Opens JSON string as DbSet.
PerformBeginTransaction(Nullable<IsolationLevel>, String)
UpdateAsync<TSource, TTarget>(DataSet<TSource>, DbTable<TTarget>, Action<ColumnMapper, TSource, TTarget>, CandidateKey, CancellationToken)