ShadowSql contains most of the functions of SQL
According to the executable functions, it is divided into Insert, Delete, Update, Select (SingleSelect), CreateTable, DropTable and TruncateTable.
The above functions also include sub-functions, including Table, AliasTable, DB, TableView, Column(Field), Query(SqlQuery), Logic, Cursor, SelectField and SubQuery.
1. Table (table) is used to map data tables
Table can include Column, which is convenient for using Column to splice SQL, and can also be used to verify the legitimacy of SQL. For example, non-existent columns cannot be used and exceptions need to be thrown.
The interface of Table is ITable, and the default implementation classes are SimpleTable, Table and TableSchema.
SimpleTable is just a placeholder for the table, does not contain columns, but does not contain SQL. You can use Field to splice SQL (limited space. I will not expand it here)
Table can contain columns, and using Column to splice SQL will verify whether it exists. Of course, you can also use Field to bypass verification, which depends on individual or team's preferences and standards.
For Insert and Update operations, if the column is not defined in advance, the column must be manually specified every time after the operation, which is not very convenient.
The best practice is to define the Table and its Column as configuration, or inject it into the IOC.
TableSchema is mainly used to create tables, CodeFIrst, and tables need to be added with schema qualifiers.
Of course, you can also customize the Table type
2. DB (database) is responsible for managing Table
The interface is IDB, with 3 implementation classes, DB, SimpleDB and DBSchema
DB Management Table
SimpleDB manages SimpleTable
DBSchema manages TableSchema
Table can exist independently, DB is not necessary, DB does not participate in SQL spelling
3. AliasTable (alias table)
AliasTable is to give Table an alias
AliasTable is very important, it needs to be used when concatenating tables and subqueries, and is used to distinguish different fields of different tables.
There is also the case of self-concatenation tables, and there must be an alias to avoid errors.
The interface of AliasTable is IAliasTable, and the default implementation class is TableAlias
Of course, custom AliasTable is also a good choice, and it is so harsh to query the connection table.
4. TableView
TableView is the interface ITableView, which represents a table or query view.
Table, AliasTable, Query (DataQuery), and Cursor all inherit ITableView
Conceptually speaking, TableView is divided into 6 types, namely Table, AliasTable, MultiTable (and JoinTable), GroupByTable, GroupByAliasTable, and GroupByMulti6 types: Table, AliasTable, and GroupByMulti: 6 types: Table, AliasTable, and GroupByMulti: 6 types: Table, AliasTable, and GroupByMulti: 6 types: Table, AliasTable, and GroupByMulti: 6 types: Table, AliasTable, and GroupByMulti: 6 types: Table, AliasTable, and GroupByMulti: 6 types: Table, AliasTable, and GroupByMulti: 6 types: Table, AliasTable, and GroupByMulti: 6 types: Table, AliasTable, and GroupByMulti: 6 types: Table, AliasTable, and GroupByMulti:
These 6 types almost implement most of the process of query
DQuery and SqlQuery are divided into 8 types (JoinTable and JoinOn special processing)
SelectField is divided into 6 types
Cursors are divided into 6 types
Select and SingleSelect are also divided into 6 types
Each special treatment is to better support its special situation
V. SqlQuery
SqlQuery query through native sql and logic
Table, AliasTable, MultiTable (and JoinTable) are used to query using Where
GroupByTable, GroupByAliasTable, GroupByMulti use Having
JoinOn query with On
If you want to nest AND and OR, it is achieved by calling ToAnd and ToOr
6. Query
Query uses logical operations to query the methods name And and Or
Each logical object supports Not method to support logical non-operation
Logic is not used as little as possible, and in most cases there will be alternatives.
Generally, logical objects are Field+ operator+values (can also be fields or parameters). Each operator has an inverse operator. This situation should be a better choice instead of logic.
7. Cursor
Cursor means cursor, and its function is pagination + OrderBy
There is still a lot of data in the where condition. Sometimes you only need to filter some of them. At this time, you need to move the cursor to screenshot some of them.
Supports Asc, Desc and OrderBy for sorting, where OrderBy supports original SQL
Skip and Take are the methods of automatic cursors, and Linq is the same
8. SelectFields
SelectFields is used to filter some fields, default *
Filter fields by methods Select, Alias, and SelectCount
9. Select
Used to assemble ITableView (Query, Cursor) and SelectFields
One is the filtering of rows and the other is the filtering of columns
This will generate a completed Select statement
Ten, Insert is divided into 3 types
SingleInsert is used to insert single data
MultiInsert is used to insert multiple data at once
SelectInsert is used to insert the result of Select
11. Delete is divided into 3 types
TableDelete, AliasTableDelete and MultiTableDelete
Among them, MultiTableDelete contains a link table
12. Update is divided into 3 types
TableUpdate, AliasTableUpdate and MultiTableUpdate
Among them, MultiTableUpdate contains a link table
13. TableDelete clears the table
14. CreateTable and DropTable generate and delete tables
CreateTable and DropTable are placed in separate subprojects
Because most projects do not require these functions, in order to be as simple as possible
The above is an introduction to the ShadowSqlh function. Interested students can go to github to view the source code.
Warehouse address: /donetsoftwork/Shadow.
If you like, please help me click on the Star if you make a fortune.