Oracle Database Programming with Visual Basic.NET

Oracle Database Programming with Visual Basic.NET 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.

About the Author xiv Preface 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