QueryHelper Class
Helper class for database queries and attribute retrieval.
QueryHelper
object
QueryGenerator
QueryGenerator
QueryBuilder
QueryGenerator
Synchronization
QueryGenerator

Syntax

public class QueryHelper

Methods

Name Return Value Summary
GetAllColumns<T>() List<string>
Gets the names of all properties for a specified type.
GetComparableProperties<T>() PropertyInfo[]
Retrieves an array of System.Reflection.PropertyInfo objects representing the properties that are used for data comparison in objects of type T.
GetExcludedColumns<T>() List<string>
Gets the names of properties marked as excluded properties for a specified type.
GetIdentityColumns<T>() List<string>
Retrieves a list of identity columns for a specified data contract type T.
GetIncludeIdentityInsert<T>() 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<T>() bool
Gets whether the type specifies to generate an INSERT query with ID, considering the GenerateInsertWithIDAttribute if present.
GetKeyColumns<T>() List<string>
Gets the names of properties marked as key columns for a specified type.
GetKeyProperties<T>() 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<T>() string
Gets the table name of a specified type, considering the TableNameAttribute if present.
GetTableSchema<T>() string
Gets the table schema of a specified type, considering the TableSchemaAttribute if present.