I would like use a datatable of undetermined number of rows from a c#.net app to replace all rows in an existing oracle table. Basically the functionality I am going for is an edit, save function for a static table, for example, but I would like to do it by using the datatable in order to separate the view from the actual database access.
- in the view. user edits datagridview A, "saves" by clicking a button.
- data is bound to a C# .net datatable B
- some call using the Oracle.DataAccess.Client namespace overwrites
Oracle Table C with the data from .net datatable B.
Does anyone know what is the best way to communicate from the c# code to oracle and accomplish this? I saw the below on stackoverflow, but it was not conclusive. Should I use OracleBulkCopy Class? how do I overwrite the entire Oracle Table C instead of appending it (the asker seemed to have that issue)?
DataTable To database Update oracle http://stackoverflow.com/q/9224146/613799