Beginning Entity Framework Core 5

Use the code-driven approach of Entity Framework Core 5 to build a functional web application that accesses a database on the backend server. This book covers the common use cases of Entity Framework that a developer needs to master in order to begin building applications that run against a database. Throughout the book you will be shown how to use Entity Framework Core 5 by implementing a simple ASP.NET Core Razor Pages line-of-business application. This example application will be similar to those you might write yourself and deploy to your users on a web or intranet site via a browser. This book takes a code-first approach in which your database will be created and seeded programmatically. You won’t need to create the database through your database engine’s interface. Instead, you will be shown how to define your data model in Entity Framework, and then let Entity Framework do the work of creating your database and schema for you. From there you will learn how to seed your database with example data, then to implement the common, so-called CRUD operations consisting of creating, retrieving, updating, and deleting rows of data. By the end of the book you will have built a well-designed application that you can use as the basis for future applications that you create in your job. What You Will Learn Download and install Entity Framework Core 5 Perform create, read, update, and delete (CRUD) operations Create and seed a database with example data using Entity Framework Core 5 Incrementally add new database functionality through Entity Framework Core 5 migrations Recognize when to take advantage of new features introduced in Entity Framework Core 5 Deliver line-of-business applications using ASP.NET Core that run in a browser Who This Books Is For Developers who are familiar with C# and the .NET Framework who want to learn database access using Entity Framework Core 5. For developers creating web-based, line-of-business applications who want to create those applications more quickly and efficiently when databases are involved.

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

Summary Entity Framework Core in Action teaches you how to access and update relational data from .NET applications. Following the crystal-clear explanations, real-world examples, and around 100 diagrams, you'll discover time-saving patterns and best practices for security, performance tuning, and unit testing. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the Technology There's a mismatch in the way OO programs and relational databases represent data. Entity Framework is an object-relational mapper (ORM) that bridges this gap, making it radically easier to query and write to databases from a .NET application. EF creates a data model that matches the structure of your OO code so you can query and write to your database using standard LINQ commands. It will even automatically generate the model from your database schema. About the Book Using crystal-clear explanations, real-world examples, and around 100 diagrams, Entity Framework Core in Action teaches you how to access and update relational data from .NET applications. You'l start with a clear breakdown of Entity Framework, long with the mental model behind ORM. Then you'll discover time-saving patterns and best practices for security, performance tuning, and even unit testing. As you go, you'll address common data access challenges and learn how to handle them with Entity Framework. What's Inside Querying a relational database with LINQ Using EF Core in business logic Integrating EF with existing C# applications Applying domain-driven design to EF Core Getting the best performance out of EF Core Covers EF Core 2.0 and 2.1 About the Reader For .NET developers with some awareness of how relational databases work. About the Author Jon P Smith is a full-stack developer with special focus on .NET Core and Azure. Table of Contents Part 1 - Getting started Introduction to Entity FrameworkCore Querying the database Changing the database content Using EF Core in business logic Using EF Core in ASP.NET Core web applications Part 2 - Entity Framework in depth Configuring nonrelational properties Configuring relationships Configuring advanced features and handling concurrency conflicts Going deeper into the DbContext Part 3 - Using Entity Framework Core in real-world applications Useful software patterns for EF Core applications Handling database migrations EF Core performance tuning A worked example of performance tuning Different database types and EF Core services Unit testing EF Core applications Appendix A - A brief introduction to LINQ Appendix B - Early information on EF Core version 2.1

"The most comprehensive reference for EF Core that does—or ever will—exist." - Stephen Byrne, Intel Corporation Entity Framework Core in Action, Second Edition teaches you to write flawless database interactions for .NET applications. Summary Entity Framework Core in Action, Second Edition is an in-depth guide to reading and writing databases with EF Core. Revised from the bestselling original edition, it’s filled with over 100 diagrams, code snippets, and examples—including building and scaling your own bookselling web application. Learn from author Jon Smith’s extensive experience working with EF Core in production, as you discover time-saving patterns and best practices for security, performance tuning, and unit testing. All of the book’s code is available on GitHub. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the technology Entity Framework radically simplifies data access in .NET applications. This easy-to-use object-relational mapper (ORM) lets you write database code in pure C#. It automatically maps classes to database tables and enables queries with standard LINQ commands. It even generates SQL, so you don’t have to! About the book Entity Framework Core in Action, Second Edition teaches you to write flawless database interactions for .NET applications. Following relevant examples from author Jon Smith’s extensive experience, you’ll progress quickly from EF basics to advanced techniques. In addition to the latest EF features, this book addresses performance, security, refactoring, and unit testing. This updated edition also contains new material on NoSQL databases. What's inside Configure EF to define every table and column Update your schema as your app grows Integrating EF with existing C# application Write and test business logic for database access Applying a Domain-Driven Design to EF Core Getting the best performance out of EF Core About the reader For .NET developers familiar with relational databases. About the author Jon P. Smith is a freelance software developer and architect with a special focus on .NET and Azure. Table of Contents PART 1 1 Introduction to Entity Framework Core 2 Querying the database 3 Changing the database content 4 Using EF Core in business logic 5 Using EF Core in ASP.NET Core web applications 6 Tips and techniques for reading and writing with EF Core PART 2 7 Configuring nonrelational properties 8 Configuring relationships 9 Handling database migrations 10 Configuring advanced features and handling concurrency conflicts 11 Going deeper into the DbContext PART 3 12 Using entity events to solve business problems 13 Domain-Driven Design and other architectural approaches 14 EF Core performance tuning 15 Master class on performance-tuning database queries 16 Cosmos DB, CQRS, and other database types 17 Unit testing EF Core applications

Entity Framework Core in Action, Second Edition teaches you to write flawless database interactions for .NET applications. Following relevant examples from author Jon Smith's extensive experience, you'll progress quickly from EF basics to advanced techniques. In addition to the latest EF features, this book addresses performance, security, refactoring, and unit testing. This updated edition also contains new material on NoSQL databases.

Learn how to build web applications efficiently using ASP.NET Core 5 with the C# programming language and related frameworks Key FeaturesBuild web apps and services and cross-platform applications using .NET and C#Understand different web programming concepts with the help of real-world examplesExplore the new features and APIs in ASP.NET Core 5, EF Core, Visual Studio, and BlazorBook Description ASP.NET Core 5 for Beginners is a comprehensive introduction for those who are new to the framework. This condensed guide takes a practical and engaging approach to cover everything that you need to know to start using ASP.NET Core for building cloud-ready, modern web applications. The book starts with a brief introduction to the ASP.NET Core framework and highlights the new features in its latest release, ASP.NET Core 5. It then covers the improvements in cross-platform support, the view engines that will help you to understand web development, and the new frontend technologies available with Blazor for building interactive web UIs. As you advance, you’ll learn the fundamentals of the different frameworks and capabilities that ship with ASP.NET Core. You'll also get to grips with securing web apps with identity implementation, unit testing, and the latest in containers and cloud-native to deploy them to AWS and Microsoft Azure. Throughout the book, you’ll find clear and concise code samples that illustrate each concept along with the strategies and techniques that will help to develop scalable and robust web apps. By the end of this book, you’ll have learned how to leverage ASP.NET Core 5 to build and deploy dynamic websites and services in a variety of real-world scenarios. What you will learnExplore the new features and APIs introduced in ASP.NET Core 5 and BlazorPut basic ASP.NET Core 5 concepts into practice with the help of clear and simple samplesWork with Entity Framework Core and its different workflows to implement your application’s data accessDiscover the different web frameworks that ASP.NET Core 5 offers for building web appsGet to grips with the basics of building RESTful web APIs to work with real dataDeploy your web apps in AWS, Azure, and Docker containersWork with SignalR to add real-time notifications to your appWho this book is for This book is for developers who want to learn how to develop web-based applications using the ASP.NET Core framework. Familiarity with the C# language and a basic understanding of HTML and CSS is required to get the most out of this book.

Model, map, and access data effectively with Entity Framework Core 2, the latest evolution of Microsoft’s object-relational mapping framework. You will access data utilizing .NET objects via the most common data access layer used in ASP.NET Core MVC 2 projects. Best-selling author Adam Freeman explains how to get the most from Entity Framework Core 2 in MVC projects. He begins by describing the different ways that Entity Framework Core 2 can model data and the different types of databases that can be used. He then shows you how to use Entity Framework Core 2 in your own MVC projects, starting from the nuts and bolts and building up to the most advanced and sophisticated features, going in-depth to give you the knowledge you need. Chapters include common problems and how to avoid them. What You’ll Learn Gain a solid architectural understanding of Entity Framework Core 2 Create databases using your MVC data model Create MVC models using an existing database Access data in an MVC application using Entity Framework Core 2 Use Entity Framework in RESTful Web Services Who This Book Is For ASP.NET Core MVC 2 developers who want to use Entity Framework Core 2 as the data access layer in their projects

A practical handbook to understand what Entity Framework Core 5 is capable of. From the history of Entity Framework, through migrations, working with DbContext, creating and using relationships, to writing unit tests. This book will get you through the study process focusing on learning all the important things to use in a real project. Along with this book, you'll get a demonstration project hosted on GitHub, where you can find all the examples from the book. This gives you the possibility to instantly jump from the book to the project and test all the technical innovations learned.Also to boost your learning speed, I prepared a list of assignments to do after every technical chapter.