Enum QueryOptions

Namespace: DbExport.Schema

Assembly: DbExport.Api.dll

Specifies options for customizing the behavior of query generation in database operations. These options determine how tables and columns are processed and formatted during SQL generation.

[Flags]
public enum QueryOptions

Fields

All = SkipGenerated | QualifyTableName: Represents a combination of all available query options. This includes skipping identity, computed, and row version columns during query generation, as well as qualifying table names with schema information, ensuring comprehensive customization of the query output.
None = 0: Indicates that no query options are applied. This is the default value, meaning that all applicable table columns and default behaviors are included during SQL generation without exclusions or modifications.
QualifyTableName = 8: Specifies that fully qualified table names, including schema names, should be used during SQL generation. This ensures that table references are explicit, which can help avoid ambiguities when working with multiple schemas or databases.
SkipComputed = 2: Specifies that computed columns are excluded during query generation. This option removes columns with calculated values, such as those defined with SQL expressions, from the generated SQL statement.
SkipGenerated = SkipIdentity | SkipComputed | SkipRowVersion: Represents a combination of query options that excludes identity, computed, and row version columns during SQL generation. This option is used to skip all columns that are automatically generated by the database, ensuring they are omitted from the resulting query.
SkipIdentity = 1: Indicates that identity columns are excluded during query generation. This option prevents the inclusion of columns that are marked as identity fields, typically used for automatically generated values in database tables.
SkipRowVersion = 4: Indicates that columns marked with the RowVersion property should be excluded from the query generation process. This option is used to prevent inclusion of RowVersion columns, which are typically used for concurrency tracking and may not be necessary in certain queries or export scenarios.