Method ImportData

Namespace

YndigoBlue.Velocity.Engine

Assembly

YndigoBlue.Velocity.dll

ImportData(Table, string, ImportConfig)

Imports data from a CSV file into a database table.

public void ImportData(Table table, string dataFilePath, ImportConfig importConfig = null)

Parameters

table Table

The Table to import data into.

dataFilePath string

The path to the CSV file containing the data to import.

importConfig ImportConfig

Optional ImportConfig specifying delimiters, mappings, and other import settings. Uses defaults if null.

Examples

using (var m = new Manager(conn))
{
    var schema = m.LoadSchema("app");
    var usersTable = schema["users"];

    // Simple import with default settings
    m.ImportData(usersTable, "users.csv");

    // Import with custom configuration
    var config = new ImportConfig(usersTable);
    config.Delimiter = '|';
    config.HasHeaders = true;
    config.AddMapping("UserName", "name");
    config.AddMapping("EmailAddress", "email");

    m.ImportData(usersTable, "users_pipe_delimited.csv", config);
}

Exceptions

DbException

Thrown when a database error occurs.

InvalidImportMappingsException

Thrown when column mappings are invalid.

ValueSetForAutoGeneratedColumnException

Thrown when attempting to import into an auto-increment column.