Skip to main content
SpringerLink
Log in
Apress

Practical Entity Framework

Database Access for Enterprise Applications

  • Book
  • © 2020

Overview

Authors:
  1. Brian L. Gorman

    1. Jesup, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Gives you a solid understanding of critical entity framework components and operations
  • Provides examples of best practices for scalable and maintainable applications
  • Teaches you how to optimize efficiency to provide better overall user experiences

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 29.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (15 chapters)

  1. Front Matter

    Pages i-xxviii
    Download chapter PDF

  2. Getting Started

    1. Front Matter

      Pages 1-1
      Download chapter PDF

    2. Introduction to Entity Framework

      • Brian L. Gorman
      Pages 3-23

    3. Working with an Existing Database

      • Brian L. Gorman
      Pages 25-76

    4. Entity Framework: Code First

      • Brian L. Gorman
      Pages 77-146

  3. Building the Data Solution

    1. Front Matter

      Pages 147-147
      Download chapter PDF

    2. Models and the Data Context

      • Brian L. Gorman
      Pages 149-188

    3. Constraints, Keys, and Relationships

      • Brian L. Gorman
      Pages 189-243

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

      • Brian L. Gorman
      Pages 245-269

    5. Stored Procedures, Views, and Functions

      • Brian L. Gorman
      Pages 271-325

    6. Sorting, Filtering, and Paging

      • Brian L. Gorman
      Pages 327-351

    7. LINQ for Queries and Projections

      • Brian L. Gorman
      Pages 353-398

    8. Encryption of Data

      • Brian L. Gorman
      Pages 399-448

  4. Enhancing the Data Solution

    1. Front Matter

      Pages 449-449
      Download chapter PDF

    2. Repository and Unit of Work Patterns

      • Brian L. Gorman
      Pages 451-500

    3. Unit Testing, Integration Testing, and Mocking

      • Brian L. Gorman
      Pages 501-538

    4. Alternatives to Entity Framework: Dapper

      • Brian L. Gorman
      Pages 539-571

  5. Recipes for Success

    1. Front Matter

      Pages 573-573
      Download chapter PDF

    2. Asynchronous Data Operations and Multiple Database Contexts

      • Brian L. Gorman
      Pages 575-623

    3. .Net 5 and Entity Framework

      • Brian L. Gorman
      Pages 625-631
Back to top

Keywords

About this book

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 thedatabase 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.




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



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 architecturalroles, and will be responsible for database design and implementation

Authors and Affiliations

  • Jesup, USA

    Brian L. Gorman

About the author

Brian Gorman is a developer, computer science instructor, and trainer, and has been working in .NET technologies as long as they have existed. He was originally MCSD certified in .NET 1 and has recently re-certified with MCSA: Web Apps and MCSD: App Builder certifications. Additionally, he became an MCT as of April 2019, and is focusing in on developing and training developers with full-stack web solutions with .NET Core and Azure. In addition to working with .NET technologies, Brian also teaches computer science for Franklin University, where his courses taught have included data structures, algorithms, design patterns, and, more recently, full-stack solutions in the capstone practicum course.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation