cajuncoding / sqlbulkhelpers Goto Github PK

When the table does not have an identity column, the SqlBulkHelpersMergeScriptBuilder generates an empty identitycolumn name and it generates the sql for the temporary table as
SELECT TOP(0) 1 as [{identityColumnName}],

This gives a SQL exception, maybe skip it or generate a unique name ?

if I have a table have the column Id,key,value, the id is primarykey, but I want to use key column as the merge key,if the key is same,then update,otherwise insert to the source table.how to do that? thanks!

Currently the library only supports INT identity columns. Would be nice to support BIGINT for different design scenarios. i.e. multi-tenant SAAS applications. GUIDS are another use case, but probably not easy to implement.

Thanks!

Throws straight up when newing up the Helper with a TypeInitializationException. Pity.

Inner Exception

The application configuration is missing a value for setting [SqlConnectionString], so default Sql Connection cannot be initialized; check the App.config Xml file and try again.

                    await using var connection = database.GetConnection();

                    await connection.OpenAsync();

                    await using var transaction = connection.BeginTransaction(IsolationLevel.ReadUncommitted);

                    ISqlBulkHelper<SomeType> sqlBulkIdentityHelper = new SqlBulkIdentityHelper<SomeType>();

                    await sqlBulkIdentityHelper.BulkInsertOrUpdateAsync(myData, "SomeTable", transaction);

Nice library you created here.

I have been looking through the code and there doesn't appear to be a way to dynamically map columns. All of the "Bulk" methods take an IEnumerable as the first argument. I saw where you can decorate the entity properties with a ModelMapping attribute, but what if the mapping isn't know until runtime?

In my case I have a front end client that allows the user to map the columns themselves.

Is there a way to pass in the model mappings at runtime and hook the ColumnMappings.Add() method??

Thanks!