Helper class for database queries and attribute retrieval.
- Namespace
- DbSyncKit
.DB .Helper - Base Types
-
- object
- Derived Types
graph BT
Type-->Base0["object"]
Type["QueryHelper"]
class Type type-node
Derived0["QueryGenerator"]-->Type
click Derived0 "/api/DbSyncKit.PostgreSQL/QueryGenerator"
Derived1["QueryGenerator"]-->Type
click Derived1 "/api/DbSyncKit.MySQL/QueryGenerator"
Derived2["QueryBuilder"]-->Type
click Derived2 "/api/DbSyncKit.Core.SqlBuilder/QueryBuilder"
Derived3["QueryGenerator"]-->Type
click Derived3 "/api/DbSyncKit.MSSQL/QueryGenerator"
Derived4["Synchronization"]-->Type
click Derived4 "/api/DbSyncKit.Core/Synchronization"
Derived5["QueryGenerator"]-->Type
click Derived5 "/api/DbSyncKit.SQLite/QueryGenerator"
Syntax
public class QueryHelperMethods
| Name | Return Value | Summary |
|---|---|---|
| GetAllColumns |
List |
Gets the names of all properties for a specified type.
|
| Get |
PropertyInfo[] |
Retrieves an array of
System.Reflection.PropertyInfo objects representing the properties that are used for data comparison
in objects of type T.
|
| GetExcludedColumns |
List |
Gets the names of properties marked as excluded properties for a specified type.
|
| GetIdentityColumns |
List |
Retrieves a list of identity columns for a specified data contract type T.
|
| 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.
|
| GetInsertWithID |
bool |
Gets whether the type specifies to generate an INSERT query with ID, considering the GenerateInsertWithIDAttribute if present.
|
| GetKeyColumns |
List |
Gets the names of properties marked as key columns for a specified type.
|
| 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.
|
| GetTableName |
string |
Gets the table name of a specified type, considering the TableNameAttribute if present.
|
| GetTableSchema |
string |
Gets the table schema of a specified type, considering the TableSchemaAttribute if present.
|