Class Table

Namespace

Dynamicweb.DataIntegration.Integration

Assembly

Dynamicweb.DataIntegration.dll

Used to describe a table in a schema.

public class Table

Inheritance

object

Table

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

ProviderExtensions.SetPrimaryKeyColumn(Table?, string)

Constructors

Table()

Empty constructor, needed for testing. Should not be used.

public Table()

Table(string, Schema, string)

Initializes a new instance of the Table class.

public Table(string name, Schema schema, string sqlSchema)

Parameters

name string

The name.

schema Schema

The schema.

sqlSchema string

The SQL schema.

Table(string, Schema, string, bool)

Initializes a new instance of the Table class.

public Table(string name, Schema schema, string sqlSchema, bool isNew)

Parameters

name string

The name.

schema Schema

The schema.

sqlSchema string

The SQL schema.

isNew bool

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

public Table(XmlNode xmlNode)

Parameters

xmlNode XmlNode

The XML node.

Properties

Columns

Gets the columns.

public virtual ColumnCollection Columns { get; }

Property Value

ColumnCollection

FormattingColumns

public virtual IEnumerable<Column> FormattingColumns { get; }

Property Value

IEnumerable<Column>

IsNew

Gets a value indicating whether this instance is new, and is to be added to the destination when the job is run.

public bool IsNew { get; }

Property Value

bool

true if this instance is new; otherwise, false.

Name

Gets the name.

public virtual string Name { get; }

Property Value

string

Schema

Gets or sets the schema that this column belongs to.

public virtual Schema? Schema { get; }

Property Value

Schema

The schema.

SqlSchema

public virtual string SqlSchema { get; set; }

Property Value

string

Methods

AddColumn(Column)

Adds the column to the table.

public void AddColumn(Column column)

Parameters

column Column

The column.

AddColumn(string, Type)

Adds the column to the table.

public void AddColumn(string columnName, Type columnType)

Parameters

columnName string

The name of the column.

columnType Type

The type of the column.

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.

public Column AddNewColumn(string columnName, Type? type, bool isPrimaryKey, bool readOnly)

Parameters

columnName string

Name of the column.

type Type

The type.

isPrimaryKey bool

if set to true [is primary key].

readOnly bool

if set to true, indicates that the column is read only.

Returns

Column