TIENE EN SU CESTA DE LA COMPRA
en total 0,00 €
Librería Portfolio
A guide to the practical issues and applications in database programming with updated Visual Basic.NET
SQL Server Database Programming with Visual Basic.NET offers a guide to the fundamental knowledge and practical techniques for the design and creation of professional database programs that can be used for real-world commercial and industrial applications. The author-a noted expert on the topic-uses the most current version of Visual Basic.NET, Visual Basic.NET 2017 with Visual Studio.NET 2017. In addition, he introduces the updated SQL Server database and Microsoft SQL Server 2017 Express. All sample program projects can be run in the most updated version, Visual Basic.NET 2019 with Visual Studio.NET 2019.
Written in an accessible, down-to-earth style, the author explains how to build a sample database using the SQL Server management system and Microsoft SQL Server Management Studio 2018. The latest version of ASP.NET, ASP.NET 4.7, is also discussed to provide the most up-to-date Web database programming technologies. This important book:
Offers illustrative practical examples and detailed descriptions to aid in comprehension of the material presented
Includes both fundamental and advanced database programming techniques
Integrates images into associated database tables using a DevExpress UI tools -WindowsUI
Written for graduate and senior undergraduate students studying database implementations and programming courses, SQL Server Database Programming with Visual Basic.NET shows how to develop professional and practical database programs in Visual Basic.NET 2017/Visual Basic.NET 2019.
Table of contents
About the Author xix
Preface xxi
Acknowledgment xxiii
About the Companion Website xxiv
Chapter 1 Introduction 1
1.1 Outstanding Features About This Book 2
1.2 This Book is For 2
1.3 What This Book Covers 2
1.4 How This Book is Organized and How to Use This Book 5
1.5 How to Use Source Codes and Sample Database 6
1.6 Instructors and Customers Supports 8
Chapter 2 Introduction to Databases 9
Ying Bai and Satish Bhalla
2.1 What are Databases and Database Programs? 10
2.1.1 File Processing System 10
2.1.2 Integrated Databases 11
2.2 Develop a Database 12
2.3 Sample Database 13
2.3.1 Relational Data Model 13
2.3.2 Entity-Relationship Model (ER) 17
2.4 Identifying Keys 18
2.5 Define Relationships 18
2.6 ER Notation 22
2.7 Data Normalization 23
2.7.1 First Normal Form (1NF) 23
2.7.2 Second Normal Form (2NF) 24
2.7.3 Third Normal Form (3NF) 26
2.8 Database Components in Some Popular Databases 28
2.8.1 Microsoft Access Databases 28
2.8.2 SQL Server Databases 29
2.8.3 Oracle Databases 32
2.9 Create Microsoft SQL Server 2017 Express Sample Database 35
2.9.1 Create the LogIn Table 36
2.9.2 Create the Faculty Table 37
2.9.3 Create Other Tables 39
2.9.4 Create Relationships Among Tables 45
2.9.4.1 Create Relationship Between the LogIn and the Faculty Tables 46
2.9.4.2 Create Relationship Between the LogIn and the Student Tables 49
2.9.4.3 Create Relationship Between the Faculty and the Course Tables 50
2.9.4.4 Create Relationship Between the Student and the StudentCourse Tables 50
2.9.4.5 Create Relationship Between the Course and the StudentCourse Tables 51
2.9.5 Store Images to the SQL Server 2017 Express Database 53
2.10 Chapter Summary 61
Homework 63
Chapter 3 Introduction to ADO.NET 67
3.1 The ADO and ADO.NET 67
3.2 Overview of the ADO.NET 69
3.3 The Architecture of the ADO.NET 70
3.4 The Components of ADO.NET 71
3.4.1 The Data Provider 72
3.4.1.1 The ODBC Data Provider 73
3.4.1.2 The OLEDB Data Provider 73
3.4.1.3 The SQL Server Data Provider 74
3.4.1.4 The Oracle Data Provider 74
3.4.2 The Connection Class 74
3.4.2.1 The Open() Method of the Connection Class 77
3.4.2.2 The Close() Method of the Connection Class 77
3.4.2.3 The Dispose() Method of the Connection Class 78
3.4.3 The Command and the Parameter Classes 78
3.4.3.1 The Properties of the Command Class 79
3.4.3.2 The Constructors and Properties of the Parameter Class 79
3.4.3.3 Parameter Mapping 80
3.4.3.4 The Methods of the ParameterCollection Class 82
3.4.3.5 The Constructor of the Command Class 83
3.4.3.6 The Methods of the Command Class 84
3.4.4 The DataAdapter Class 87
3.4.4.1 The Constructor of the DataAdapter Class 87
3.4.4.2 The Properties of the DataAdapter Class 87
3.4.4.3 The Methods of the DataAdapter Class 88
3.4.4.4 The Events of the DataAdapter Class 88
3.4.5 The DataReader Class 90
3.4.6 The DataSet Component 92
3.4.6.1 The DataSet Constructor 94
3.4.6.2 The DataSet Properties 94
3.4.6.3 The DataSet Methods 94
3.4.6.4 The DataSet Events 94
3.4.7 The DataTable Component 97
3.4.7.1 The DataTable Constructor 98
3.4.7.2 The DataTable Properties 98
3.4.7.3 The DataTable Methods 99
3.4.7.4 The DataTable Events 100
3.4.8 ADO.NET Entity Framework 102
3.4.8.1 Advantages of Using the Entity Framework 6 104
3.4.8.2 The ADO.NET 4.3 Entity Data Model 106
3.4.8.3 Using Entity Framework 6 Entity Data Model Wizard 110
3.5 Chapter Summary 118
Homework 120
Chapter 4 Introduction to Language Integrated Query (LINQ) 123
4.1 Overview of Language Integrated Query 123
4.1.1 Some Special Interfaces Used in LINQ 124
4.1.1.1 The IEnumerable and IEnumerable(Of T) Interfaces 124
4.1.1.2 The IQueryable and IQueryable(Of T) Interfaces 125
4.1.2 Standard Query Operators 126
4.1.3 Deferred Standard Query Operators 127
4.1.4 Non-Deferred Standard Query Operators 131
4.2 Introduction to LINQ Query 135
4.3 The Architecture and Components of LINQ 137
4.3.1 Overview of LINQ to Objects 138
4.3.2 Overview of LINQ to DataSet 139
4.3.3 Overview of LINQ to SQL 139
4.3.4 Overview of LINQ to Entities 140
4.3.5 Overview of LINQ to XML 140
4.4 LINQ to Objects 141
4.4.1 LINQ and ArrayList 142
4.4.2 LINQ and Strings 143
4.4.2.1 Query a String to Determine the Number of Numeric Digits 144
4.4.2.2 Sort Lines of Structured Text By any Field in the Line 145
4.4.3 LINQ and File Directories 147
4.4.3.1 Query the Contents of Files in a Folder 148
4.4.4 LINQ and Reflection 150
4.5 LINQ to DataSet 152
4.5.1 Operations to DataSet Objects 152
4.5.1.1 Query Expression Syntax 153
4.5.1.2 Method-Based Query Syntax 154
4.5.1.3 Query the Single Table 157
4.5.1.4 Query the Cross Tables 159
4.5.1.5 Query Typed DataSet 162
4.5.2 Operations to DataRow Objects Using the Extension Methods 165
4.5.3 Operations to DataTable Objects 169
4.6 LINQ to SQL 170
4.6.1 LINQ to SQL Entity Classes and DataContext Class 171
4.6.1.1 Add LINQ to Data Reference 171
4.6.1.2 Add LINQ To SQL Tools 171
4.6.2 LINQ to SQL Database Operations 175
4.6.2.1 Data Selection Query 175
4.6.2.2