Importing data from csv file to postgresql table using C# and NPGSQL

Question

I am working in a .net mvc web application with using NPGSQL. In my project, I want to update the records in my postgres database using a .csv file. Maybe someone did it? Can someone send sample code? Someone will tell you how to do it? So far, I have displayed data on my website using C# and NPGSQL.

Shay Rojansky · Accepted Answer · 2020-11-22 18:56:29Z

1

If you're looking to insert new rows, you may want to look at the PostgreSQL COPY feature; this is exposed by Npgsql via this API.

Otherwise you can use a .NET CSV parser and construct UPDATE statements which you can execute manually.

answered Nov 22, 2020 at 18:56

Shay Rojansky

16.9k3 gold badges44 silver badges73 bronze badges

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

Collectives™ on Stack Overflow

Importing data from csv file to postgresql table using C# and NPGSQL

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