CA.Blocks.DataAccess

Assembly : CA.Blocks.DataAccess.dll

CA.Blocks.DataAccess assembly provides the abstract implementation for accessing the data. Whilst is has all the common code is has no concept of the actual drivers used to connect. This assembly is is not much help with an actual implementation. Current implementations include CA.Blocks.SQLServerDataAccess for accessing SQL server and CA.Blocks.SQLLiteDataAccess for accessing SQL light databases.

Class Classes

NameDescription
Abstract ClassCA.Blocks.DataAccess.DataAccessCore This class provides the abstract implementation for the Code Associate Data Access Block. The Abstract implementation is build upon utilizing common System.Data methods and interfacing out the Specific DBCommand using the IDbCommand interface. In doing this all specializations built on top of this class will behave in the same manor. This class is abstract and cannot be created.
StaticCA.Blocks.DataAccess.DataHelper This class is a helper class for dealing data values. It is intended to be a static helper class only.
StaticCA.Blocks.DataAccess.DataRowExtensions This is a helper class to add some semantic sugar to the DataHelper class using extension methods
StaticCA.Blocks.DataAccess.IDataReaderExtensions
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappings
ClassGenericCA.Blocks.DataAccess.Translator.BaseDb2ObjectTranslator`1
Abstract ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMapping
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingBool
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingNullBool
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingByte
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingNullByte
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingSbyte
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingNullSbyte
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingShort
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingNullShort
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingInt
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingNullInt
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingLong
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingNullLong
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingGuid
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingNullGuid
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingDecimal
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingNullDecimal
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingDouble
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingNullDouble
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingDateTime
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingNullDateTime
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingTimeSpan
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingNullTimeSpan
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingChar
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingNullChar
ClassCA.Blocks.DataAccess.Translator.DatabaseToObjectMappingString
ClassCA.Blocks.DataAccess.Translator.DynamicDbRow2ObjectTranslator
Abstract ClassGenericCA.Blocks.DataAccess.Translator.SimpleDbReader2ObjectTranslator`1
Abstract ClassGenericCA.Blocks.DataAccess.Translator.SimpleDbRow2ObjectTranslator`1
ClassGenericCA.Blocks.DataAccess.Translator.DbRowToObject.Db2ObjectTranslator`1
ClassCA.Blocks.DataAccess.Translator.DbRowToObject.Providers.DefaultDbRowTranslatorProvider
ClassCA.Blocks.DataAccess.Translator.DbRowToObject.Mappings.DbRowToObjectMappings
ClassCA.Blocks.DataAccess.Translator.DbColToType.Providers.DefaultDbColToTypeProvider
ClassCA.Blocks.DataAccess.Translator.DbColToType.Mappings.DbColToTypeMapping
Abstract ClassGenericCA.Blocks.DataAccess.Translator.DbColToType.Converters.BaseDbColToTypeConverter`1 What is the name of this
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.BinaryDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.BoolDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullBoolDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.ByteDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullByteDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.CharDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullCharDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.DateTimeDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullDateTimeDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.DecimalDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullDecimalDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.DoubleDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullDoubleDbColToTypeConverter
ClassGenericCA.Blocks.DataAccess.Translator.DbColToType.Converters.EnumDbColToTypeConverter`1 EnumDbColToTypeConverter Docs
ClassGenericCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullEnumDbColToTypeConverter`1
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.GuidDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullGuidDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.IntDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullIntDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.LongDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullLongDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.SByteDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullSByteDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.ShortDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullShortDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.SingleDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullSingleDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.StringDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.UIntDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullUIntDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.ULongDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullULongDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.UShortDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.DbColToType.Converters.NullUShortDbColToTypeConverter
ClassCA.Blocks.DataAccess.Translator.Basic.BinaryTranslator
ClassCA.Blocks.DataAccess.Translator.Basic.ByteTranslator
ClassCA.Blocks.DataAccess.Translator.Basic.CharTranslator
ClassCA.Blocks.DataAccess.Translator.Basic.DateTimeTranslator
ClassCA.Blocks.DataAccess.Translator.Basic.IntTranslator
ClassCA.Blocks.DataAccess.Translator.Basic.LongTranslator
ClassCA.Blocks.DataAccess.Translator.Basic.ShortTranslator
ClassCA.Blocks.DataAccess.Translator.Basic.StringTranslator
ClassCA.Blocks.DataAccess.DI.AppDotConfigConnectionStringsResolver Uses the App.Config ConnectionStrings, this is common on .NET 1-4.8 frameworks. It will be using the App.config or web.config ConnectionStrings setting
ClassCA.Blocks.DataAccess.DI.DataAccessConfigOptions
ClassCA.Blocks.DataAccess.DI.HardCodedConnectionStringsResolver This is a hard coded Connection String Resolver. This class is useful for providing examples and quick prototype code. Typically you will not use this once rolling out the application. The Configuration used is a Hosting app concern. See examples at :
ClassCA.Blocks.DataAccess.DI.DataAccessConfig
ClassCA.Blocks.DataAccess.DI.JsonConfigConnectionStringsResolver Uses the JsonConfig this is common on .NET core frameworks

Enum Interfaces

NameDescription
EnumCA.Blocks.DataAccess.Translator.DbRowToObject.Interfaces.IDbRowTranslator`1
EnumCA.Blocks.DataAccess.Translator.DbRowToObject.Interfaces.IDbRowTranslatorProvider
EnumCA.Blocks.DataAccess.Translator.DbColToType.Interfaces.IDbColToTypeConverter`1
EnumCA.Blocks.DataAccess.Translator.DbColToType.Interfaces.IDbColToTypeConverter
EnumCA.Blocks.DataAccess.Translator.DbColToType.Interfaces.IDbColToTypeProvider
EnumCA.Blocks.DataAccess.Translator.DbColToType.Interfaces.IDbColToTypeMapping
EnumCA.Blocks.DataAccess.DI.IDataAccessConfigOptions provides the interfaces and some common implementations for configuring the connection strings
EnumCA.Blocks.DataAccess.DI.IDataAccessConfig
EnumCA.Blocks.DataAccess.DI.IDataAccessKeyToConnectionStringResolver This interface provides the lookup for connectionStringKey this could be from app.config or appsettings.json or could be custom logic