Book Image

Mastering Entity Framework Core 2.0

By : Prabhakaran Anbazhagan
Book Image

Mastering Entity Framework Core 2.0

By: Prabhakaran Anbazhagan

Overview of this book

Being able to create and maintain data-oriented applications has become crucial in modern programming. This is why Microsoft came up with Entity Framework so architects can optimize storage requirements while also writing efficient and maintainable application code. This book is a comprehensive guide that will show how to utilize the power of the Entity Framework to build efficient .NET Core applications. It not only teaches all the fundamentals of Entity Framework Core but also demonstrates how to use it practically so you can implement it in your software development. The book is divided into three modules. The first module focuses on building entities and relationships. Here you will also learn about different mapping techniques, which will help you choose the one best suited to your application design. Once you have understood the fundamentals of the Entity Framework, you will move on to learn about validation and querying in the second module. It will also teach you how to execute raw SQL queries and extend the Entity Framework to leverage Query Objects using the Query Object Pattern. The final module of the book focuses on performance optimization and managing the security of your application. You will learn to implement failsafe mechanisms using concurrency tokens. The book also explores row-level security and multitenant databases in detail. By the end of the book, you will be proficient in implementing Entity Framework on your .NET Core applications.

Related Content you might be interested in

Current Title:

Small book image
Mastering Entity Framework Core 2.0
Prabhakaran Anbazhagan
Dec, 2017 | 386 pages
Small book image
Learning ASP.NET Core 2.0
Michel Bruchet | Jason De Oliveira
Dec, 2017 | 516 pages
Small book image
ASP.NET Core 2 Fundamentals
Onur Gumus | Mugilan T S Ragupathi
Aug, 2018 | 298 pages
Table of Contents (20 chapters)
Title Page
Title Page
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Customer Feedback
Customer Feedback
Dedication
Dedication
Preface
Preface
Free Chapter
1
Kickstart - Introduction to Entity Framework Core
Kickstart - Introduction to Entity Framework Core
Prerequisites
Creating a new project
Installing Entity Framework
Data models
Database context
Registering the context in services (.NET Core DI)
Creating and seeding databases
CRUD operations
Summary
2
The Other Way Around – Database First Approach
The Other Way Around – Database First Approach
Preparing the database
Creating  new project
Reverse engineering the database
Registering context in services (.NET Core DI)
Performing CRUD operations
Summary
3
Relationships – Terminology and Conventions
Relationships – Terminology and Conventions
Understanding relationship terms
Conventions in a relationship
Summary
4
Building Relationships – Understanding Mapping
Building Relationships – Understanding Mapping
Relationships
Fluent API
Summary
5
Know the Validation – Explore Inbuilt Validations
Know the Validation – Explore Inbuilt Validations
Diving into built-in validations
Required field validation
EmailAddress field validation
Compare field validation
Url field validation
MinLength field validation
MaxLength field validation
RegularExpression field validation
Summary
6
Save Yourself – Hack Proof Your Entities
Save Yourself – Hack Proof Your Entities
Client-side validation
Validating data without client-side scripting
Custom validation
Remote validation
Summary
7
Going Raw – Leveraging SQL Queries in LINQ
Going Raw – Leveraging SQL Queries in LINQ
Basic raw SQL queries
Building parameterized queries
Composing with LINQ
Executing SQL query without a DBSet or POCO
Summary
8
Query Is All We Need – Query Object Pattern
Query Is All We Need – Query Object Pattern
Introduction to query objects
Improving repositories with the query object pattern
Composing queries with commands
Enhancing queries with expression trees
Summary
9
Fail Safe Mechanism – Transactions
Fail Safe Mechanism – Transactions
Default behavior of a transaction
Creating a simple transaction
Creating a cross-context transaction
Leveraging transactions between multiple technologies
Summary
10
Make It Real – Handling Concurrencies
Make It Real – Handling Concurrencies
Handling concurrency in EF
Introducing concurrency tokens
Non-timestamp based concurrency tokens
Timestamp-based concurrency tokens
Handling concurrency conflicts
Summary
11
Performance – It's All About Execution Time
Performance – It's All About Execution Time
The AsNoTracking() method
Detecting changes
Asynchronous operations
Unnecessary volume returned
The N+1 Select problem
More data than required
Mismatched data types
Missing indexes
Summary
12
Isolation – Building a Multi-Tenant Database
Isolation – Building a Multi-Tenant Database
Authentication in the blogging system
Row-Level Security
Multi-tenancy
Summary

About the Reviewers

Jason De Oliveira works as a CTO for MEGA International (http://www.mega.com), a software company in Paris (France), providing modeling tools for business transformation, enterprise architecture, and enterprise governance, risk, and compliance management. He is an experienced manager and senior solutions architect, with high skills in software architecture and enterprise architecture.

He loves sharing his knowledge and experience via his blog, speaking at conferences, writing technical books, writing articles in the technical press, giving software courses as MCT, and coaching co-workers in his company. He frequently collaborates with Microsoft and can often be found at the Microsoft Technology Center (MTC) in Paris.

Microsoft has awarded him for more than 6 years with the Microsoft® Most Valuable Professional (MVP C#/.NET) award for his numerous contributions to the Microsoft community. Microsoft seeks to recognize the best and brightest from technology communities around the world with the MVP Award. These exceptional and highly respected individuals come from more than 90 countries, serving their local online and offline communities and having an impact worldwide.

Feel free to contact him via his blog if you need any technical assistance or want to talk about technical subjects (http://www.jasondeoliveira.com).

Jason has worked on the following books:

  • .NET 4.5 Expert Programming Cookbook (English)
  • WCF 4.5 Multi-tier Services Development with LINQ to Entities (English)
  • .NET 4.5 Parallel Extensions Cookbook (English)
  • WCF Multi-layer Services Development with Entity Framework (English)
  • Visual Studio 2013: Concevoir, développer et gérer des projets Web, les gérer avec TFS 2013 (French)

I would like to thank my lovely wife, Orianne, and my beautiful daughters, Julia and Léonie, for supporting me in my work and for accepting long days and short nights during the week, and, sometimes, even during the weekend. My life would not be the same without them!

 

 

 

Alvin Ashcraft is a software developer living near Philadelphia, PA. He has dedicated his 22-year career to building software with C#, Visual Studio, WPF, ASP.NET, HTML/JavaScript, UWP, and Xamarin apps and SQL Server. He has been awarded as a Microsoft MVP nine times; once for Software Architecture, seven times for C# and Visual Studio & Tools, and for Windows Dev in 2018-2019. You can read his daily links for .NET developers on his blog at alvinashcraft.com and UWP App Tips blog at www.uwpapp.tips.

He currently works as a Principal Software Engineer for Allscripts, developing clinical healthcare software. He has previously been employed with several large software companies, including Oracle, Genzeon, and Corporation Service Company. There, he helped create software solutions for financial, business, and healthcare organizations using Microsoft platforms and solutions.

He was a technical reviewer for NuGet 2 Essentials and Mastering ASP.NET Core 2.0 by Packt.

I would like to thank my wonderful wife, Stelene, and our three amazing daughters for their support. They were very understanding while I read and reviewed these chapters on evenings and weekends to help deliver a useful, high-quality book for the ASP.NET Core developers.

Previous Section
Next Chapter