Column Map

Defines the mapping of Grooper fields to columns in a database table for data export.

Remarks

The ColumnMap class is used within a Table Mapping to configure how data from Grooper fields is exported to columns in a target database table.

Purpose

• Specify which Grooper fields (or expressions) populate each column in the database table.
• Support direct field mapping, calculated values, formatting, and advanced expressions.

How It Works

• Each entry in the map associates a database column name with a Visual Basic .NET expression.
• Expressions can reference fields, perform calculations, or format values as needed for the target column.
• During export, the expression for each column is evaluated in the context of the current data instance, and the result is written to the database.

Configuration

• Use the property grid to add or edit column mappings.
• Select a database column and assign an expression to define its exported value.
• The list of available columns is determined by the target table in the parent Table Mapping.

Example Scenarios

• Map a field named "InvoiceNumber" to the "Invoice_ID" column.
• Format a date field for export: Billed_Date.ToString("yyyy-MM-dd")
• Concatenate multiple fields: $"{FirstName} {LastName}"
• Export a static value: "Active"

Notes

• Expressions must evaluate to a type compatible with the target database column.

Context Menu Commands

Command	Shortcut	Description
conversion_path Auto Map		Automatically maps database table columns to Grooper fields based on name similarity and data type compatibility.

Used By

Table Mapping