Skip to content

Table class

Table class represents one table in a Korzh.EasyQuery.Db.DbModel object

public abstract class Korzh.EasyQuery.Db.Table
: IComparable<Table>
TypeNameDescription
StringcategoryName
TableLinkListlinksList of Korzh.EasyQuery.Db.TableLink which the tables takes part in.
QueryParamListParamsThe list of parameters associated with this table.
TypeNameDescription
StringAliasGets or sets the alias.
TableCategoryCategoryGets or sets the table category.
StringDBNameGets or sets the name of the database.
StringDesignLayoutGets or sets the design layout (left, top and width, height of the table window in Data Model Editor).
StringExtraConditionGets or sets the extra condition.
StringFullNameGets the full name of the table.
IDictionary<String, Object>InfoStores additional information associated with this entity
Int32PriorityGets or sets the table’s priority. The lower value the more close to the beginning of FROM clause this table will appear
StringSchemaNameGets or sets the name of the schema.
TypeNameDescription
Int32CompareToTable(Table tbl)Compares the current table with another table alphabetically.
StringComposeAlias(DbQueryFormats formats)Composes the alias.
voidEnsureLinkExistence(TableLink link)Ensures the existence of link passed in parameter.
StringGetCalcAlias()Gets the calculated alias (used when the “alias” field is empty)
StringGetComposedAlias(DbQueryFormats formats)
StringGetFromExpr(DbQueryFormats formats)Gets the full name of the table which is used in FROM clause.
TableLinkListGetLinks()
StringGetSqlExpr(DbQueryFormats formats)Gets the SQL expression that represents the table in WHERE clause.
StringGetSqlName(DbQueryFormats formats)Gets the name that represents the table in SQL expressions.
StringGetTableClass()Gets the table class (DB or virtual).
StringGetTableName()Gets the name of the table.
voidLoadFromXmlReader(XmlReader reader)When overriden in a derived class loads table properties from System.Xml.XmlReader object.
voidLoadNodes(XmlReader reader)Loads the sub-nodes of table’s node.
BooleanNeedQuote(String s)Gets a value indicating whether string should be quoted
voidProcessAttribute(XmlReader reader)Processes one attribute during XML reading.
StringQuoteIfNecessary(String s, DbQueryFormats formats)Puts quotes around identifier if necessary.
voidSaveAttributes(XmlWriter writer)Saves table properties to System.Xml.XmlWriter object.
voidSaveNodes(XmlWriter writer)Saves the nodes to XML writer.
voidSaveToXmlWriter(XmlWriter writer)Saves table properties to System.Xml.XmlWriter object. Calls Korzh.EasyQuery.Db.Table.SaveAttributes(System.Xml.XmlWriter)procedure to do the job.
TypeNameDescription
TableCreateByClass(String className)Creates Korzh.EasyQuery.Db.Table object the by table class name (db or virtual).