Inserting multiple rows of data into Oracle database from .NET
userLynxJan 27 2009 — edited Mar 11 2009I am trying to populate a table in Oracle that has 90+ columns from a collection in .NET
Is there a way for me to do this from .NET?
I was thinking of using Dynamic SQL to build up the INSERT statement, but I don't want to insert one row at a time. I may have 000s of records to insert and think this would be too slow. Can I do a bulk insert using Dynamic SQL? Is there a better way to do this?
I need to find another way to insert 000s of records into a table that has 90+ columns. Preferably do a bulk insert.
Any help would be greatly appreciated?