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

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

ColumnTypes Enumeration

Conditions Enumeration

CountQuery Class

DbDateTypes Enumeration

EndLogics Enumeration

InsertDataStatement Class

JoinField Class

JoinTypes Enumeration

OrderByEnumSegment Class

OrderByFormulaSegment Class

OrderBySegment Class

OrderBySegmentTypes Enumeration

OrderByTypes Enumeration

PrimaryJoinTable Class

QueryBase Class

QueryTable Class

QueryTypes Enumeration

SelectColumn Class

SelectEnumColumn Class

SelectFormulaColumn Class

SelectQuery Class

SelectQuery Members

SelectQuery Constructor

SelectQuery Methods

AddOrderByBoolTextSegment Method

AddOrderByEnumSegment Method

AddOrderByFormulaSegment Method

AddOrderBySegment Method

AddPrimaryJoinTable Method

AddSelectBooleanColumn Method

AddSelectColumn Method

AddSelectEnumColumn Method

AddSelectFormulaColumn Method

AddWhereItem Method

AddWhereItemBoolText Method

AddWhereItemCheckNull Method

AddWhereItemEnum Method

AddWhereItemFormula Method

AddWhereItemFormula Method (String, Conditions, String)

AddWhereItemFormula Method (String, Conditions, DateTime, DbDateTypes)

AddWhereItemFormula Method (String, Conditions, Int32)

AddWhereItemFormula Method (String, Conditions, Double)

AddWhereItemFormula Method (String, Conditions, Boolean)

AddWhereItemFormula Method (String)

BoolToString Method

CopySelectColumnsToTopLevelQuery Method

RemoveWhereItem Method

SetMaxRecords Method

SelectQuery Properties

SelectQueryColumnFieldMap Class

SelectQueryMaui(TEntity) Class

SelectQueryMauiBase Class

UpdateDataStatement Class

ValueTypes Enumeration

WhereEnumItem Class

WhereFormulaItem Class

WhereItem Class

WhereItemTypes Enumeration

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

SelectQuery..::..AddWhereItemFormula Method (String, Conditions, String)

Creates a where item formula object and adds it to the WhereItems list.

Namespace: RingSoft.DbLookup.QueryBuilder
Assembly: RingSoft.DbLookup (in RingSoft.DbLookup.dll)

Syntax

public WhereFormulaItem AddWhereItemFormula(
	string formula,
	Conditions condition,
	string value
)

Public Function AddWhereItemFormula ( _
	formula As String, _
	condition As Conditions, _
	value As String _
) As WhereFormulaItem

public:
WhereFormulaItem^ AddWhereItemFormula(
	String^ formula, 
	Conditions^ condition, 
	String^ value
)

Parameters

formula: Type: String
The formula.

condition: Type: RingSoft.DbLookup.QueryBuilder..::..Conditions
The condition.

value: Type: String
The value.

Return Value

WhereFormulaItem.

See Also

SelectQuery Class

AddWhereItemFormula Overload

RingSoft.DbLookup.QueryBuilder Namespace