Microsoft.EntityFrameworkCore Namespace

CustomExtensions Class

RingSoft.DbLookup Namespace

AlertLevels Enumeration

CanProcessTableArgs Class

CopyProcedureArgs Class

DataEntryGridAutoFillCellProps Class

DbLookupTableWindowRegistry Class

DeleteRecordItemViewModel Class

DeleteRecordViewModel Class

DeleteTable Class

DeleteTables Class

DeleteTableWindowData Class

ExtensionMethods Class

FieldDataTypes Enumeration

GblMethods Class

GenericFocusControls Enumeration

GenericReportFilterViewModel Class

GenericReportLookupFilterInput Class

IDbContext Interface

IDbLookupUserInterface Interface

IDeleteRecordView Interface

IGenericReportFilterView Interface

IListControlView Interface

IListWindowView Interface

IPrinterSetupView Interface

IPrintingProcessingView Interface

IPrintProcessor Interface

ListControlColumn Class

ListControlDataCell Class

ListControlDataSource Class

ListControlDataSourceRow Class

ListControlSetup Class

ListControlViewModel Class

ListWindowViewModel Class

LookupContextBase Class

LookupDefaults Class

NewAddOnTheFlyResult Class

OrderMethods Enumeration

PrimaryKeyValue Class

PrimaryKeyValueField Class

PrintColumnTypes Enumeration

PrinterDataProcessedEventArgs Class

PrinterSetupArgs Class

PrinterSetupViewModel Class

PrintingColumnMap Class

PrintingProcessingViewModel Class

ProcessTypes Enumeration

ScrollPositions Enumeration

SearchHostFormatArgs Class

SystemDataRepository Class

SystemGlobals Class

TableDefinitionValue Class

UserAutoFill Class

RingSoft.DbLookup.AutoFill Namespace

AutoFillContainsItem Class

AutoFillDataChangedArgs Class

AutoFillDataMaui(TEntity) Class

AutoFillDataMauiBase Class

AutoFillDefinitionBase Class

AutoFillFieldDefinition Class

AutoFillFormulaDefinition Class

AutoFillOutputData Class

AutoFillRefreshModes Enumeration

AutoFillSetup Class

AutoFillTypes Enumeration

AutoFillValue Class

IAutoFillControl Interface

RingSoft.DbLookup.Controls.WPF Namespace

AdvancedFindModes Enumeration

AutoFillControl Class

AutoFillReadOnlyControl Class

ContainsSource Class

ControlsUserInterface Class

DataColumn Class

DataColumnMaps Class

DataEntryGridAutoFillHost Class

DataProcessResultWindow Class

DataSource Class

DbMaintenanceButtonsFactory Class

DbMaintenanceProcessorFactory Class

DbMaintenanceStatusBar Class

DbMaintenanceWindow Class

DbMaintenanceWindowProcessor Class

DbMaintenanceWindowRegistry Class

DbMaintenanceWindowRegistry.WindowRegistryItem Class

DeleteRecordWindow Class

DeleteRecordWindowItemControl Class

GenericReportFilterWindow Class

IDbMaintenanceProcessor Interface

ListControl Class

ListWindow Class

LookupColumn Class

LookupColumn(TControl) Class

LookupColumnBase Class

LookupColumnWidthChangedArgs Class

LookupControl Class

LookupControlColumnFactory Class

LookupControlContentTemplateFactory Class

LookupControlsGlobals Class

LookupCustomContentColumn Class

LookupCustomContentControl Class

LookupGridEditHostFactory Class

LookupSearchForDateHost Class

LookupSearchForDecimalHost Class

LookupSearchForDropDownHost(TDropDownControl) Class

LookupSearchForHost Class

LookupSearchForHost(TControl) Class

LookupSearchForHostFactory Class

LookupSearchForIntegerHost Class

LookupSearchForStringHost Class

LookupShownArgs Class

LookupWindow Class

LookupWindowFactory Class

NameOfExtension Class

PrintingProcessingWindow Class

PrintSetupWindow Class

RecordLockingWindow Class

RingSoft.DbLookup.Controls.WPF.AdvancedFind Namespace

AdvancedFilterParenthesesHost Class

AdvancedFilterWindow Class

AdvancedFindFilterHost Class

AdvancedFindFormulaColumnWindow Class

AdvancedFindGridMemoEditor Class

AdvancedFindRefreshRateWindow Class

AdvancedFindWindow Class

AutoFillMemoCellControl Class

DataEntryGridAdvancedFindFormulaColumnHost Class

DataEntryGridAdvancedFindMemoHost Class

RingSoft.DbLookup.Controls.WPF.Properties Namespace

AspChildControlTypeAttribute Class

AspDataFieldAttribute Class

AspDataFieldsAttribute Class

AspMethodPropertyAttribute Class

AspMvcActionAttribute Class

AspMvcActionSelectorAttribute Class

AspMvcAreaAttribute Class

AspMvcAreaMasterLocationFormatAttribute Class

AspMvcAreaPartialViewLocationFormatAttribute Class

AspMvcAreaViewLocationFormatAttribute Class

AspMvcControllerAttribute Class

AspMvcDisplayTemplateAttribute Class

AspMvcEditorTemplateAttribute Class

AspMvcMasterAttribute Class

AspMvcMasterLocationFormatAttribute Class

AspMvcModelTypeAttribute Class

AspMvcPartialViewAttribute Class

AspMvcPartialViewLocationFormatAttribute Class

AspMvcSuppressViewErrorAttribute Class

AspMvcTemplateAttribute Class

AspMvcViewAttribute Class

AspMvcViewComponentAttribute Class

AspMvcViewComponentViewAttribute Class

AspMvcViewLocationFormatAttribute Class

AspRequiredAttributeAttribute Class

AspTypePropertyAttribute Class

AssertionConditionAttribute Class

AssertionConditionType Enumeration

AssertionMethodAttribute Class

BaseTypeRequiredAttribute Class

CanBeNullAttribute Class

CannotApplyEqualityOperatorAttribute Class

CollectionAccessAttribute Class

CollectionAccessType Enumeration

ContractAnnotationAttribute Class

HtmlAttributeValueAttribute Class

HtmlElementAttributesAttribute Class

ImplicitUseKindFlags Enumeration

ImplicitUseTargetFlags Enumeration

InstantHandleAttribute Class

InvokerParameterNameAttribute Class

ItemCanBeNullAttribute Class

ItemNotNullAttribute Class

LinqTunnelAttribute Class

LocalizationRequiredAttribute Class

MacroAttribute Class

MeansImplicitUseAttribute Class

MustUseReturnValueAttribute Class

NoEnumerationAttribute Class

NoReorderAttribute Class

NotifyPropertyChangedInvocatorAttribute Class

NotNullAttribute Class

PathReferenceAttribute Class

ProvidesContextAttribute Class

PublicAPIAttribute Class

PureAttribute Class

RazorDirectiveAttribute Class

RazorHelperCommonAttribute Class

RazorImportNamespaceAttribute Class

RazorInjectionAttribute Class

RazorLayoutAttribute Class

RazorPageBaseTypeAttribute Class

RazorSectionAttribute Class

RazorWriteLiteralMethodAttribute Class

RazorWriteMethodAttribute Class

RazorWriteMethodParameterAttribute Class

RegexPatternAttribute Class

SourceTemplateAttribute Class

StringFormatMethodAttribute Class

TerminatesProgramAttribute Class

UsedImplicitlyAttribute Class

ValueProviderAttribute Class

XamlItemBindingOfItemsControlAttribute Class

XamlItemsControlAttribute Class

RingSoft.DbLookup.DataProcessor Namespace

DataProcessResult Class

DataProcessResult.QueryResultSql Class

DbDataProcessor Class

DbFieldTypes Enumeration

GetDataResultCodes Enumeration

MySqlDataProcessor Class

SecurityTypes Enumeration

SqliteDataProcessor Class

SqlServerDataProcessor Class

RingSoft.DbLookup.DataProcessor.SelectSqlGenerator Namespace

DbSelectSqlGenerator Class

DbSelectSqlGenerator Members

DbSelectSqlGenerator Methods

ConvertValueToSqlText Method

FormatOrderByTableFieldSql Method

FormatSqlObject Method

FormatStringValueForSql Method

FormatValueForSqlWhereItem Method

GenerateConditionSqlText Method

GenerateCountQueryStatement Method

GenerateDeleteStatement Method

GenerateEnumeratorSqlFieldText Method

GenerateFromClause Method

GenerateGroupBy Method

GenerateInsertSqlStatement Method

GenerateJoins Method

GenerateNestedQuery Method

GenerateOrderByClause Method

GenerateSelectClause Method

GenerateSelectQueryStatement Method

GenerateSelectStatement Method

GenerateSetNullStatement Method

GenerateTopRecordCountSqlText Method

GenerateUpdateSql Method

GenerateWhereClause Method

GenerateWhereEnumItemSqlText Method

GenerateWhereItemSqlFieldNameText Method

GenerateWhereItemSqlText Method

DbSelectSqlGenerator Properties

MySqlSelectSqlGenerator Class

SqliteSelectSqlGenerator Class

SqlServerSelectSqlGenerator Class

RingSoft.DbLookup.EfCore Namespace

AdvancedFindColumnConfiguration Class

AdvancedFindConfiguration Class

AdvancedFindFilterConfiguration Class

DbConstants Class

DbContextEfCore Class

DbFieldConstants Class

ExtensionMethods Class

LookupContext Class

MySqlDbConstants Class

RecordLockConfiguration Class

SqliteDbConstants Class

SqlServerDbConstants Class

TestLookupContextBase Class

RingSoft.DbLookup.Lookup Namespace

IJoinParent Interface

ILookupControl Interface

ILookupDataBase Interface

ILookupFormula Interface

ILookupWindow Interface

LookupAddViewArgs Class

LookupCallBackToken Class

LookupColumnAlignmentTypes Enumeration

LookupColumnDefinitionBase Class

LookupColumnDefinitionType(TColumnDefinition) Class

LookupColumnTypes Enumeration

LookupCommand Class

LookupCommandChangedArgs Class

LookupCommands Enumeration

LookupDataChangedArgs Class

LookupDataMaui(TEntity) Class

LookupDataMauiBase Class

LookupDataMauiOutput Class

LookupDataMauiPrintOutput Class

LookupDataMauiProcessInput(TEntity) Class

LookupDataSourceChanged Class

LookupDefinition(TLookupEntity, TEntity) Class

LookupDefinitionBase Class

LookupFieldColumnDefinition Class

LookupFormModes Enumeration

LookupFormulaColumnDefinition Class

LookupJoin Class

LookupJoinTableEntity(TLookupEntity, TEntity, TRelatedEntity) Class

LookupOperations Enumeration

LookupRefresher Class

LookupScrollPositions Enumeration

LookupSearchTypes Enumeration

LookupSelectArgs Class

LookupUserInterface Class

LookupWindowReturnArgs Class

RefreshAlertLevelArgs Class

RefreshOperations Enumeration

SelectedIndexChangedEventArgs Class

TestLookupDataBase(TEntity) Class

RingSoft.DbLookup.ModelDefinition Namespace

ChunkResult Class

ForeignKeyDefinition Class

ForeignKeyFieldJoin Class

IValidationSource Interface

TableDefinition(TEntity) Class

TableDefinitionBase Class

RingSoft.DbLookup.ModelDefinition.FieldDefinitions Namespace

BoolFieldDefinition Class

DateFieldDefinition Class

DecimalFieldDefinition Class

DecimalFieldTypes Enumeration

FieldDefinition Class

FieldDefinitionType(TFieldDefinition) Class

IntegerFieldDefinition Class

StringFieldDefinition Class

RingSoft.DbLookup.QueryBuilder Namespace

RingSoft.DbLookup.RecordLocking Namespace

RecordLock Class

RecordLockingLookup Class

RingSoft.DbLookup.TableProcessing Namespace

AdvancedFilterReturn Class

AdvancedFindFilterDefinition Class

DateFilterTypes Enumeration

FieldFilterDefinition Class

FilterBundle Class

FilterItemDefinition Class

FilterItemType(TFilterItem) Class

FilterItemTypes Enumeration

FormulaFilterDefinition Class

RelatedTableFilterDefinition(TRelatedEntity) Class

RelatedTableFilterDefinitionBase Class

TableFieldJoinDefinition Class

TableFilterCopiedArgs Class

TableFilterDefinition(TEntity) Class

TableFilterDefinitionBase Class

RingSoft.DbLookup.Testing Namespace

DataRepositoryRegistry Class

DataRepositoryRegistryItem(TEntity) Class

DataRepositoryRegistryItemBase Class

TestDataRepository Class

RingSoft.DbMaintenance Namespace

AdvancedFilterViewModel Class

AdvancedFindAfFilterRow Class

AdvancedFindColumnRow Class

AdvancedFindColumnRow.AdvancedFindColumnColumns Enumeration

AdvancedFindColumnsManager Class

AdvancedFindFieldColumnRow Class

AdvancedFindFieldFilterRow Class

AdvancedFindFilterCellProps Class

AdvancedFindFilterRow Class

AdvancedFindFiltersManager Class

AdvancedFindFiltersManager.FilterColumns Enumeration

AdvancedFindFormulaColumnRow Class

AdvancedFindFormulaFilterRow Class

AdvancedFindInput Class

AdvancedFindNewColumnRow Class

AdvancedFindNewFilterRow Class

AdvancedFindPrinterProcessor Class

AdvancedFindViewModel Class

AspChildControlTypeAttribute Class

AspDataFieldAttribute Class

AspDataFieldsAttribute Class

AspMethodPropertyAttribute Class

AspMvcActionAttribute Class

AspMvcActionSelectorAttribute Class

AspMvcAreaAttribute Class

AspMvcAreaMasterLocationFormatAttribute Class

AspMvcAreaPartialViewLocationFormatAttribute Class

AspMvcAreaViewLocationFormatAttribute Class

AspMvcControllerAttribute Class

AspMvcDisplayTemplateAttribute Class

AspMvcEditorTemplateAttribute Class

AspMvcMasterAttribute Class

AspMvcMasterLocationFormatAttribute Class

AspMvcModelTypeAttribute Class

AspMvcPartialViewAttribute Class

AspMvcPartialViewLocationFormatAttribute Class

AspMvcSuppressViewErrorAttribute Class

AspMvcTemplateAttribute Class

AspMvcViewAttribute Class

AspMvcViewComponentAttribute Class

AspMvcViewComponentViewAttribute Class

AspMvcViewLocationFormatAttribute Class

AspRequiredAttributeAttribute Class

AspTypePropertyAttribute Class

AssertionConditionAttribute Class

AssertionConditionType Enumeration

AssertionMethodAttribute Class

BaseTypeRequiredAttribute Class

CanBeNullAttribute Class

CannotApplyEqualityOperatorAttribute Class

CheckDirtyResultArgs Class

CollectionAccessAttribute Class

CollectionAccessType Enumeration

ContractAnnotationAttribute Class

DbAutoFillMap Class

DbMaintenanceDataEntryGridManager(TEntity) Class

DbMaintenanceDataEntryGridManagerBase Class

DbMaintenanceDataEntryGridRow(TEntity) Class

DbMaintenanceModes Enumeration

DbMaintenanceResults Enumeration

DbMaintenanceStatusBarViewModel Class

DbMaintenanceTestGlobals(TViewModel, TView) Class

DbMaintenanceViewModel(TEntity) Class

DbMaintenanceViewModelBase Class

HtmlAttributeValueAttribute Class

HtmlElementAttributesAttribute Class

IAdvancedFindView Interface

IDbMaintenanceDataProcessor Interface

IDbMaintenanceView Interface

ImplicitUseKindFlags Enumeration

ImplicitUseTargetFlags Enumeration

InstantHandleAttribute Class

InvokerParameterNameAttribute Class

IRecordLockingView Interface

ItemCanBeNullAttribute Class

ItemNotNullAttribute Class

LinqTunnelAttribute Class

LocalizationRequiredAttribute Class

LookupMap Class

MacroAttribute Class

MaintenanceKey Enumeration

MeansImplicitUseAttribute Class

MessageButtons Enumeration

MustUseReturnValueAttribute Class

NoEnumerationAttribute Class

NoReorderAttribute Class

NotifyPropertyChangedInvocatorAttribute Class

NotNullAttribute Class

PathReferenceAttribute Class

ProvidesContextAttribute Class

PublicAPIAttribute Class

PureAttribute Class

RazorDirectiveAttribute Class

RazorHelperCommonAttribute Class

RazorImportNamespaceAttribute Class

RazorInjectionAttribute Class

RazorLayoutAttribute Class

RazorPageBaseTypeAttribute Class

RazorSectionAttribute Class

RazorWriteLiteralMethodAttribute Class

RazorWriteMethodAttribute Class

RazorWriteMethodParameterAttribute Class

RecordLockingInputParameter Class

RecordLockingViewModel Class

RegexPatternAttribute Class

SelectArgs Class

SourceTemplateAttribute Class

StringFormatMethodAttribute Class

TerminatesProgramAttribute Class

TestDbMaintenanceProcessor Class

TestDbMaintenanceView Class

TrueFalseValues Enumeration

UiControlMap Class

UsedImplicitlyAttribute Class

ValidationFailArgs Class

ValidationFailControls Enumeration

ValueProviderAttribute Class

ViewModelOperationPreviewEventArgs(TEntity) Class

ViewModelOperations Enumeration

XamlItemBindingOfItemsControlAttribute Class

XamlItemsControlAttribute Class

DbSelectSqlGenerator..::..GenerateSelectQueryStatement Method

Generates the SELECT SQL statement.

Namespace: RingSoft.DbLookup.DataProcessor.SelectSqlGenerator
Assembly: RingSoft.DbLookup (in RingSoft.DbLookup.dll)

Syntax

protected virtual string GenerateSelectQueryStatement(
	SelectQuery selectQuery,
	bool skipOrderBy,
	Nullable<int> count
)

Protected Overridable Function GenerateSelectQueryStatement ( _
	selectQuery As SelectQuery, _
	skipOrderBy As Boolean, _
	count As Nullable(Of Integer) _
) As String

protected:
virtual String^ GenerateSelectQueryStatement(
	SelectQuery^ selectQuery, 
	bool^ skipOrderBy, 
	Nullable<int^> count
)

Parameters

selectQuery: Type: RingSoft.DbLookup.QueryBuilder..::..SelectQuery
The QueryBuilder.SelectQuery object containing all the data for the SQL statement.

skipOrderBy: Type: Boolean
if set to true then don't generate the ORDER BY clause.

count: Type: Nullable<(Of <(<'Int32>)>)>
The count.

Return Value

System.String.

See Also

DbSelectSqlGenerator Class

RingSoft.DbLookup.DataProcessor.SelectSqlGenerator Namespace