Oracle Database Programming with Visual Basic.NET: Concepts, Designs, and Implementations

by Ying Bai

Overview

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.

Product Details

ISBN-13:	9781119734390
Publisher:	Wiley
Publication date:	05/11/2021
Pages:	672
Product dimensions:	0.39(w) x 0.39(h) x 0.39(d)

About the Author

Ying Bai, PhD, is Professor in the Department of Computer Science and Engineering at Johnson C. Smith University. He is the author of Practical Microcontroller Engineering with ARM Technology, Practical Database Programming with Visual Basic.NET, 2nd Edition, Practical Database Programming with Java, and Practical Database Programming with Visual C#.NET.

Table of Contents

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