Skip to main content
Version: 1.17

Import Into Database (Entity)

Import values from an Entity list into a database table. If the ID column is defined as an identity column in your database, row values for that column will be ignored during the insert. The insert action has a 10min Bulk Copy Timeout.

Parameter Reference#

ParameterDescriptionSupports TokensDefault
Connection StringLeave empty to conect to the DNN database. Connect to a different database by providing the name of a connection string from web.config or a connection string (read connectionstrings.com for more info).NoNone
Prefix Database SchemaLeave empty for the default database schema.NoNone
Table NameSelect the table to import data into.NoNone
Entity NameName the entity so you can reference it later by name. Can contain My Tokens.YesNone
Insert all valuesCheck this option if you want to try and insert all values from the entity list.NoNone
PropertiesMap columns to properties of the entity.NoNone
Merge Existing ValuesCheck this option if you want to try and update all values from the entity list that have a corresponding row in the database table.If the primary key value is not specified it will try to automatically assign it which might lead to problems.This option can increase the execution time for large amounts of data.NoNone
Only Update ValuesCheck this option if you do not want to insert new data rows into the table, only update. This option requires Merge Existing Values to be checked.This option can increase the execution time for large amounts of data.NoNone
Delete Non-Existing ValuesCheck this option if you want to try and delete all values from the database table that do not have a corresponding item in the entity list.This option can increase the execution time for large amounts of data.NoNone
On ErrorDefine a list of actions to run on error. Otherwise, an error message is returned which will contain the underlying error if debug mode is on.No[]