Discover a detailed treatment of the practical considerations and applications of Oracle database programming with Visual Basic 2019
Oracle Database Programming with Visual Basic.NET: Concepts, Designs, and Implementations delivers a comprehensive exploration of the foundations of Oracle database programming using Visual Basic.NET. Using Visual Basic.NET 2019, Visual Studio.NET 2019, and Oracle 18c XE, the book introduces the Oracle database development system, Oracle SQL Developer and Modeler, and teaches readers how to implement a sample database solution.
The distinguished author also demonstrates the use of dotConnect for Oracle to show readers how to create an effective connection to an Oracle 18c XE database. The current versions of the .NET framework, ASP.NET, and ASP.NET 4.7 are also explored and used to offer readers the most up to date web database programming techniques available today.
The book provides practical example projects and detailed, line-by-line descriptions throughout to assist readers in the development of their database programming skill. Students will also benefit from the inclusion of: - A thorough introduction to databases, including definitions, examples, descriptions of keys and relationships, and some database components in popular databases, like Access, SQL, and Oracle - An exploration of ADO.NET, including its architecture and components, like the DataReader class, DataSet component, DataTable component, and the command and parameter classes - A discussion of Language Integrated Query (LINQ), including its architecture and components, its relationship to objects, DataSet, Oracle, and Entities - An explanation of how to access data in ASP.NET and ASP.NET Web Services with multiple real project examples.
Perfect for college and university students taking courses related to database programming and applications, Oracle Database Programming with Visual Basic.NET will also earn a place in the libraries of programmers and software engineers seeking a comprehensive reference for database coding in Visual Basic.NET.
Table of Contents
About the Author xivPreface xv
Acknowledgments xvii
About the Companion Website xviii
1 Introduction 1
2 Introduction to Databases 11
3 Introduction to ADO.NET 77
4 Introduction to Language-Integrated Query (LINQ) 123
5 Query Data from Oracle Database with Visual Basic.NET 196
6 Insert Data into Oracle Database with Visual Basic.NET 300
7 Data Updating and Deleting with Visual Basic.NET 355
8 Accessing Data in ASP.NET 401
9 ASP.NET Web Services 476
Appendix A: Download and Install Oracle Database XE 18c 613
Appendix B: Download and Install Oracle SQL Developer 619
Appendix C: Download and Install DevExpress WinForms 622
Appendix D: How to Use the Sample Database 625
Appendix E: How to Export the Sample Database 628
Appendix F: Download and Install dotConnect Express 632
Appendix G: How to Use User-Defined Windows/Web Forms 637
Appendix H: Download and Install FrontPage Server Extension for Windows 10 643
Appendix I: Download and Install LinqConnect Express 646
Index 649
