Entity Framework 4 In Action

Summary Entity Framework 4 in Action is an example-rich tutorial for .NET developers with full coverage of EF 4 features. The book begins with a review of the core ideas behind the ORM model and shows through detailed examples and larger case studies how Entity Framework offers a smooth transition from a traditional ADO.NET approach. About the Technology Entity Framework builds on the ADO.NET persistence model and the language features of LINQ to create a powerful persistence mechanism that bridges the gap between relational databases and object-oriented languages. About the Book Entity Framework 4 in Action is an example-rich tutorial that helps .NET developers learn and master the subject. It begins by explaining object/relational mapping and then shows how you can easily transition to EF from ADO.NET. Through numerous focused examples and two larger case studies, the book unfolds the EF story in a clear, easy-to-follow style. Infrastructure and inner workings of EF are discussed when you need them to understand a particular feature. This book is written for .NET developers. Knowledge of ADO.NET is helpful but not required. Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book. What's Inside Full coverage of EF 4 features Layer separation, Data Layer, and Domain Model Best practices Table of Contents PART 1 REDEFINING YOUR DATA-ACCESS STRATEGY Data access reloaded: Entity Framework Getting started with Entity Framework PART 2 GETTING STARTED WITH ENTITY FRAMEWORK Querying the object model: the basics Querying with LINQ to Entities Domain model mapping Understanding the entity lifecycle Persisting objects into the database Handling concurrency and transactions PART 3 MASTERING ENTITY FRAMEWORK An alternative way of querying: Entity SQL Working with stored procedures Working with functions and views Exploring EDM metadata Customizing code and the designer

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.

Annotation Code first is an additional means of building a model to be used with the Entity Framework and is creating a lot of excitement in the .NET development community. The reader will begin with an overview of what code first is, why it was created, how it fits into the Entity Framework and when to use it over the alternatives.

In addition to Code First, EF 4.1 introduces simpler EF coding patterns with the DbContext, DbSet, ChangeTracker and Validation APIs. This mini-book will take the reader on a tour of these features and how to take advantage of them.

Take a developer journey that paves the way to enterprise-level database access from .NET and C# using the object-relational mapper (ORM) of choice. This second edition is revised to cover Entity Framework Core 5 and 6 (EF) and includes new content on table-per-type mapping, LINQ improvements (filtered includes), many-to-many navigation changes, split queries, simple logging using the DBCommandInterceptor, and other improvements available in EF Core 6. Real-world examples and considerations are presented in this book to help you create robust and efficient database solutions. Throughout the text, actual problems, questions, and common pitfalls are provided to help you recognize optimal solutions for maximum success in the different application scenarios you might encounter. Practical Entity Framework Core 6 focuses on the code first approach to developing a database. Taking the code first approach allows the entire database to be built and maintained in code using EF Core 6 so there is never a situation in which you cannot restore the database schema. Additionally, the code first approach creates an entirely transparent record of changes to the database that is easily tracked in source control systems such as GitHub. Emphasis throughout the book is on leaving you well positioned to architect and lead data development efforts for your organization. What You Will Learn Build robust and maintainable databases using a code first approach Create and execute stored procedures, triggers, and functions Analyze and optimize performance of database queries Ensure data integrity through keys, constraints, and relationships Encrypt your database columns at rest with TDE and Always-On Encryption Leverage the FluentAPI and attributes for entity configuration Who This Book Is For .NET developers who work with enterprise-level applications and need to interact with data structures and data within the back end data store, developers who want to take a code first approach to building database applications to prevent conflicts and optimize efficiency, and those who are moving into full-stack roles, or into senior and architectural roles, and will be responsible for database design and implementation

Entity Framework 4.0 Recipes provides an exhaustive collection of ready-to-use code solutions for Entity Framework, Microsoft’s vision for the future of data access. Entity Framework is a model-centric data access platform with an ocean of new concepts and patterns for developers to learn. With this book, you will learn the core concepts of Entity Framework through a broad range of clear and concise solutions to everyday data access tasks. Armed with this experience, you will be ready to dive deep into Entity Framework, experiment with new approaches, and develop ways to solve even the most difficult data access challenges. If you are a developer who likes to learn by example, then this is the right book for you. Gives ready-to-use, real-world recipes to help you with everyday tasks Provides guideposts for learning core concepts Maps out key landmarks for experimenting with your own solutions