Table class

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

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

Fields

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.

Properties

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.

Methods

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).