Hi,
A very easy way will be ADO.NET which provides you an object called DataSet which you can use it to read an XML file and then store it into a database.
See
DataSet.ReadXml to know how to read XML by dataset.
This
link also talks about the same scope.
If you also would like to know how to update your databasse from datasedt you can also go to this
link
To know how to work with ADO.Net in VB.Net go to the below link:
ADO.NET code examples | Microsoft Docs[
^]
A very trivial example of using Oracle adapter in ADO.NET would be like this:
OracleDataAdapter da = new OracleDataAdapter();
OracleCommand cmdOra = new OracleCommand(StoredProcedureName, Connection);
cmdOra.CommandType = CommandType.StoredProcedure;
da.InsertCommand = cmdOra;
da.Update(dsDataSet);
If you want you can use ODP.NET which is also based on ADO.Net in VB to connect oracle db see the below link PLEASE:
Getting Started with Oracle Data Provider for .NET (VB.NET Version)[
^]
If this did not solve your problem then please leave a comment and I will assist you by improving my solution until your problem gets solved.
Cheers,
AH