Code-First Development with Entity Framework

Take your data access skills to the next level with Entity Framework

Code-First Development with Entity Framework

Mastering
Sergey Barskiy

1 customer reviews
Take your data access skills to the next level with Entity Framework
$19.99
$24.99
RRP $19.99
RRP $24.99
eBook
Print + eBook

Instantly access this course right now and get the skills you need in 2017

With unlimited access to a constantly growing library of over 4,000 eBooks and Videos, a subscription to Mapt gives you everything you need to learn new skills. Cancel anytime.

Free Sample

Book Details

ISBN 139781784396275
Paperback174 pages

Book Description

Entity Framework Code-First enables developers to read and write data in a relational database system using C# or VB.NET. It is Microsoft's answer to demand for an ORM from .NET developers.

This book will help you acquire the necessary skills to program your applications using Entity Framework. You will start with database configuration and learn how to write classes that define the database structure. You will see how LINQ can be used with Entity Framework to give you access to stored data. You will then learn how to use Entity Framework to persist information in a Relational Database Management System. You will also see how you can benefit from writing ORM-based .NET code. Finally, you will learn how Entity Framework can help you to solve database deployment problems using migrations.

Table of Contents

Chapter 1: Introducing Entity Framework
What is ORM?
A brief history of Entity Framework
The capabilities of Entity Framework
The Entity Framework architecture
Self-test questions
Summary
Chapter 2: Your First Entity Framework Application
Creating a new project that uses Entity Framework
Creating a new database based on .NET classes
Saving a new record to the database
Querying data in a database
Updating a record
Deleting a row from the database
Introduction to schema changes
Self-test questions
Summary
Chapter 3: Defining the Database Structure
Creating table structures
Defining relationships
Self-test questions
Summary
Chapter 4: Querying, Inserting, Updating, and Deleting Data
The basics of LINQ
Filtering data in queries
Sorting data in queries
Exploring LINQ functions
Working with related entities
Inserting data into the database
Updating data in the database
Deleting data from the database
Self-test questions
Summary
Chapter 5: Advanced Modeling and Querying Techniques
Advanced modeling techniques
Advanced querying techniques
Self-test questions
Summary
Chapter 6: Working with Views, Stored Procedures, the Asynchronous API, and Concurrency
Working with views
Working with stored procedures
The asynchronous API
Handling concurrency
Self-test questions
Summary
Chapter 7: Database Migrations and Additional Features
Enabling and running migrations
Using the migrations API
Applying migrations
Adding migrations to an existing database
Additional Entity Framework features
Self-test questions
Summary

What You Will Learn

  • Understand what ORM tools are and what problems they solve
  • Set up a .NET application to use Entity Framework
  • Write Entity Framework code that creates, updates, and deletes application data in a database
  • Learn how to query the data using LINQ and gain insight into how LINQ fits into Entity Framework
  • Create a database structure using the Entity Framework configuration API
  • Evolve the database structure using migrations
  • Write asynchronous code and handle concurrency
  • Work with stored procedures and functions using Entity Framework

Authors

Table of Contents

Chapter 1: Introducing Entity Framework
What is ORM?
A brief history of Entity Framework
The capabilities of Entity Framework
The Entity Framework architecture
Self-test questions
Summary
Chapter 2: Your First Entity Framework Application
Creating a new project that uses Entity Framework
Creating a new database based on .NET classes
Saving a new record to the database
Querying data in a database
Updating a record
Deleting a row from the database
Introduction to schema changes
Self-test questions
Summary
Chapter 3: Defining the Database Structure
Creating table structures
Defining relationships
Self-test questions
Summary
Chapter 4: Querying, Inserting, Updating, and Deleting Data
The basics of LINQ
Filtering data in queries
Sorting data in queries
Exploring LINQ functions
Working with related entities
Inserting data into the database
Updating data in the database
Deleting data from the database
Self-test questions
Summary
Chapter 5: Advanced Modeling and Querying Techniques
Advanced modeling techniques
Advanced querying techniques
Self-test questions
Summary
Chapter 6: Working with Views, Stored Procedures, the Asynchronous API, and Concurrency
Working with views
Working with stored procedures
The asynchronous API
Handling concurrency
Self-test questions
Summary
Chapter 7: Database Migrations and Additional Features
Enabling and running migrations
Using the migrations API
Applying migrations
Adding migrations to an existing database
Additional Entity Framework features
Self-test questions
Summary

Book Details

ISBN 139781784396275
Paperback174 pages
Read More
From 1 reviews

Read More Reviews