Oracle Database Programming with Visual Basic.NET
Concepts, Designs, and Implementations
Ying Bai
- English
- ePUB (mobile friendly)
- Available on iOS & Android
Oracle Database Programming with Visual Basic.NET
Concepts, Designs, and Implementations
Ying Bai
About This Book
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.
Frequently asked questions
Information
1
Introduction
1.1 Outstanding Features About This Book
- All programming projects can be run in Microsoft Visual Studio.NET 2019 with Oracle XE 18c databases.
- 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.
- 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.
- 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.
- Covered both fundamental and advanced database programming techniques to convenience both beginning students and experienced programmers.
- 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.
- Good textbook for college students, good reference book for programmers, software engineers, and academic researchers.
1.2 Who This Book Is For
1.3 What This Book Covered
- 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:
- Using TableAdapter's DBDirect methods TableAdapter.Insert() method.
- Using the TableAdapter's Update() method to insert new records that have already been added into the DataTable in the DataSet.
- Using the Command object's ExecuteNonQuery() method.
This chapter is also divi...