Course description
We’ll start the course with a look at how you can customize an entity data model to make it easier for application developers to use its entity objects. The model designer in Visual Studio has plenty of options for refining a model, as well as make it easier to work with large, complex models with hundreds of entities. To finish up you’ll also learn some best practices of model design, so that you can build robust applications that take full advantage of the right Entity Framework infrastructure.
Prerequisites
This course assumes that you are experienced with relational database design and programming concepts. Entity Framework is all about data access, and the course doesn’t spend any time on data fundamentals.
You’ll also need a good understanding of object-oriented programming in C#, so that you know how to use the entity data objects that Entity Framework generates from your data model. You’ll also need to have a working knowledge of Language INtegrated Queries (LINQ) in C#.
The course uses Entity Framework with various SQL Server databases, so you should know enough about SQL Server to know how to perform various tasks and be able to connect to a database. But you don’t need deep knowledge of SQL Server to use Entity Framework productively. You should have already viewed the Entity Framework 6.1: Querying and Updating Data course before taking this course.
Learning Paths
This course will help you prepare for the following certification and exam:
MCSD: Web Applications
70-487: Developing Windows Azure and Web Services
This course is part of the following LearnNowOnline SuccessPaths™:
Accessing Data Services for Win Dev
Accessing Data Services
Meet the expert
Don Kiely is a featured instructor on many of our SQL Server and Visual Studio courses. He is a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. Don has many years of teaching experience, is the author or co-author of several programming books, and has spoken at many industry conferences and user groups. In addition, Don is a consultant for a variety of companies that develop distributed applications for public and private organizations.
Course outline
ORM and Modifying Entities
Unleash the Power of ORM (16:38)
- Introduction (01:09)
- The Power of ORM (01:15)
- Demo: New Class Library Project (04:57)
- Demo: Entity Data Model Wizard (04:19)
- Demo: The Entity Data Model (04:15)
- Summary (00:40)
The Model and Default Values (36:27)
- Introduction (00:51)
- Demo: Organize the Data Model (05:06)
- Demo: Menus (04:18)
- Demo: Menus (cont.) (03:28)
- Creating Sub Diagrams (01:32)
- Demo: Sub Diagrams (04:48)
- Demo: Sub Diagrams (cont.) (04:23)
- Demo: Colors (02:02)
- Default Values (02:11)
- Demo: Default Values (01:54)
- Demo: Default Values (cont.) (04:49)
- Summary (01:00)
Cleaning up the Model (27:22)
- Introduction (00:41)
- Cleaning Up the Model (03:01)
- Entities (00:31)
- Demo: Cleaning Up - Entities (04:47)
- Demo: Clean Up - View Entities (03:39)
- Entity Properties (01:06)
- Demo: Scalar Properties (05:19)
- Demo: Scalar (cont.) (02:39)
- Demo: “Application” Names (05:06)
- Summary (00:27)
Navigation Properties (13:08)
- Introduction (00:24)
- Demo: Navigation Properties (03:12)
- Demo: Multiple Relationships (04:53)
- Demo: Self Joins (04:09)
- Summary (00:28)