Helper class for building SQL queries.
- Namespace
- DbSyncKit
.Core .SqlBuilder - Base Types
-
- object
- QueryHelper
graph BT
Type-->Base0["QueryHelper"]
click Base0 "/api/DbSyncKit.DB.Helper/QueryHelper"
Base0-->Base1["object"]
Type["QueryBuilder"]
class Type type-node
Syntax
public class QueryBuilder : QueryHelperRemarks
The
QueryBuilder class extends the functionality of QueryHelper to provide methods for constructing SQL queries.
It aids in the generation of queries for various database operations such as SELECT, INSERT, UPDATE, and DELETE.
Methods
| Name | Return Value | Summary |
|---|---|---|
| GetAllColumns |
List |
Gets the names of all properties for a specified type.
Inherited from QueryHelper
|
| Get |
PropertyInfo[] |
Retrieves an array of
System.Reflection.PropertyInfo objects representing the properties that are used for data comparison
in objects of type T.
Inherited from QueryHelper
|
| GetExcludedColumns |
List |
Gets the names of properties marked as excluded properties for a specified type.
Inherited from QueryHelper
|
| GetIdentityColumns |
List |
Retrieves a list of identity columns for a specified data contract type T.
Inherited from QueryHelper
|
| Get |
bool |
Gets whether the type specifies to include database-specific SQL statements for identity insert behavior
during insert query generation, considering the GenerateInsertWithIDAttribute if present.
Inherited from QueryHelper
|
| GetInsertWithID |
bool |
Gets whether the type specifies to generate an INSERT query with ID, considering the GenerateInsertWithIDAttribute if present.
Inherited from QueryHelper
|
| GetKeyColumns |
List |
Gets the names of properties marked as key columns for a specified type.
Inherited from QueryHelper
|
| GetKeyProperties |
PropertyInfo[] |
Retrieves an array of
System.Reflection.PropertyInfo objects representing the properties that are used as key properties
for uniquely identifying objects of type T.
Inherited from QueryHelper
|
| Get |
string |
Generates SQL queries for synchronizing data based on the provided object.
|
| GetTableName |
string |
Gets the table name of a specified type, considering the TableNameAttribute if present.
Inherited from QueryHelper
|
| GetTableSchema |
string |
Gets the table schema of a specified type, considering the TableSchemaAttribute if present.
Inherited from QueryHelper
|