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

Cover
Title Page
Copyright Page
Contents
About the Author
Preface
Acknowledgments
About the Companion Website
Chapter 1 Introduction
	1.1 Outstanding Features About This Book
	1.2 Who This Book Is For
	1.3 What This Book Covered
	1.4 How This Book Is Organized and How to Use This Book
	1.5 How to Use Appendices and Related Materials
	1.6 How to Use Source Codes and Sample Database
	1.7 Instructors and Customer Supports
Chapter 2 Introduction to Databases
	2.1 What Are Databases and Database Programs?
		2.1.1 File Processing System
		2.1.2 Integrated Databases
	2.2 Develop a Database
	2.3 Sample Database
		2.3.1 Relational Data Model
		2.3.2 Entity-Relationship (ER) Model
	2.4 Identifying Keys
		2.4.1 Primary Key and Entity Integrity
		2.4.2 Candidate Key
		2.4.3 Foreign Keys and Referential Integrity
	2.5 Define Relationships
		2.5.1 Connectivity
	2.6 ER Notation
	2.7 Data Normalization
		2.7.1 First Normal Form (1NF)
		2.7.2 Second Normal Form (2NF)
		2.7.3 Third Normal Form (3NF)
	2.8 Database Components in Some Popular Databases
		2.8.1 Microsoft Access Databases
		2.8.2 SQL Server Databases
		2.8.3 Oracle Databases
	2.9 Create Oracle 18c XE Sample Database
		2.9.1 Delete the Default Database XE
		2.9.2 Create a New Oracle 18c XE Sample Database
		2.9.3 Connect to Our Sample Database from the Oracle SQL Developer
		2.9.4 Create an Oracle User Account for the User Schema
		2.9.5 Create LogIn Table
		2.9.6 Create Faculty Table
		2.9.7 Create Other Tables
		2.9.8 Create Relationships Among Tables
		2.9.9 Store Images to the Oracle 18c Express Edition Database
	2.10 Chapter Summary
	Homework
		I.  True/False Selections
		II.  Multiple Choices
		III.  Exercises
Chapter 3 Introduction to ADO.NET
	3.1 The ADO and ADO.NET
	3.2 Overview of the ADO.NET
	3.3 The Architecture of the ADO.NET
	3.4 The Components of ADO.NET
		3.4.1 The Data Provider
		3.4.2 The Connection Class
		3.4.3 The Command and the Parameter Classes
		3.4.4 The DataAdapter Class
		3.4.5 The DataReader Class
		3.4.6 The DataSet Component
		3.4.7 The DataTable Component
		3.4.8 ADO.NET Entity Framework
	3.5 Chapter Summary
	Homework
		I.  True/False Selections
		II.  Multiple Choices
		III.  Exercises
Chapter 4 Introduction to Language-Integrated Query (LINQ)
	4.1 Overview of Language-Integrated Query
		4.1.1 Some Special Interfaces Used in LINQ
		4.1.2 Standard Query Operators
		4.1.3 Deferred Standard Query Operators
		4.1.4 Non-Deferred Standard Query Operators
	4.2 Introduction to LINQ
	4.3 The Architecture and Components of LINQ
		4.3.1 Overview of LINQ to Objects
		4.3.2 Overview of LINQ to DataSet
		4.3.3 Overview of LINQ to SQL
		4.3.4 Overview of LINQ to Entities
		4.3.5 Overview of LINQ to XML
	4.4 LINQ to Objects
		4.4.1 LINQ and ArrayList
		4.4.2 LINQ and Strings
		4.4.3 LINQ and File Directories
		4.4.4 LINQ and Reflection
	4.5 LINQ to DataSet
		4.5.1 Operations to DataSet Objects
		4.5.2 Operations to DataRow Objects Using the Extension Methods
		4.5.3 Operations to DataTable Objects
	4.6 LINQ to Entities
		4.6.1 The Object Services Component
		4.6.2 The ObjectContext Component
		4.6.3 The ObjectQuery Component
		4.6.4 LINQ to Entities Flow of Execution
		4.6.5 Implementation of LINQ to Entities
	4.7 LINQ to XML
		4.7.1 LINQ to XML Class Hierarchy
		4.7.2 Manipulate XML Elements
		4.7.3 Manipulate XML Attributes
		4.7.4 Query XML with LINQ to XML
	4.8 Visual Basic.NET Language Enhancement for LINQ
		4.8.1 Lambda Expressions
		4.8.2 Extension Methods
		4.8.3 Implicitly Typed Local Variables
		4.8.4 Query Expressions
	4.9 LINQ To Oracle
	4.10 Chapter Summary
	Homework
		I.  True/False Selections
		II.  Multiple Choices
		III.  Exercises
Chapter 5 Query Data from Oracle Database with Visual Basic.NET
	Part I: Data Query with Visual Studio.NET Design Tools and Wizards
		5.1 A Completed Sample Database Application Example
		5.2 Visual Studio.NET Design Tools and Wizards
		5.3 Query Data from Oracle Database Using Design Tools and Wizards
		5.4 Use Visual Studio Wizards and Design Tools to Query and Display Data
	Part II: Data Query with Runtime Objects
		5.5 Introduction to Runtime Objects
		5.6 Query Data From Oracle Server Database Using Runtime Object
		5.7 Chapter Summary
	Homework
		I.  True/False Selections
		II.  Multiple Choices
		III.  Exercises
Chapter 6 Insert Data into Oracle Database with Visual Basic.NET
	Part I: Insert Data with Visual Basic.NET Design Tools and Wizards
		6.1 Insert Data into a Database
		6.2 Insert Data into Oracle Database Using a Sample Project InsertWizard
	Part II: Data Insertion with Runtime Objects
		6.3 The General Run-Time Objects Method
		6.4 Insert Data into the Oracle Database Using the Run-Time Object Method
		6.5 Insert Data into the Database Using Stored Procedures
		6.6 Insert Data into the Database Using the LINQ To DataSet Method
		6.7 Chapter Summary
	Homework
		I.  True/False Selections
		II.  Multiple Choices
		III.  Exercises
Chapter 7 Data Updating and Deleting with Visual Basic.NET
	Part I: Data Updating and Deleting with Visual Studio.NET Design Tools and Wizards
		7.1 Update or Delete Data Against Oracle Databases
		7.2 Update and Delete Data For Oracle 18c XE Database
	Part II: Data Updating and Deleting with Runtime Objects
		7.3 The Run Time Objects Method
		7.4 Update and Delete Data for Oracle Database Using the Run Time Objects
		7.5 Update and Delete Data against Oracle Database Using Stored Procedures
		7.6 Chapter Summary
	Homework
		I.  True/False Selections
		II.  Multiple Choices
		III.  Exercises
Chapter 8 Accessing Data in ASP.NET
	8.1 What Is .NET Framework?
	8.2 What Is ASP.NET?
		8.2.1 ASP.NET Web Application File Structure
		8.2.2 ASP.NET Execution Model
		8.2.3 What Is Really Happened When a Web Application Is Executed?
		8.2.4 The Requirements to Test and Run the Web Project
	8.3 Develop ASP.NET Web Application to Select Data from Oracle Databases
		8.3.1 Create the User Interface – LogIn Form
		8.3.2 Develop the Codes to Access and Select Data from the Database
		8.3.3 Validate the Data in the Client Side
		8.3.4 Create the Second User Interface – Selection Page
		8.3.5 Develop the Codes to Open the Other Page
		8.3.6 Modify Codes in the LogIn Page to Transfer to the Selection Page
		8.3.7 Create the Third User Interface – Faculty Page
		8.3.8 Develop the Codes to Select the Desired Faculty Information
		8.3.9 Create the Fourth User Interface – Course Page
		8.3.10 Develop the Codes to Select the Desired Course Information
	8.4 Develop ASP.NET Web Application to Insert Data into Oracle Databases
		8.4.1 Develop the Codes to Perform the Data Insertion Function
		8.4.2 Develop the Codes for the Insert Button Click Event Procedure
		8.4.3 Validate the Data Insertion
	8.5 Develop Web Applications to Update and Delete Data in Oracle Databases
		8.5.1 Develop the Codes for the Update Button Click Event Procedure
		8.5.2 Develop the Codes for the Delete Button Click Event Procedure
	8.6 Develop ASP.NET Web Applications with LINQ to Oracle Query
		8.6.1 Generate a New Web Project LINQWebOracle and a New LinqConnect Model
		8.6.2 Develop the Codes for Our Web Project LINQWebOracle
	8.7 Chapter Summary
	Homework
		I.  True/False Selections
		II.  Multiple Choices
		III.  Exercises
Chapter 9 ASP.NET Web Services
	9.1 What Are Web Services and Their Components?
	9.2 Procedures to Build a Web Service
		9.2.1 The Structure of a Typical Web Service Project
		9.2.2 Some Real Considerations When Building a Web Service Project
		9.2.3 Introduction to Windows Communication Foundation (WCF)
		9.2.4 Procedures to Build an ASP.NET Web Service
		9.2.5 Install WCF Component with Visual Studio Installer
	9.3 Build ASP.NET Web Service Project to Access Oracle Database
		9.3.1 Files and Items Created in the New Web Service Project
		9.3.2 A Feeling of the Hello World Web Service Project as it Runs
		9.3.3 Modify the Default Namespace
		9.3.4 Create a Base Class to Handle Error Checking for Our Web Service
		9.3.5 Create a Customer Returned Class to Hold all Retrieved Data
		9.3.6 Visual Basic System Class and Web Service Class
		9.3.7 Add and Build Web Method GetOracleSelect() to the Web Services
		9.3.8 Develop the Stored Procedure to Perform the Data Query
		9.3.9 Use DataSet as the Returning Object for the Web Method
		9.3.10 Build Windows‐based Web Service Clients to Consume the Web Services
		9.3.11 Build Web‐based Web Service Clients to Consume the Web Service
		9.3.12 Deploy the Completed Web Service to Production Servers
	9.4 Build ASP.NET Web Service Project to Insert Data Into Oracle Databases
		9.4.1 Create a New Web Service Project WebServiceOracleInsert
		9.4.2 Develop Four Web Service Methods
		9.4.3 Build Windows‐based Web Service Clients to Consume the Web Services
		9.4.4 Build Web‐based Web Service Clients to Consume the Web Services
	9.5 Build ASP.NET Web Service to Update and Delete Data for Oracle Database
		9.5.1 Modify the Default Namespace and Add Database Connection String
		9.5.2 Create Our Customer‐Built Base and Returned Classes
		9.5.3 Create a Web Method to Call Stored Procedure to Update Student Records
		9.5.4 Create a Web Method to Call Stored Procedure to Delete Student Records
		9.5.5 Create a Web Method to Collect the Current Student Members
		9.5.6 Develop Two Oracle Stored Procedures with Oracle SQL Developer
	9.6 Build Windows-Based Web Service Clients to Consume the Web Services
		9.6.1 Add a Web Service Reference to Our Client Project
		9.6.2 Modify the Codes in the Form_Load Event Procedure
		9.6.3 Build the Codes to the Update Button’s Click Event Procedure
		9.6.4 Build the Codes to the Delete Button’s Click Event Procedure
	9.7 Build Web-Based Web Service Clients to Consume the Web Services
		9.7.1 Create a New ASP.NET Web Project and Add an Existing Web Page
		9.7.2 Add a Web Service Reference and Modify the Web Form Window
		9.7.3 Develop the Codes for the Page_Load() Event Procedure
		9.7.4 Build the Codes Inside the Back Button’s Click Event Procedure
		9.7.5 Add the Codes to the Update Button’s Click Event Procedure
		9.7.6 Develop Codes for the Delete Button’s Click Event Procedure
		9.7.7 Develop Codes for the Select Button’s Click Event Procedure
	9.8 Chapter Summary
	Homework
		I.  True/False Selections
		II.  Multiple Choices
		III.  Exercises
Appendix A Download and Install Oracle Database XE 18c
	A.1 Download the Oracle Database 18c XE
	A.2 Install the Oracle Database 18c XE
Appendix B Download and Install Oracle SQL Developer
Appendix C Download and Install DevExpress WinForms
Appendix D How to Use the Sample Database
Appendix E How to Export the Sample Database
Appendix F Download and Install dotConnect Express
Appendix G How to Use User-Defined Windows/Web Forms
Appendix H Appendix HDownload and Install FrontPage Server Extension for Windows 10
Appendix I Download and Install LinqConnect Express
Index
EULA