mercredi 20 janvier 2016

C# ANSI Database Bulk Insert

I am looking for a way to do multi row inserts with C# which can be universal enough so that the same procedures can be applied to more than just SQL Server.

Right now, we have an application that can use SQLite, PostgreSQL, and SQL as a back end to store data, with a possibility of adding Oracle into the mix as well. For that reason, it would be great to have a single procedure that can insert multiple rows in one round trip, and for that same procedure to work regardless of which Data Client is being used. (For this reason, I am not using a SQL Server Stored Procedure).

Aucun commentaire:

Enregistrer un commentaire