Mastering Entity Framework

Mastering Entity Framework

By : Rahul Rajat Singh

Buy this Book

Mastering Entity Framework

By: Rahul Rajat Singh

Buy this Book

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

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

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

Summary

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

Summary

Entity Framework DB First – Performing Model Validations

Model validations using Entity Framework

Model validations using data annotations

Summary

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

Summary

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

Summary

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

Summary

Entity Framework Code First – Managing Database Creation and Seeding Data

Managing database connections

Managing database initialization

Seeding data

Summary

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

Summary

Querying the Object Model – Entity SQL

Understanding Entity SQL

Understanding EntityConnection

Using Entity SQL with EntityCommand

Summary

Managing Concurrency Using Entity Framework

Understanding concurrency

Implementing optimistic concurrency using Entity Framework

Entity Framework and pessimistic concurrency

Summary

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

Summary

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

Summary

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Choosing persistence approaches

Now, we saw the three options to create the EDM and the DbContext class. Which approach should be used in which scenario, is often a question that many developers ask. There is no definite reason for choosing any particular approach, but here is a small checklist that the developers might find very useful while deciding on which approach to choose. If at any point, the answer to any question is yes, then that approach should be used without even looking at the next question in the checklist:

Question	Approach
Is there a legacy database or does the database already exist?	Database First
Will we be getting a database created by the DBAs before starting the development?	Database First
Will there be frequent database changes, based on which our application should change?	Database First
Do we want to use the Visual Entity Designer to generate the database and model classes?	Model First
Do we have the model classes already and we need the database to save the data only?	Code First
Do we want to write all the model classes, implement them, and then think about the database storage later?	Code First
We don't want to deal with the auto-generated classes and would prefer to write them ourselves	Code First
Is the answer to all the preceding questions "no"?	Database First

Mastering Entity Framework

By : Rahul Rajat Singh

Mastering Entity Framework

By: Rahul Rajat Singh

Overview of this book

Related Content you might be interested in

Current Title:

Mastering Entity Framework

Choosing persistence approaches