Do we have any bulk copy or bulk insert mechanism into PostgreSQl by using dotConnectForPostgreSQL provider from C#?
I am trying to insert the data(multiple sheets with lakhs of records) from xlsx to PostgreSQl by using c#. But didn't find any suitable method in devart. Bulk insert is available in NpgSQL but i don't want to use Npgsql to avoid driver related issues(specifying kind for date time fields etc..)
Regards, Someshwar
You can use the PgSqlLoader class that is available in dotConnect for PostgreSQL Professional Edition: https://www.devart.com/dotconnect/postgresql/docs/?Devart.Data.PostgreSql~Devart.Data.PostgreSql.PgSqlLoader.html.