Class Table
- Namespace
- Dynamicweb.Data
Integration .Integration
- Assembly
- Dynamicweb.DataIntegration.dll
Used to describe a table in a schema.
- Inheritance
-
Table
- Inherited Members
Constructors
Table()
Empty constructor, needed for testing. Should not be used.
Table(string, Schema, string)
Initializes a new instance of the Table class.
Parameters
Table(string, Schema, string, bool)
Initializes a new instance of the Table class.
Parameters
name
stringThe name.
schema
SchemaThe schema.
sqlSchema
stringThe SQL schema.
isNew
boolif set to
true
, this table is to be added to the destination when the job is run.
Table(XmlNode)
Initializes a new instance of the Table class from XML input.
Parameters
xmlNode
XmlNode The XML node.
Properties
Columns
Gets the columns.
Property Value
FormattingColumns
Property Value
IsNew
Gets a value indicating whether this instance is new, and is to be added to the destination when the job is run.
Property Value
- bool
true
if this instance is new; otherwise,false
.
Name
Gets the name.
Property Value
Schema
Gets or sets the schema that this column belongs to.
Property Value
- Schema
The schema.
SqlSchema
Property Value
Methods
AddColumn(Column)
Adds the column to the table.
Parameters
column
ColumnThe column.
AddColumn(string, Type)
Adds the column to the table.
Parameters
AddNewColumn(string, Type, bool, bool)
Adds the new column to the table. This column will bed added to the table, when the job is run.
Parameters
columnName
stringName of the column.
type
TypeThe type.
isPrimaryKey
boolif set to
true
[is primary key].readOnly
boolif set to
true
, indicates that the column is read only.