Data Updating and Deleting with Visual Basic.NET

This chapter discusses how to update and delete data against the Oracle databases. Many different methods can be provided and supported by Visual Basic.NET and.NET Framework to help users to perform the data updating and deleting against the database. The chapter also discusses updating and deleting data against the database using the Visual Studio.NET Design Tools and Wizards. It provides a sample project named OracleUpdataDeleteRTObject Project, to illustrate how to update or delete records against the Oracle database using the run time object method. Language‐Integrated Query (LINQ) can be used for different components to help to improve performances for database queries. The chapter presents the data updating and deleting by using the run time object method to develop command objects to execute the ExecuteNonQuery() method dynamically. It discusses updating and deleting data against our sample database using the stored procedures and the LINQ to DataSet query methods.