Mastering Entity Framework

Book Image

Mastering Entity Framework

By : Rahul Rajat Singh

Book Image

Mastering Entity Framework

By: Rahul Rajat Singh

Overview of this book

<p>Data access is an integral part of any software application. Entity Framework provides a model-based system that makes data access effortless for developers by freeing you from writing similar data access code for all of your domain models.</p> <p>Mastering Entity Framework provides you with a range of options when developing a data-oriented application. You’ll get started by managing the database relationships as Entity relationships and perform domain modeling using Entity Framework. You will then explore how you can reuse data access layer code such as stored procedures and table-valued functions, and perform various typical activities such as validations and error handling. You’ll learn how to retrieve data by querying the Entity Data Model and understand how to use LINQ to Entities and Entity SQL to query the Entity Data Model.</p>

Mastering Entity Framework

Mastering Entity Framework

Credits

About the Author

About the Author

About the Reviewers

About the Reviewers

www.PacktPub.com

www.PacktPub.com

Preface

Free Chapter

Introduction to Entity Framework

Introduction to Entity Framework

Entity Framework modeling and persistence

Development styles and different Entity Framework approaches

Comparing the development styles

Entity Framework Database First approach

Entity Framework Model First approach

Entity Framework Code First approach

Performing CRUD operations using Entity Framework

Choosing persistence approaches

Entity Framework DB First – Managing Entity Relationships

Entity Framework DB First – Managing Entity Relationships

Understanding database relationships

Creating the Entity model

Modeling a one-to-many relationship

Modeling a one-to-one relationship using Entity Framework

Modeling a many-to-many relationship using Entity Framework

Using navigation properties for data access

Entity Framework – behind the scenes

Entity Framework DB First – Performing Model Validations

Entity Framework DB First – Performing Model Validations

Model validations using Entity Framework

Model validations using data annotations

Entity Framework DB First – Inheritance Relationships between Entities

Entity Framework DB First – Inheritance Relationships between Entities

Domain modeling using inheritance in Entity Framework

The Table per Type inheritance

The Table per Class Hierarchy inheritance

The Table per Concrete Class inheritance

Choosing the inheritance strategy

Entity Framework DB First – Using Views, Stored Procedures, and Functions

Entity Framework DB First – Using Views, Stored Procedures, and Functions

Using views, procedures, and functions

Using Entity Framework with views

Using Entity Framework with stored procedures

Using Entity Framework with functions

Entity Framework Code First – Domain Modeling and Managing Entity Relationships

Entity Framework Code First – Domain Modeling and Managing Entity Relationships

Understanding the Entity Framework Code First approach

Understanding the Code First conventions and configurations

Implementing Entity Framework Code First

Managing Entity relationships using the Code First approach

Inheritance with the Entity Framework Code First approach

Entity Framework Code First – Managing Database Creation and Seeding Data

Entity Framework Code First – Managing Database Creation and Seeding Data

Managing database connections

Managing database initialization

Querying the Entity Data Model – LINQ to Entities

Querying the Entity Data Model – LINQ to Entities

Understanding LINQ to Entities

Querying data using LINQ to Entities

Using LINQ to Entities – an example-based approach

Lazy loading and eager loading

Querying the Object Model – Entity SQL

Querying the Object Model – Entity SQL

Understanding Entity SQL

Understanding EntityConnection

Using Entity SQL with EntityCommand

Managing Concurrency Using Entity Framework

Managing Concurrency Using Entity Framework

Understanding concurrency

Implementing optimistic concurrency using Entity Framework

Entity Framework and pessimistic concurrency

Managing Transactions Using Entity Framework

Managing Transactions Using Entity Framework

Understanding transactions

Setting up the test environment

Entity Framework's default transaction handling

Managing transactions using Entity Framework 6

Choosing the appropriate transaction management

Implementing a Small Blogging Platform Using Entity Framework

Implementing a Small Blogging Platform Using Entity Framework

Understanding the application requirements

Visualizing our database design

Creating the Entity Data Model

Performing data access

Using other Entity Framework approaches

Index

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Choosing the appropriate transaction management

Now that we know the various ways to handle transactions using Entity Framework, let's try to see which technique should be used in which scenarios:

If we have only one DbContext class, then we should try to use the default transaction management of Entity Framework. We should always try to implement our application in such a way that all the operations constituting a single unit of work get executed within the scope of the same DbContext object, and the SaveChanges() method will take care of committing the transaction.
If we use multiple DbContext objects, then perhaps putting the calls within the scope of a TransactionScope object is the best way to manage the transactions.
If we want to execute raw SQL queries and associate these operations with the transactions, then we should use the Entity Framework provided Database.BeginTransaction() method that is available on the DbContext object. This approach, however, will only work with Entity Framework...