ShadowSql: Borrowing Dapper to open the last mile of ORM

ShadowSql is a full-time spelling sql. If you want to be an ORM, you need to borrow from experts.

What we want to borrow is Dapper. Dapper is known for its high performance. ShadowSql and Dapper are a strong alliance.

For this purpose, a built-in sub-project is the Dapper extension.

The following is an example

1. Configure the Dapper Executor

ISqlEngine engine = new SqliteEngine();
IDbConnection connection = new SqliteConnection("Data Source=file::memory:;Cache=Shared");
IExecutor executor = new DapperExecutor(engine, connection);

Among them, the configuration objects of the engine database (and dialect) now support 5 types, namely MsSql, MySql, Oracle, Postgres and Sqlite

2. Read the whole table

var students = ("Students")
    .ToDapperSelect()
    .Get<Student>();

3. Query data

1. SqlQuery query data

        var students = ("Students")
            .ToSqlQuery()
            .Where("Age=10")
            .ToDapperSelect()
            .Get<Student>();

        var students = ("Students")
            .ToSqlQuery()
            .ColumnValue("Age", 10)
            .ToDapperSelect()
            .Get<Student>();

        var table = new StudentTable("Students");
        var students = ()
            .Where((10))
            .ToSelect()
            .Get<Student>(Executor);

        var students = new StudentTable("Students")
            .ToSqlQuery()
            .Where(table => (10))
            .ToSelect()
            .Get<Student>(Executor);

        var students = new Table("Students")
            .DefineColums("Age")
            .ToSqlQuery()
            .Where(student => ("Age").EqualValue(10))
            .ToDapperSelect(Executor)
            .Get<Student>();

The following three main types

1.1 Treat the executor as a database object, so that the query comes with its own executor and can be executed directly

1.2 Pass the executor as a parameter during execution

1.3 Query first, call ToDapperSelect to create an executable object

2. Query data query

        var table = new StudentTable("Students");
        var students = ()
            .And((10))
            .ToSelect()
            .Get<Student>(Executor)；

        var students = ("Students")
            .ToQuery()
            .And(table => ("Age").EqualValue(10))
            .ToDapperSelect()
            .Get<Student>();

        var table = new StudentTable("Students");
        var students = ()
            .And((10))
            .ToDapperSelect(Executor)
            .Get<Student>();

There are many ways to query, and the limit and length cannot be used one by one

The above example email can clearly show that ShadowSql and Dapper can be seamlessly connected.

Implementing streamlined high-performance ORMs