Oracle Database Programming with Visual Basic.NET

Concepts, Designs, and Implementations

Ying Bai

• Publisher: Wiley-IEEE Press
• Year: 2021
• Print ISBN: 9781119734390
• eBook ISBN: 9781119734482
• Edition: 1
• Topic: Computer Science
• Subtopic: Programming Languages
• Index: Computer Science

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.

1
Introduction

For many years during my teaching Visual Basic.NET programming and database‐related programming courses in my college, I found that it is not easy to find a good textbook for this topic and I had to combine a few different professional books together as references to teach these courses. Most of those books are specially designed for programmers or software engineers, which cover a lot of programming strategies and huge blocks of codes, which is a terrible headache to the college students or beginning programmers who are new to the Visual Basic.NET and database programming. I have to prepare my class presentations and figure out all home works and exercises for my students. I dream that one day I could find a good textbook that is suitable for the college students or beginning programmers and could be used to help them to learn and master the database programming with Visual Basic.NET easily and conveniently. Finally, I decided that I need to do something for this dream myself after a long time waiting.

Another reason for me to have this idea is the job market. As you know, most industrial and commercial companies in US belong to database application businesses such as manufactures, banks, hospitals, and retails. Majority of them need professional people to develop and build database‐related applications but not database management and design systems. To enable our students to become good candidates for those companies, we need to create a book like this one.

Unlike most of database programming books in the current market, which discuss and present the database programming techniques with huge blocks of programming codes from the first page to the last page, this book tries to use a new writing style to show readers, especially to the college students, how to develop professional and practical database programs with Visual Basic.NET by using Visual Studio.NET Design Tools and Wizards related to ADO.NET and to apply codes that are auto‐generated by various Wizards. By using this new style, the over headache caused by using huge blocks of programming codes can be removed; instead, a simple and easy way to create database programs using the Design Tools can be taken to attract students' learning interest and furthermore to enable students to build professional and practical database programming in more efficient and interesting ways.

There are so many different database‐programming books available on the market, but rarely can you find a book like this one, which implemented a novel writing style to attract the students' learning interests in this topic. To meet the needs of some experienced or advanced students or software engineers, the book contains two programming methods: the interesting and easy‐to‐learn fundamental database programming method – Visual Studio.NET Design Tools and Wizards – and the advanced database programming method – runtime object method. In the second method, all database‐related objects are created and applied during or when your project is running by utilizing quite a few blocks of codes.

1.1 Outstanding Features About This Book

1. All programming projects can be run in Microsoft Visual Studio.NET 2019 with Oracle XE 18c databases.
2. A novel writing style is adopted to try to attract students' or beginning programmers' interests in learning and developing practical database programs and to avoid the headache caused by using huge blocks of codes in the traditional database programming books.
3. Updated database programming tools and components are covered in the book, such as .NET Framework 4.7, LINQ, ADO.NET 4.6, and ASP.NET 4.7, to enable readers to easily and quickly learn and master advanced techniques in database programming and develop professional and practical database applications.
4. A real completed sample database CSE_DEPT with Oracle XE 18c database engine is provided and used for the entire book. Step by step, a detailed illustration and description about how to design and build a practical relational database are provided.
5. Covered both fundamental and advanced database programming techniques to convenience both beginning students and experienced programmers.
6. Provides homework and exercises for students and teaching materials for instructors, and these enable students to understand what they learned better by doing something themselves and allow instructors to organize and prepare their courses easily and rapidly.
7. Good textbook for college students, good reference book for programmers, software engineers, and academic researchers.

1.2 Who This Book Is For

This book is designed for college students and software programmers who want to develop practical and commercial database programming with Visual Basic.NET and relational databases such as Oracle XE 18c. Fundamental knowledge and understanding on Visual Basic.NET and Visual Studio.NET IDE is assumed.

1.3 What This Book Covered

Nine (9) chapters are included in this book. The contents of each chapter can be summarized as below.

• Chapter 1 provides an introduction and summarization to the whole book.
• Chapter 2 provides detailed discussions and analyses of the structure and components about relational databases. Some key technologies in developing and designing database are also given and discussed in this part. The procedure and components used to develop a practical relational database with Oracle XE 18c are analyzed in detailed with some real data tables in our sample database CSE_DEPT.
• Chapter 3 provides an introduction to the ADO.NET, which includes the architectures, organizations, and components of the ADO.NET. Detailed discussions and descriptions are provided in this chapter to give readers both fundamental and practical ideas and pictures in how to use components in ADO.NET to develop professional data‐driven applications. Two ADO.NET architectures are discussed to enable users to follow the directions to design and build their preferred projects based on the different organizations of the ADO.NET. Four popular data providers, such as OleDb, ODBC, SQL Server, and Oracle, are discussed. The basic ideas and implementation examples of DataTable and DataSet are also analyzed and described with some real coding examples.
• Chapter 4 provides detailed discussions and analyses about the Language‐Integrated Query (LINQ), which includes LINQ to Objects, LINQ to DataSet, LINQ to Entities, and LINQ to XML. An introduction to LINQ general programming guide is provided in the first part of this chapter. Some popular interfaces widely used in LINQ, such as IEnumerable, IEnumerable(Of T), IQueryable and IQueryable(Of T), and Standard Query Operators (SQO) including the deferred and non‐deferred SQO, are also discussed in that part. An introduction to LINQ Query is given in the second section of this chapter. Following this introduction, a detailed discussion and analysis about the LINQ queries that are implemented for different data sources is provided in detail with quite a few example projects.
• Starting from Chapter 5, the real database programming techniques with Visual Basic.NET such as data selection queries are provided and discussed. Two parts are covered in this chapter: Part I contains the detailed descriptions in how to develop professional data‐driven applications with the help of the Visual Studio.NET design tools and wizards with some real projects. This part contains a lot of hiding codes that are created by Visual Basic.NET automatically when using those design tools and wizards. Therefore, the coding job for this part is very simple and easy. Part II covers an advanced technique, the runtime object method, in developing and building professional data‐driven applications. Detailed discussions and descriptions about how to build professional and practical database applications using this runtime object method are provided combined with four (4) real projects.
• Chapter 6 provides detailed discussions and analyses about three popular data insertion methods with Oracle XE 18c database:
  1. Using TableAdapter's DBDirect methods TableAdapter.Insert() method.
  2. Using the TableAdapter's Update() method to insert new records that have already been added into the DataTable in the DataSet.
  3. Using the Command object's ExecuteNonQuery() method.
  This chapter is also divi...

Table of contents

• Cover
• Table of Contents
• Series Page
• Title Page
• Copyright Page
• Dedication Page
• About the Author
• Preface
• Acknowledgments
• About the Companion Website
• 1 Introduction
• 2 Introduction to Databases
• 3 Introduction to ADO.NET
• 4 Introduction to Language‐Integrated Query (LINQ)
• 5 Query Data from Oracle Database with Visual Basic.NET
• 6 Insert Data into Oracle Database with Visual Basic.NET
• 7 Data Updating and Deleting with Visual Basic.NET
• 8 Accessing Data in ASP.NET
• 9 ASP.NET Web Services
• Appendix A: Appendix ADownload and Install Oracle Database XE 18c
• Appendix B: Appendix BDownload and Install Oracle SQL Developer
• Appendix C: Appendix CDownload and Install DevExpress WinForms
• Appendix D: Appendix DHow to Use the Sample Database
• Appendix E: Appendix EHow to Export the Sample Database
• Appendix F: Appendix FDownload and Install dotConnect Express
• Appendix G: Appendix GHow to Use User‐Defined Windows/Web Forms
• Appendix H: Appendix HDownload and Install FrontPage Server Extension for Windows 10
• Appendix I: Appendix IDownload and Install LinqConnect Express
• Index
• End User License Agreement