SqlServerDataAccess Class
Namespace :CA.Blocks.SQLServerDataAccess
Assembly : CA.Blocks.SQLServerDataAccess.dll
Provides a SQL server implementation for DataAccessCore
Inheritance :
Constructors
| Name | Description | |
|---|---|---|
 | SqlServerDataAccess(CA.Blocks.DataAccess.DI.IDataAccessConfig,CA.Blocks.DataAccess.Translator.DbRowToObject.Interfaces.IDbRowTranslatorProvider) |
Methods
| Name | Description | |
|---|---|---|
 | GetConnectionContext() | |
| PrepCommand(System.Data.IDbCommand) | |
| GetDataAdapter(System.Data.IDbCommand) | |
 | CreateBlankStoredProcedureCommand(System.String,System.Boolean) | |
| GetStoredProcedureReturnValue(System.Data.SqlClient.SqlCommand) | |
| CreateTextCommand(System.String) | |
| CreateTextCommand(System.String,System.String) | |
| CreateTableSelectCommand(System.String,System.String) | |
| CreateTableSelectCommand(System.String,System.String,System.String) | |
| AddInputParamCommand(System.Data.SqlClient.SqlCommand,System.String,System.Object,System.Data.DbType,System.Int32) | |
| AddInputParamCommand(System.Data.SqlClient.SqlCommand,System.String,System.Object,System.Data.SqlDbType,System.Int32) | |
| ⚠ | AddInputParamCommandAsByte(System.Data.SqlClient.SqlCommand,System.String,System.Nullable{System.Byte}) | Please use the ToSqlParameter Extension Method To be removed |
| AddOutputParamCommand(System.Data.SqlClient.SqlCommand,System.String,System.Data.DbType,System.Int32) | |
| AddOutputParamCommand(System.Data.SqlClient.SqlCommand,System.String,System.Data.SqlDbType,System.Int32) | |
| AddAdapterInputParamCommand(System.Data.SqlClient.SqlCommand,System.String,System.String,System.Data.DataTable) | |
| AddAdapterInputParamCommand(System.Data.SqlClient.SqlCommand,System.String,System.Data.DataTable) | |
| 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); |
| CreateBulkInsertAdapter(System.String,System.Int32) | |
| CementExpressionsAsValues(System.Data.DataTable) | |
| ExecuteBulkInsertAdapter(System.Data.SqlClient.SqlDataAdapter,System.Data.DataTable) | |
| ExecuteDataTable(System.Data.SqlClient.SqlCommand,CA.Blocks.DataAccess.Model.Paging.PagingRequest) | |
| WrapPagingQuery(System.String,System.String) |