Insert

Data insertion can be strictly typed using annotated classes or very lax by using standard classes without any special configuration.

To perform an insert, there must be a call to at least two methods:

• Into<T>() or Into("table_name") to select the target database table.
• Value<T>(row), Value(row), Values<T>(row) or Values(row) to set the row data to insert.

Single Row

Insert a single row and retrieve the Auto-Increment ID as long.

long insertedId = dbConnector.QueryBuilder().Build(query => query
    .Insert()
    .Into<ExampleTable>()
    .Value(new ExampleTable {
        MediumText = "Medium text example value",
        Enum       = EnumExample.N
    })
).Execute<long>();

Multiple Rows

You can either call Value() multiple times or call Values() and provide multiple values at the same time, or call both!

dbConnector.QueryBuilder().Build(query => query
    .Into<ExampleTable>()
    .Value(new ExampleTable {
        MediumText = "Medium text example value",
        Enum       = EnumExample.N
    })
    .Values(new List<ExampleTable> {
        new ExampleTable {
            Json            = @"{""sample_json_field"": ""sample_json_value""}",
            Enum            = EnumExample.Y,
            CustomFieldName = new byte[8] { 81,47,15,21,12,16,23,39 }
        },
        new ExampleTable {
            Longtext = "Long text example value",
            Enum     = EnumExample.N
        }
    })
    .Insert()
).Execute();

⚠️ Critical: Do not mix rows with and without primary key values in the same batch.

❌ Dangerous:

.Values(new List<ExampleTable> {
    new ExampleTable { Id = 1, Longtext = "Bad!"  }, // ❌ Don't set ID manually!
    new ExampleTable {         Longtext = "Good!" }
})