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>

Related Content you might be interested in

Current Title:

Small book image
Mastering Entity Framework
Rahul Rajat Singh
Feb, 2015 | 304 pages
No titles found
Table of Contents (19 chapters)
Mastering Entity Framework
Mastering Entity Framework
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
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
Summary
2
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
Summary
3
Entity Framework DB First – Performing Model Validations
Entity Framework DB First – Performing Model Validations
Model validations using Entity Framework
Model validations using data annotations
Summary
4
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
Summary
5
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
Summary
6
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
Summary
7
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
Seeding data
Summary
8
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
Summary
9
Querying the Object Model – Entity SQL
Querying the Object Model – Entity SQL
Understanding Entity SQL
Understanding EntityConnection
Using Entity SQL with EntityCommand
Summary
10
Managing Concurrency Using Entity Framework
Managing Concurrency Using Entity Framework
Understanding concurrency
Implementing optimistic concurrency using Entity Framework
Entity Framework and pessimistic concurrency
Summary
11
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
Summary
12
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
Summary
Index
Index

About the Reviewers

Abhishek Luv has been developing and designing websites and web applications for the last 2 years. During these years, Abhishek has been involved in technologies such as C#, ASP.NET, ASP.NET MVC, Visual Studio, and Entity Framework, and now he is mostly working on Microsoft stack.

He is currently working to become an Orchard CMS expert; that aside, he is presently a software engineer at Develop2Deploy (http://www.develop2deploy.com/).

He is a founder of the Orchard CMS India Community website (http://www.orchardproject.net.in/) and a contributor to the official Orchard CMS documentation website and has created numerous online courses on Orchard CMS.

Outside of the normal day-to-day activities, he is also a cofounder of a video training start-up (http://www.thevideotrainer.in/). You can reach him at .

Jason De Oliveira works as the CTO for Cellenza (http://www.cellenza.com), an IT consulting company specializing in Microsoft technologies and Agile methodology in Paris, France. He is an experienced manager and senior solutions architect, with advanced skills in software architecture and enterprise architecture.

Jason works for big companies and helps them to realize complex and challenging software projects. He frequently collaborates with Microsoft, and you can find him quite often at the Microsoft Technology Center (MTC) in Paris.

He loves sharing his knowledge and experience via his blog, by speaking at conferences, writing technical books, writing articles in the technical press, giving software courses as an MTC, and coaching coworkers in his company.

Microsoft awarded him with the Microsoft Most Valuable Professional (MVP C#) Award in 2011 for his numerous contributions to the Microsoft community. Microsoft seeks to recognize the best and brightest from technology communities around the world with the MVP Award. These exceptional and highly respected individuals come from more than 90 countries, serving their local online and offline communities and have an impact worldwide. Jason is very proud to be one of them.

Please feel free to contact him via his blog if you need any technical assistance or want to exchange information on technical subjects (http://www.jasondeoliveira.com).

Jason has worked on the following books:

  • .NET Framework 4.5 Expert Programming Cookbook (English), Packt Publishing

  • WCF 4.5 Multi-Layer Services Development with LINQ to Entities (English), Packt Publishing

  • .NET 4.5 Parallel Extensions Cookbook (English), Packt Publishing

  • WCF Multi-layer Services Development with Entity Framework (English), Packt Publishing

  • Visual Studio 2013: Concevoir, développer et gérer des projets Web, les gérer avec TFS 2013 (French), ENI

I would like to thank my lovely wife, Orianne, and my beautiful daughters, Julia and Léonie, for supporting me in my work and accepting long days and short nights during the weeks and sometimes even during the weekends. My life would not be the same without them!

Zsolt Soczo received his MSc degree in electrical engineering and currently works as an independent software developer, a mentor, and a consultant for enterprise companies. Since 2000, he has been involved in .NET- and SQL-Server-based development. Zsolt has a passion for solving complex problems by applying his extensive .NET and SQL Server skills. He enjoys optimizing slow databases and architecting large enterprise systems. In his spare time, he loves to develop and execute algorithmic trading strategies on financial markets.

Previous Section
Next Chapter