Dapper.Lite extension

Dapper.Lite extension Dapper itself is not convenient and requires extensions. Dapper has nothing to do with specific databases. If it is encapsulated, the codes for different databases will be different. Dapper.Lite supports the most databases at the lowest cost and is designed to be simple, easy to use, stable and reliable. Dapper.Lite has recently been refactored and streamlined, as well as a version that does not rely on Dapper, LiteSql. These two ORMs are basically completed, please recommend them. Dapper.Lite is a Dapper extension that supports Lambda expressions for single-table queries and SQL splicing query conditions. It aims to provide everyone with an easy-to-use, stable and reliable ORM that supports Oracle, MSSQL, MySQL, PostgreSQL, SQLite, Access, ClickHouse and other databases. Its features include: Single table query supports Lambda List list = session.Queryable().Where(t => t.Id <= 20 && t.Remark.Contains("Test") ).ToList(); Single table query does not require writing SQL. In this reconstruction, even complex functions such as table queries and subqueries have been deleted to reduce the possibility of bugs. Mainly based on SQL, no matter what kind of database, it is written in the following way. This is the most common usage Some databases are prefixed with the @ symbol, and…