Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • DownloadDownload
  • PrintPrint
Share this Page URL
Help

Section A.12. Chapter 6: Case Scenario Answers

A.12. Chapter 6: Case Scenario Answers

A.12.1. Case Scenario 1: Choosing an Object-Relational Mapper

  1. Possibly; because the application uses inheritance, this could force you to use LINQ to Entities. Also, you might want to use LINQ to Entities to communicate to the Oracle database, but you could still use traditional ADO.NET.

  2. LINQ to Entities.

  3. You can use LINQ to Entities for the SQL Server data access and for the Oracle data access. The number of tables should not affect your decision. LINQ to Entities also supports inheritance.

A.12.2. Case Scenario 2: Using the Entity Framework

  1. The Entity Framework enables you to generate the Entity Data Model from the existing database schema.

  2. The Entity Framework enables you to represent an entity across multiple tables. For example, the Employee entity name data can be stored in one table, although other information, such as date of birth, might be in a different table. You’re not forced into a one entity per table mapping.

  3. The Entity Framework supports inheritance mapping scenarios, such as table per type (TPT), that enable you to have a base table that maps to a base class and an additional table per type.


  

You are currently reading a PREVIEW of this book.

                                                                                        

Get instant access to over
$1 million worth of books and videos.

  

Start a Free Trial