Book Image

Code-First Development with Entity Framework

By : Sergey Barskiy
Book Image

Code-First Development with Entity Framework

By: Sergey Barskiy

Overview of this book

<p>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.</p> <p>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.</p>

Related Content you might be interested in

Current Title:

Small book image
Code-First Development with Entity Framework
Sergey Barskiy
Mar, 2015 | 174 pages
No titles found
Table of Contents (15 chapters)
Code-First Development with Entity Framework
Code-First Development with 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
Introducing Entity Framework
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
2
Your First Entity Framework Application
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
3
Defining the Database Structure
Defining the Database Structure
Creating table structures
Defining relationships
Self-test questions
Summary
4
Querying, Inserting, Updating, and Deleting Data
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
5
Advanced Modeling and Querying Techniques
Advanced Modeling and Querying Techniques
Advanced modeling techniques
Advanced querying techniques
Self-test questions
Summary
6
Working with Views, Stored Procedures, the Asynchronous API, and Concurrency
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
7
Database Migrations and Additional Features
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
Answers to Self-test Questions
Answers to Self-test Questions
Chapter 1: Introducing Entity Framework
Chapter 2: Your First Entity Framework Application
Chapter 3: Defining the Database Structure
Chapter 4: Querying, Inserting, Updating, and Deleting Data
Chapter 5: Advanced Modeling and Querying Techniques
Chapter 6: Working with Views, Stored Procedures, the Asynchronous API, and Concurrency
Chapter 7: Database Migrations and Additional Features
Index
Index

Self-test questions

Q1. You would like to define a column to store a number without a fractional value, but you want to make the value optional. What .NET type should you use for such property?

  1. Decimal

  2. Decimal?

  3. Int

  4. Int?

Q2. If you want to make the first name column to be non-nullable in the database, you can rely on default conventions in Entity Framework and avoid all configuration, true or false?

Q3. You cannot override conventions that are preloaded with Entity Framework, such as the one that makes all foreign key constraints be setup to cascade on delete, true or false?

Q4. Which of the following is not a type of relationship?

  1. One-to-Many

  2. Many-to-Many

  3. One-or-Zero-to-Many

  4. Many-to-Default

Q5. The best way to configure all properties in all classes is to list them one by one in OnModelCreating method of the context, true or false?

Q6. If you do not configure any additional information for string properties, what type will be used in the SQL Server database?

  1. NVARCHAR(4000)

  2. NVARCHAR(MAX)

  3. VARBINARY(MAX)

  4. VARCHAR...

Previous Section
End of Section 4
Next Section