Bulk insert using dotConnectForPostgreSQL

Question

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

Please try to avoid using words like lakh that are not globally understood — James Z
– James Z, Commented Nov 18, 2022 at 18:29
I am trying to insert the data(multiple sheets with 100 thousands 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..) — Goli Someshwar
– Goli Someshwar, Commented Nov 18, 2022 at 18:35

Devart · Accepted Answer · 2022-11-21 09:18:01Z

0

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.

answered Nov 21, 2022 at 9:18

Devart

120k23 gold badges172 silver badges189 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Bulk insert using dotConnectForPostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related