Beginning Entity Framework Core 2.0 (eBook)

Database Access from .NET

Derek J. Rouleau (Autor)

eBook Download: PDF

2018 | 1st ed.
XVII, 338 Seiten
Apress (Verlag)
978-1-4842-3375-7 (ISBN)

Infos

Use the valuable Entity Framework Core 2.0 tool in ASP.NET and the .NET Framework to eliminate the tedium around accessing databases and the data they contain.

Entity Framework Core 2.0 greatly simplifies access to relational databases such as SQL Server that are commonly deployed in corporate settings. By eliminating tedious data access code that developers are otherwise forced to use, Entity Framework Core 2.0 enables you to work directly with the data in a database through domain-specific objects and methods. 

Beginning Entity Framework Core 2.0 is a carefully designed tutorial. Throughout the book you will encounter examples that you can use in your day-to-day coding, and you will build a solid foundation on which to create database-backed applications. If you are looking for a way to get started without getting buried under details you are only going to forget, then this is the book for you. 

The author aims to leave you comfortably able to connect to, access, modify, and delete data from a relational database. The book provides a clear, straightforward approach and includes code that you can look back at months later and understand. 

What You'll Learn

• Study easy-to-follow, real-world examples you can use every day
  
• Focus on DbContext and the Database First approach
  
• Understand how to work with single and multiple tables
  
• Use the LINQ query language to manipulate data

Who This Book Is For

C# and ASP.NET programmers looking for an easier way of accessing data in a relational database than writing in SQL-a way that meshes better into object-oriented application development

​Derek J. Rouleau is a Computer and Information Systems Manager for a small company in the greater Portland, Maine area. He has been working with computers since the mid 1990's thanks to a friend's father who got him interested in hardware and the workings of the operating system. Derek started professionally programming while working for an educational publishing and software company in the Quality Assurance department. He has been using Visual Basic since VB 6 was out, and C# since 2010. Although he now manages the department where he works, Derek still makes time each week to write code and research new and exciting technologies. When not working, he is involved with Off Track Standardbreds, and he competes in Dressage. 

Inhalt

Table of Contents 5
About the Author 9
About the Technical Reviewer 10
Acknowledgments 11
Introduction 12
Chapter 1: Getting Started 15
What Is .NET Core 15
Setting Up Your Application 16
Creating the Database and Tables (Entities) 17
Creating the Database 33
Adding Data to a Table 35
Retrieving Data from a Database and Displaying It 45
Deleting Data from a Database 47
Deleting a Single Record 47
Deleting Multiple Records 54
Updating Data in a Table 56
Summary 59
Chapter 2: Working with  Multiple Tables 63
Adding Data to a Table That Has Foreign Keys 64
Retrieving Data from Multiple Tables 89
Updating Tables 95
Updating Multiple Records 105
Summary 109
Chapter 3: Stepping Beyond the Basics 110
Specifying Fields 111
Joins 114
Left Outer Join 115
Right Outer Join 117
Cross Join 122
Inner Join: Method Syntax 123
Grouping 125
Query Syntax 125
Method Syntax 127
Logical Operators 128
Logical OR 132
Paging and Filtering Results 134
Concurrency 138
Summary 143
Chapter 4: Data Validation and POCOs 145
Validation Using DataAnnotations 146
Using Recursion 155
POCOs 165
Helper Classes 168
Expression-Bodied Members 174
Validating Using a Class 180
LINQ Using .Any to Check for Existing Records 182
Adding a Class to a Class File 184
Summary 189
Chapter 5: Stored Procedures, Table Design, and Modifications 191
Stored Procedures 191
Calling a Stored Procedure with One Parameter 197
Using Parameter Names 199
SQL Injection 200
Inserting Into Multiple Tables 201
Multiple Properties 203
Table and Entity Design 204
Making Changes to the Table 206
Summary 213
Chapter 6: ASP.NET MVC and  EF Core 2.0 214
Setting Up the Application 215
Database-First Development 218
Creating Controllers and Views 220
Formatting Output 224
Page Navigation 225
The Home Page and Adding an Image 227
Error Handling 229
Creating a New View to Display an Error 231
Avoiding Errors 233
Displaying Events by Location 235
Sorting Results 239
ASP.NET MVC Basics 241
Strongly Typed Views 243
Passing Data to a View Using ViewBag 243
Why Use MVC? 245
Summary 246
Chapter 7: Finishing Our ASP.NET MVC .NET Core 2.0 Project 247
Data Validation 247
Using a Regular Expression to Validate a Property 251
Validating the Rest of Our Models 253
Setting Minimum and Maximum Values for a Property 258
Adding Column Sorting to Results 262
Adding Search Capabilities 266
Adding Pagination: Version 1 272
Adding Paging: Version 2 280
Grouping Results 285
Summary 297
Chapter 8: Wrap Up and Where to Go Next 298
Not Just C# Anymore 298
Cross Platform 304
Unit Testing 306
More on LINQ 321
SQL Server Profiler 324
Change Tracking 325
Summary 330
Appendix A: Database Script for Chapter 6 331
Database Diagrams 337
Index 340

Produkt-Details

• Erscheint lt. Verlag: 2.3.2018
• Zusatzinfo: XVII, 338 p. 127 illus.
• Verlagsort: Berkeley
• Sprache: englisch
• Themenwelt: Informatik ► Programmiersprachen / -werkzeuge ► NET Programmierung
• Themenwelt: Mathematik / Informatik ► Informatik ► Software Entwicklung
• Schlagworte: ASP.NET • C# • Code First • Core 2.0 • Database • Entity Framework • .NET Framework • SQL Server
• ISBN-10: 1-4842-3375-1 / 1484233751
• ISBN-13: 978-1-4842-3375-7 / 9781484233757