CA.Blocks.SQLServerDataAccess.SqlServerDataAccess

Class SqlServerDataAccess Class

Namespace :CA.Blocks.SQLServerDataAccess

Assembly : CA.Blocks.SQLServerDataAccess.dll

Provides a SQL server implementation for DataAccessCore

Inheritance :


↑
CA.Blocks.DataAccess.DataAccessCore
↑

New Class Constructors

NameDescription
MethodSqlServerDataAccess(CA.Blocks.DataAccess.DI.IDataAccessConfig, CA.Blocks.DataAccess.Translator.DbRowToObject.Interfaces.IDbRowTranslatorProvider)

Method Methods

NameDescription
Abstract Method GetConnectionContext()
Abstract Method PrepCommand(System.Data.IDbCommand)
Abstract Method TransientErrorNumbers()
Abstract Method IsTransientError(System.Data.Common.DbException)
Abstract Method GetDataAdapter(System.Data.IDbCommand)
Protected Method CreateStoredProcedureCommand(System.String)
Protected Method⚠ CreateBlankStoredProcedureCommand(System.String)
Protected Method⚠ GetStoredProcedureReturnValue(System.Data.SqlClient.SqlCommand)
Protected Method CreateTextCommand(System.String)
Protected Method CreateTextCommand(System.String, System.String)
Protected Method CreateTableSelectCommand(System.String, System.String)
Protected Method CreateTableSelectCommand(System.String, System.String, System.String)
Protected Method⚠ AddInputParamCommand(System.Data.SqlClient.SqlCommand, System.String, System.Object, System.Data.DbType, System.Int32)
Protected Method⚠ AddInputParamCommand(System.Data.SqlClient.SqlCommand, System.String, System.Object, System.Data.SqlDbType, System.Int32)
Protected Method⚠ AddInputParamCommandAsByte(System.Data.SqlClient.SqlCommand, System.String, System.Nullable{System.Byte})

To be removed

Protected Method AddOutputParamCommand(System.Data.SqlClient.SqlCommand, System.String, System.Data.DbType, System.Int32)
Protected Method AddOutputParamCommand(System.Data.SqlClient.SqlCommand, System.String, System.Data.SqlDbType, System.Int32)
Protected Method AddAdapterInputParamCommand(System.Data.SqlClient.SqlCommand, System.String, System.String, System.Data.DataTable)
Protected Method AddAdapterInputParamCommand(System.Data.SqlClient.SqlCommand, System.String, System.Data.DataTable)
Protected Method GetDBType(System.Type)

This is usefull when you dont know the sql datatype but you do know the physical type example is datatable DataColumn dc = ?? AddInputParamCommand(cmd, dc.ColumnName, dr[dc], GetDBType(dc.DataType), dc.MaxLength);

Protected Method CreateBulkInsertAdapter(System.String, System.Int32)
Protected Method CementExpressionsAsValues(System.Data.DataTable)
Protected Method ExecuteBulkInsertAdapter(System.Data.SqlClient.SqlDataAdapter, System.Data.DataTable)
Protected Method ExecuteDataTable(System.Data.SqlClient.SqlCommand, CA.Blocks.DataAccess.Model.Paging.PagingRequest)
Protected Method WrapPagingQuery(System.String, System.String)