Tags


Working With Parameters

Simple Select With Parameters
Sql Injection Attacks
Working With Parameters

Setup

Getting Started
A quick guid on how to get setup and going
Using Json Config Connection Strings Resolver
Connection coming from appsettings.json which is typically done with .Net Core that uses the Microsoft.Extensions.ConfigurationConfigurationManager class.
Using AppDot Config Connection Strings Resolver
Connection String coming from app.config using using the Microsoft System.Configuration.ConfigurationManager class. This is common with the .NET 1 to 4.8 frameworks
Custom Connection String Resolver
How to implement your own Connection String Resolver

Examples

Execute Stored Procedures
Index
Simple Select
Simple Select With Parameters
Simple Single Row
Simple Single Value
Selecting Scalar Values
Examples of Selecting Scalar Values using CA.Blocks for example as single string or number or Date etc
Selecting Single Rows
Execute to a single value
Selecting Multiple Rows
Selecting Multiple Rows like a table view
Selecting Multiple Sets
Execute Non Query
Used for Executing Insert, Update, delete commands
Execute Stored Procedures
Working With RowSet Translators
Working with the Row set Translators
Custom Column Translators

Column Translators

Custom Column Translators

RowSet Translators

Working With RowSet Translators
Working with the Row set Translators

Execute Non Query

Execute Non Query
Used for Executing Insert, Update, delete commands

How To

Selecting Scalar Values
Examples of Selecting Scalar Values using CA.Blocks for example as single string or number or Date etc
Selecting Single Rows
Execute to a single value
Selecting Multiple Rows
Selecting Multiple Rows like a table view
Selecting Multiple Sets
Execute Non Query
Used for Executing Insert, Update, delete commands

Stored Procedures

Execute Stored Procedures

Selecting Multiple Rows

Selecting Multiple Rows
Selecting Multiple Rows like a table view

Selecting Multiple Sets

Selecting Multiple Sets

Selecting Scalar Values

Selecting Scalar Values
Examples of Selecting Scalar Values using CA.Blocks for example as single string or number or Date etc

Selecting Single Rows

Selecting Single Rows
Execute to a single value

Connection String

Using Json Config Connection Strings Resolver
Connection coming from appsettings.json which is typically done with .Net Core that uses the Microsoft.Extensions.ConfigurationConfigurationManager class.
Using AppDot Config Connection Strings Resolver
Connection String coming from app.config using using the Microsoft System.Configuration.ConfigurationManager class. This is common with the .NET 1 to 4.8 frameworks
Custom Connection String Resolver
How to implement your own Connection String Resolver

Stored Procedure

Execute Stored Procedures