Practical Entity Framework : Database Access for Enterprise Applications / by Brian L. Gorman.

Format:

Book

Author/Creator:

Gorman, Brian L., Author.

Language:

English

Subjects (All):

Microsoft software.

Microsoft .NET Framework.

Database management.

Microsoft and .NET.

Database Management.

Local Subjects:

Microsoft and .NET.

Database Management.

Physical Description:

1 online resource (XXVIII, 649 p. 424 illus.)

Edition:

1st ed. 2020.

Place of Publication:

Berkeley, CA : Apress : Imprint: Apress, 2020.

System Details:

text file

Summary:

Determine your object relational mapper (ORM) of choice for enterprise applications using .NET Framework, and especially .NET Framework Core 3.1 and higher. 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 begins with a simple overview of the two most common approaches to working with databases—database first and code first—and then focuses on working in a code first manner. Taking the code first approach allows the entire database to be built and maintained in code 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. Emphasis throughout the book is on leaving you well positioned to architect and lead data development efforts for your organization. You will: 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.

Contents:

Introduction

Part I. Getting Started

1. Introduction to Entity Framework

2. Working with an Existing Database

3. Entity Framework: Code First

Part II. Building the Data Solution

4. Models and the Data Context

5. Constraints, Keys, and Relationships

6. Data Access (Create, Read, Update, Delete)

7. Stored Procedures, Views, and Functions

8. Sorting, Filtering, and Paging

Part III. Enhancing the Data Solution

9. LINQ for Queries and Projections

10. Encryption of Data

11. Repository and Unit of Work Patterns

12. Unit Testing, Integration Testing, and Mocking

13. Alternatives to Entity Framework: Dapper

14. Asynchronous Data Operations and Multiple Database Contexts

Part IV. Recipes for Success

15. .NET 5 and Entity Framework

16. Appendix A: Troubleshooting.

Notes:

Includes index.

ISBN:

9781484260449

1484260449

OCLC:

1204218077