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>
Table of Contents (15 chapters)
Code-First Development with Entity Framework
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Chapter 6: Working with Views, Stored Procedures, the Asynchronous API, and Concurrency


Q1. Although there is no first class support for views in Entity Framework, we can always retrieve data from a view using the SqlQuery method.

Q2. The SqlQuery method can be used to call an arbitrary SQL statement, including calling stored procedures or functions. Entity Framework will materialize the results based on the generic type provided to this method.

Q3. This is not correct. Insert, update, and delete operations can be automatically generated by Entity Framework. All we need to do is map an entity to stored procedures inside an entity type configuration class.

Q4. This is not correct. Arbitrary use of the asynchronous API can result in performance overhead.

Q5. SaveChangesAsync is the method on DbContext that can be called to flush changes to the database asynchronously.

Q6. IsRowVersion is the only method called that needs to be made on the property configuration class to mark a property as concurrency check property.

Q7. DbUpdateConcurrencyException is the correct type to catch from Entity Framework Code-First to handle concurrency errors.