Table class

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

public abstract class Korzh.EasyQuery.Db.Table
    : IComparable<Table>


Type Name Description
String categoryName
TableLinkList links List of Korzh.EasyQuery.Db.TableLink which the tables takes part in.
QueryParamList Params The list of parameters associated with this table.


Type Name Description
String Alias Gets or sets the alias.
TableCategory Category Gets or sets the table category.
String DBName Gets or sets the name of the database.
String DesignLayout Gets or sets the design layout (left, top and width, height of the table window in Data Model Editor).
String ExtraCondition Gets or sets the extra condition.
String FullName Gets the full name of the table.
IDictionary<String, Object> Info Stores additional information associated with this entity
Int32 Priority Gets or sets the table's priority. The lower value the more close to the beginning of FROM clause this table will appear
String SchemaName Gets or sets the name of the schema.


Type Name Description
Int32 CompareToTable(Table tbl) Compares the current table with another table alphabetically.
String ComposeAlias(DbQueryFormats formats) Composes the alias.
void EnsureLinkExistence(TableLink link) Ensures the existence of link passed in parameter.
String GetCalcAlias() Gets the calculated alias (used when the "alias" field is empty)
String GetComposedAlias(DbQueryFormats formats)
String GetFromExpr(DbQueryFormats formats) Gets the full name of the table which is used in FROM clause.
TableLinkList GetLinks()
String GetSqlExpr(DbQueryFormats formats) Gets the SQL expression that represents the table in WHERE clause.
String GetSqlName(DbQueryFormats formats) Gets the name that represents the table in SQL expressions.
String GetTableClass() Gets the table class (DB or virtual).
String GetTableName() Gets the name of the table.
void LoadFromXmlReader(XmlReader reader) When overriden in a derived class loads table properties from System.Xml.XmlReader object.
void LoadNodes(XmlReader reader) Loads the sub-nodes of table's node.
Boolean NeedQuote(String s) Gets a value indicating whether string should be quoted
void ProcessAttribute(XmlReader reader) Processes one attribute during XML reading.
String QuoteIfNecessary(String s, DbQueryFormats formats) Puts quotes around identifier if necessary.
void SaveAttributes(XmlWriter writer) Saves table properties to System.Xml.XmlWriter object.
void SaveNodes(XmlWriter writer) Saves the nodes to XML writer.
void SaveToXmlWriter(XmlWriter writer) Saves table properties to System.Xml.XmlWriter object. Calls Korzh.EasyQuery.Db.Table.SaveAttributes(System.Xml.XmlWriter)procedure to do the job.

Static Methods

Type Name Description
Table CreateByClass(String className) Creates Korzh.EasyQuery.Db.Table object the by table class name (db or virtual).