Rhino ETL will Support BulkInsert for all Database(sql, oracle, mysql)

[Dev]

Hello,

I just want to know 'Rhino ETL will Support BulkInsert for all Database(sql, oracle, mysql)'

If support where can i start.

Thanks

[Jason Meckley]

BulkInsert is specific to SqlServer. It uses a SqlConnection, not an IDbConnection. Here is the code https://github.com/hibernating-rhinos/rhino-etl/blob/master/Rhino.Etl.Core/Operations/SqlBulkInsertOperation.cs#L275

[Dev]

Can we implement with IDbConnection for all databases

Thanks,

Venkat

[Jason Meckley]

Not sure I understand what you are asking, but BulkInsert operation is specific to SqlServer. It utilized the SqlBulkCopy object which is specific to SqlServer. The same is true for SqlBatchOperation, it's specific to Sql Server. If there is a batch type command for a specific database you should be able to implement your own AbstractDatabaseOperation for the specific driver. Similar to how SqlBatchOperation is specifically implemented for Sql Server..