Beztek.Facade.Sql 1.1.1

Beztek.Facade.Sql Library

This library is intended for providing an facade ORM layer over SQL Databases. It uses SQLKata, and thus enables a level of abstraction over the nuances and particular syntaxes of various databases.

The source code for the entire project, as well as the example project and the unit tests can be found here: https://github.com/Beztek-Software-Solutions/sql-facade

Overview

It is intended to be cloud portable and take advantage of the native managed services in each cloud, such as managed Postgres DBs or managed Sql Server DBs. It is a reusable and configurable sql facade library.

Steps to use Sql Facade

1. Find SQL connection string. It currently supports Postgres SQL, Sql Server and SQLite (in-memory and file-based)/
2. Instantiate the SqlFacade object from the SqlFacadeFactory, using the appropriate SqlFacadeConfig object

Note: You can use Common Table Expressions to query any complex custom SQL if needed

Sample Project

The solution contains a sample project that you can modify and run to test out different use cases and scenarios. Simply set it as the startup project and then run. The unit tests also provide examples of how to use this library.

Useful ways to use this library

1. Local development can use a SQLite DB file, and when deployed it can use DBs such as Postgres or Sql Server, which could be managed cloud DBs as well. SQLite can be isntantiated in-memory as in the example project and the unit tests. This enables quick-and-dirty offline development without the need of a full database.
2. If your desire is DB portability, stick with the standard SDK methods provided, and only override with raw modifiers for ANSI SQL functions.
3. If your desire is to be able to dynamically build SQL statements and/or search filter criteria, then you can use CTEs (using the SDK for building SQLSelect, or with or without raw SQL select statements in a Common Table Expression as the base).