DbQuery MembersEasyQuery WinForms API Reference

The DbQuery type exposes the following members.
Constructors

  NameDescription
Public methodDbQuery 
Initializes a new instance of the DbQuery class.
Public methodDbQuery(Query)
Initializes a new instance of the DbQuery class.
Protected methodDbQuery(SerializationInfo, StreamingContext)
Initializes a new instance of the DbQuery class.
Back to Top
Methods

  NameDescription
Protected methodAddAttributeParams
Adds the parameters associated with some entity attribute into the list of query parameters (see Params.
(Overrides Query AddAttributeParams(EntityAttr).)
Public methodAddPredicate
Creates new predicate (condition group) and adds it into the query.
(Inherited from Query.)
Public methodAddSimpleCondition
Creates new simple condition and adds it into the query.
(Inherited from Query.)
Public methodCheckDataModel
Checks the data model object. Generates an exception if Model property has null value.
(Inherited from Query.)
Public methodClear
Clears the query conditions and result columns.
(Inherited from Query.)
Protected methodCoreClear
Clears all query content. Can be overriden in derived classes.
(Overrides Query CoreClear .)
Protected methodCoreRefreshParams
Refreshes the list of query parameters by parameters associated with attributes used in query columns .
(Inherited from Query.)
Public methodCreateAggrFuncExpr
Creates the aggregate function expression.
(Overrides Query CreateAggrFuncExpr(DataModel, String, Expression).)
Public methodCreateColumn 
Creates the column.
(Overrides Query CreateColumn .)
Public methodCreateColumn(EntityAttr)
Creates a column by EntityAttr object.
(Inherited from Query.)
Public methodCreateEntityAttrExpr
Creates the entity attribute expression.
(Overrides Query CreateEntityAttrExpr(DataModel, EntityAttr).)
Public methodOnlineCreateObjRef
Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
(Inherited from OnlineMarshalByRefObject.)
Protected methodCreateOptionsObject
Creates the Options object.
(Overrides Query CreateOptionsObject .)
Public methodCreateParentEntityAttrExpr
Creates the parent entity attribute expression.
(Overrides Query CreateParentEntityAttrExpr(DataModel, EntityAttr).)
Public methodCreatePredicate 
Creates a new predicate.
(Overrides Query CreatePredicate .)
Public methodCreatePredicate(DataModel)Obsolete.
Creates the predicate.
(Inherited from Query.)
Public methodCreateRootPredicate
Creates the root predicate.
(Inherited from Query.)
Public methodCreateSilentPredicate
Creates a new "silent" predicate. Here "silent" means neither this predicate nor its conditions will raise ConditionsChanged event in associated query
(Inherited from Query.)
Public methodCreateSimpleCondition 
Creates the simple condition.
(Overrides Query CreateSimpleCondition .)
Public methodCreateSimpleCondition(DataModel)Obsolete.
Creates the simple condition.
(Overrides Query CreateSimpleCondition(DataModel).)
Public methodCreateSimpleCondition(String, String,  String )
Creates a simple condition with indicated attribute, operator and values.
(Inherited from Query.)
Public methodCreateSimpleCondition(EntityAttr, Operator,  Expression )
Creates a simple condition with indicated attribute, operator and values.
(Inherited from Query.)
Public methodCreateSubQuery
Creates the subquery.
(Overrides Query CreateSubQuery .)
Protected methodDeserialize
Deserializes the query.
(Inherited from Query.)
Public methodOnlineDispose 
Releases all resources used by the OnlineComponent.
(Inherited from OnlineComponent.)
Protected methodDispose(Boolean)
Releases the unmanaged resources used by the OnlineComponent and optionally releases the managed resources.
(Inherited from Query.)
Public methodOnlineEquals
Determines whether the specified OnlineObject is equal to the current OnlineObject.
(Inherited from OnlineObject.)
Protected methodOnlineFinalize
Releases unmanaged resources and performs other cleanup operations before the OnlineComponent is reclaimed by garbage collection.
(Inherited from OnlineComponent.)
Public methodGetConditionsText
Returns human-readable text that represents current query conditions
(Inherited from Query.)
Protected methodGetFormats
Gets the formats of generated query language (SQL or other).
(Overrides Query GetFormats .)
Public methodOnlineGetHashCode
Serves as a hash function for a particular type.
(Inherited from OnlineObject.)
Public methodOnlineGetLifetimeService
Retrieves the current lifetime service object that controls the lifetime policy for this instance.
(Inherited from OnlineMarshalByRefObject.)
Public methodGetOneValueForAttr
Gets the one value set in some query condition for indicated entity attribute
(Inherited from Query.)
Public methodGetParentQueryRootEntity
Gets the entities from parent query.
(Overrides Query GetParentQueryRootEntity .)
Protected methodOnlineGetService
Returns an object that represents a service provided by the OnlineComponent or by its OnlineContainer.
(Inherited from OnlineComponent.)
Public methodOnlineGetType
Gets the OnlineType of the current instance.
(Inherited from OnlineObject.)
Public methodGetUsedEntities
Gets the list of used entities.
Public methodGetUsedTables
Gets the used tables.
Public methodOnlineInitializeLifetimeService
Obtains a lifetime service object to control the lifetime policy for this instance.
(Inherited from OnlineMarshalByRefObject.)
Public methodLoadFromDictionary(IDictionary String, Object )
Loads query from some OnlineIDictionary object. Useful for JSON serialization
(Inherited from Query.)
Public methodLoadFromDictionary(IDictionary String, Object , Query RWOptions)
Loads query from some OnlineIDictionary object. Useful for JSON serialization
(Inherited from Query.)
Public methodLoadFromFile(String)
Loads query from file.
(Inherited from Query.)
Public methodLoadFromFile(String, Query RWOptions)
Loads query from file.
(Inherited from Query.)
Public methodLoadFromStream(Stream)
Loads query from stream.
(Inherited from Query.)
Public methodLoadFromStream(Stream, Query RWOptions)
Loads query from stream.
(Inherited from Query.)
Public methodLoadFromString(String)
Loads query from string.
(Inherited from Query.)
Public methodLoadFromString(String, Query RWOptions)
Loads query from string.
(Inherited from Query.)
Public methodLoadFromXmlReader(XmlReader)
Loads query from XML reader.
(Inherited from Query.)
Public methodLoadFromXmlReader(XmlReader, Query RWOptions)
Loads query from XML reader.
(Inherited from Query.)
Protected methodLoadNode
Loads the root node.
(Overrides Query LoadNode(XmlReader, Query RWOptions).)
Protected methodOnlineMemberwiseClone 
Creates a shallow copy of the current OnlineObject.
(Inherited from OnlineObject.)
Protected methodOnlineMemberwiseClone(Boolean)
Creates a shallow copy of the current OnlineMarshalByRefObject object.
(Inherited from OnlineMarshalByRefObject.)
Public methodNewModel
Creates a new model (an object of DataModel class or its descendant).
(Overrides Query NewModel .)
Protected methodOnColumnsChanged
Raises the ColumnsChanged event.
(Inherited from Query.)
Protected methodOnColumnsChanging
Raises the [E:ColumnsChanging] event.
(Inherited from Query.)
Protected methodOnConditionsChanged
Raises the ConditionsChanged event.
(Inherited from Query.)
Protected methodOnSortOrderChanged
Raises the [E:SortOrderChanged] event.
(Inherited from Query.)
Protected methodOnSubQueryConditionsChanged
Raises the [E:SubQueryConditionsChanged] event.
(Inherited from Query.)
Public methodRefreshParams
Refreshes the list of query parameters by parameters associated with attributes used in query columns .
(Inherited from Query.)
Protected methodResyncSortingList
Resynchronizes the sorting list of columns correspondingly to their order.
(Inherited from Query.)
Protected methodSaveNodes
Saves the root nodes.
(Overrides Query SaveNodes(XmlWriter, Query RWOptions).)
Public methodSaveToDictionary
Saves query into some OnlineIDictionary object. Useful for JSON serialization
(Inherited from Query.)
Public methodSaveToFile(String)
Saves query to XML file.
(Inherited from Query.)
Public methodSaveToFile(String, Query RWOptions)
Saves query to XML file.
(Inherited from Query.)
Public methodSaveToStream(Stream)
Saves query XML to stream.
(Inherited from Query.)
Public methodSaveToStream(Stream, Query RWOptions)
Saves query XML to stream.
(Inherited from Query.)
Public methodSaveToString 
Saves query to string containing the XML.
(Inherited from Query.)
Public methodSaveToString(Query RWOptions)
Saves query to string containing the XML.
(Inherited from Query.)
Public methodSaveToXmlWriter
Saves query to XML using XML writer.
(Inherited from Query.)
Protected methodSerialize
Serializes the specified information.
(Inherited from Query.)
Public methodOnlineToString
Returns a OnlineString containing the name of the OnlineComponent, if any. This method should not be overridden.
(Inherited from OnlineComponent.)
Public methodValidate
Validates this query instance. This method throws an exception if query has "ghost" attributes
(Inherited from Query.)
Back to Top
Fields

  NameDescription
Protected fieldcolumns
List of all query columns
(Inherited from Query.)
Protected fieldfilePath
Query file location if query is loaded from file
(Inherited from Query.)
Protected fieldjustSortedColumns
List of just sorted coumns
(Inherited from Query.)
Protected fieldqueryDescription
User-defined query description
(Inherited from Query.)
Protected fieldqueryName
User-defined name of the query
(Inherited from Query.)
Protected fieldroot
Root predicate of the query
(Inherited from Query.)
Protected fieldserializationQueryXml
Serialized query
(Inherited from Query.)
Protected fieldsortedColumns
List of sorted columns
(Inherited from Query.)
Back to Top
Properties

  NameDescription
Protected propertyOnlineCanRaiseEvents
Gets a value indicating whether the component can raise an event.
(Inherited from OnlineComponent.)
Public propertyColumns
Gets the columns.
(Inherited from Query.)
Public propertyOnlineContainer
Gets the OnlineIContainer that contains the OnlineComponent.
(Inherited from OnlineComponent.)
Protected propertyOnlineDesignMode
Gets a value that indicates whether the OnlineComponent is currently in design mode.
(Inherited from OnlineComponent.)
Protected propertyOnlineEvents
Gets the list of event handlers that are attached to this OnlineComponent.
(Inherited from OnlineComponent.)
Public propertyExtraColumns
Gets or sets the extra columns.
(Inherited from Query.)
Public propertyExtraConditions
Gets the list of extra conditions for this query. These conditions are not visible to end-users but included into result SQL statement as all others (defined in Root predicate).
(Inherited from Query.)
Public propertyExtraTables
Gets the list of "extra" tables (the tables which will be included into result query by user request).
Public propertyFilePath
Gets the query file path. It is automatically assigned when you use LoadFromFile method.
(Inherited from Query.)
Public propertyFormats
Gets or sets the formats used during SQL statements building.
Public propertyID
Gets or sets the ID of this query.
(Inherited from Query.)
Public propertyIsEmpty
Gets a value indicating whether this query is empty (no columns and no conditions are defined).
(Inherited from Query.)
Public propertyJustSortedColumns
Gets the list of "just sorted" columns (the columns which will occur only in ORDER BY clause)
(Inherited from Query.)
Public propertyModel
Gets or sets the data model used in this query.
(Inherited from Query.)
Public propertyNoPathResolution
Get or set the type of reaction for the situation when two tables have no path between them
Public propertyOptions
Gets the options that allows to alter the result query.
Public propertyParams
Gets the list of parameters used in generated SQL statement.
(Inherited from Query.)
Public propertyParent
Gets the parent query.
(Inherited from Query.)
Public propertyQueryDescription
Gets or sets the query description.
(Inherited from Query.)
Public propertyQueryName
Gets or sets the name of the query.
(Inherited from Query.)
Public propertyResultColumns
Gets the full list of columns which will be returned in result query. It equals to Columns list if it's not empty. Otherwise - it's an array of all fields from all tables taking part in this query (like SELECT * in SQL).
Public propertyRoot
Gets the root predicate of the query.
(Inherited from Query.)
Public propertyOnlineSite
Gets or sets the OnlineISite of the OnlineComponent.
(Inherited from OnlineComponent.)
Public propertySortedColumns
Gets the list of sorted columns.
(Inherited from Query.)
Public propertyStoreModelPath
Gets or sets a value indicating whether this Query object should store the path to corresponding data model and restore it during query loading.
(Inherited from Query.)
Public propertyStoreOptions
Gets or sets a value indicating whether this Query object should store the options and restore them during query loading.
(Inherited from Query.)
Public propertySyncColSortOrder
Gets or sets a value indicating whether the order of columns must be synchronized with their sorting order.
(Inherited from Query.)
Public propertyTexts
Gets an instance of TextStorage object which holds all text resources used in this assembly
(Inherited from Query.)
Back to Top
Events

  NameDescription
Public eventColumnsChanged
This event is raised when the list of query result columns or a particular column was changed. For example some column was added or some was deleted.
(Inherited from Query.)
Public eventColumnsChanging
This event is raised before the list of query columns or a particular column is going to be changed. For example some column will be added or deleted.
(Inherited from Query.)
Public eventConditionsChanged
This event is raised when list of query conditions or a particular condition was changed. For example some condition was added or some - was deleted.
(Inherited from Query.)
Public eventCondSqlGen
This event is raised during query building for each condition in the query and it allows you to replace the SQL expression generated for this condition.
Public eventOnlineDisposed
Occurs when the component is disposed by a call to the OnlineDispose  method.
(Inherited from OnlineComponent.)
Public eventModelChanged
Occurs after the model has been changed.
(Inherited from Query.)
Public eventSortOrderChanged
Occurs when the list of sorted columns was changed.
(Inherited from Query.)
Public eventSubQueryConditionsChanged
This event is raised when list of subquery conditions or a particular condition was changed. For example some condition was added or some - was deleted.
(Inherited from Query.)
Back to Top
See Also