Mastering Entity Framework

Effortlessly produce data-driven applications for .NET to address the competing demands of data storage and data modeling with Entity Framework
Preview in Mapt

Mastering Entity Framework

Rahul Rajat Singh

1 customer reviews
Effortlessly produce data-driven applications for .NET to address the competing demands of data storage and data modeling with Entity Framework
Mapt Subscription
FREE
$29.99/m after trial
eBook
$21.00
RRP $29.99
Save 29%
Print + eBook
$49.99
RRP $49.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$21.00
$49.99
$29.99p/m after trial
RRP $29.99
RRP $49.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Mastering Entity Framework Book Cover
Mastering Entity Framework
$ 29.99
$ 21.00
Mastering Entity Framework Core - Advanced Querying, Migrations and Testing [Video] Book Cover
Mastering Entity Framework Core - Advanced Querying, Migrations and Testing [Video]
$ 124.99
$ 106.25
Buy 2 for $35.00
Save $119.98
Add to Cart
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 

Book Details

ISBN 139781784391003
Paperback304 pages

Book Description

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.

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.

Table of Contents

Chapter 1: 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
Chapter 2: 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
Chapter 3: Entity Framework DB First – Performing Model Validations
Model validations using Entity Framework
Model validations using data annotations
Summary
Chapter 4: 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
Chapter 5: 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
Chapter 6: 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
Chapter 7: Entity Framework Code First – Managing Database Creation and Seeding Data
Managing database connections
Managing database initialization
Seeding data
Summary
Chapter 8: 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
Chapter 9: Querying the Object Model – Entity SQL
Understanding Entity SQL
Understanding EntityConnection
Using Entity SQL with EntityCommand
Summary
Chapter 10: Managing Concurrency Using Entity Framework
Understanding concurrency
Implementing optimistic concurrency using Entity Framework
Entity Framework and pessimistic concurrency
Summary
Chapter 11: 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
Chapter 12: 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

What You Will Learn

  • Find out the benefits of using Entity Framework over plain ADO.NET
  • Discover various approaches of using Entity Framework such as Database First, Model First, and Code First, and also learn how to choose the best approach for a given scenario
  • Explore how to manage Entity relationships, implement Entity inheritance, and perform model validations
  • Understand how to use stored procedures and functions using Entity Framework
  • Familiarize yourself with domain modeling using Entity Framework
  • Become proficient in managing database creation and seeding dummy data in a database
  • Understand LINQ to Entities and Entity SQL to query data using Entity Framework
  • Manage concurrency and transactions using Entity Framework

Authors

Table of Contents

Chapter 1: 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
Chapter 2: 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
Chapter 3: Entity Framework DB First – Performing Model Validations
Model validations using Entity Framework
Model validations using data annotations
Summary
Chapter 4: 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
Chapter 5: 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
Chapter 6: 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
Chapter 7: Entity Framework Code First – Managing Database Creation and Seeding Data
Managing database connections
Managing database initialization
Seeding data
Summary
Chapter 8: 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
Chapter 9: Querying the Object Model – Entity SQL
Understanding Entity SQL
Understanding EntityConnection
Using Entity SQL with EntityCommand
Summary
Chapter 10: Managing Concurrency Using Entity Framework
Understanding concurrency
Implementing optimistic concurrency using Entity Framework
Entity Framework and pessimistic concurrency
Summary
Chapter 11: 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
Chapter 12: 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

Book Details

ISBN 139781784391003
Paperback304 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

C# 6 and .NET Core 1.0: Modern Cross-Platform Development Book Cover
C# 6 and .NET Core 1.0: Modern Cross-Platform Development
$ 39.99
$ 28.00
WCF Multi-layer Services Development with Entity Framework - Fourth Edition Book Cover
WCF Multi-layer Services Development with Entity Framework - Fourth Edition
$ 32.99
$ 23.10
Microsoft .NET Framework 4.5 Quickstart Cookbook Book Cover
Microsoft .NET Framework 4.5 Quickstart Cookbook
$ 23.99
$ 16.80
Windows Presentation Foundation 4.5 Cookbook Book Cover
Windows Presentation Foundation 4.5 Cookbook
$ 35.99
$ 25.20
Mastering Web Application Development with AngularJS Book Cover
Mastering Web Application Development with AngularJS
$ 26.99
$ 5.40
ASP.NET Web API: Build RESTful web applications and services on the .NET framework Book Cover
ASP.NET Web API: Build RESTful web applications and services on the .NET framework
$ 29.99
$ 21.00