C# Typed Query

Quick Start

To set up a simple example of TQ three classes need to be defined. The first is a Database class which contains the connection details of the database being used. This class must inherit from 'Sql.ADatabase', implement the 'GetConnection()' method and 'ConnectionString' property. Also a Table class inheriting from 'Sql.ATable' and a Row class inheriting from 'Sql.ARow' need to be created (This can be done using the UI tool).

Step 1 - Create Database class

Step 2 - Define table in sql

Step 3 - Generate Table and Row class definitions using UI tool

Step 4 - Start writing queries in code

Full code with query examples