Mastering Entity Framework Core 2.0

Learn how to leverage the features of the new Entity Framework Core APIs and use them to build pure .NET Core applications.

Key Features

• Learn how to effectively manage your database to make it more productive and maintainable.
• Write simplified queries using LINQ to acquire the desired data easily
• Raise the abstraction level from data to objects so teams can function independently, resulting in easily maintainable code

Book Description

Being able to create and maintain dataoriented 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 rowlevel 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.

What you will learn

• Create databases and perform CRUD operations on them
• Understand and build relationships (related to entities, keys, and properties)
• Understand inbuilt, custom, and remote validation (both client and server side)
• You will learn to handle concurrency to build responsive applications
• You will handle transactions and multitenancy while also improving performance

Who This Book Is For

This book is for .NET Core developers who would like to integrate EF Core in their application. Prior knowledge of .NET Core and C# is assumed.

Table of Contents

1. Kickstart Introduction to Entity Framework Core
2. The Other Way Around - Database First Approach
3. Relationships - Terminology and Conventions
4. Building Relationships - Understanding Mapping
5. Know the Validation - Explore Inbuilt Validations
6. Save Yourself - Hack Proof Your Entities
7. Going Raw - Leveraging SQL Queries in LINQ
8. Query Is All We Need - Query Object Pattern
9. Fail Safe Mechanism - Transactions
10. Make It Real - Handling Concurrencies
11. Performance - It's All About Execution Time
12. Isolation - Building a MultiTenant Database

Prabhakaran Anbazhagan is a Microsoft Solution Architect living in Chennai, India. His passion for programming started while creating a website for his school, and that's where the never-ending journey started. He became the secretary of a technology group in college, creating websites yet again, automating symposiums, and much more.He started his career at a prestigious product-based company; his knowledge was respected and recognized by his seniors, who let him develop tools and automation to sharpen his talents. Lucky guy! People hardly ever get to nurture their talent, but he got a handful of opportunities to sharpen his skills and become a Solution Architect, becoming a jack of all trades but still an expert in .NET.Prabhakaran has more than 12 years of IT experience in architecting, designing, and developing mission-critical desktop, web, and mobile applications. He has experience in full-stack development spanning ASP.NET MVC, Web API, C#, Mobility expert in Swift, Objective-C, Blackberry Cascades, hybrid apps, SharePoint, JavaScript, jQuery, and MEAN.JS.