dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlLoader Class / CreateColumns Method

In This Topic
    CreateColumns Method (MySqlLoader)
    In This Topic
    Retrieves table columns information from the table specified in the TableName property and populates columns collection.
    Syntax
    'Declaration
     
    Public Overrides NotOverridable Sub CreateColumns() 
    public override void CreateColumns()
    Remarks

    If Columns property consists of some columns they will be deleted before calling CreateColumns method. TableName property must be set before calling this method.

    CreateColumns retrieves all columns from the table. It means that when inserting the data, SQL INSERT statement is generated for all of the columns, regardless of how many you have assigned with SetValue method. The columns you have omitted are considered to be of NULL value. If you want to generate the statements for chosen columns only, you have to manually edit the collection.

    Note: This method is not supported in .NET Standard 1.3 compatible assembly. It is available only in the assembly for full .NET Framework and .NET Standard 2.0 compatible assembly.

    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also