The key to working with ORM’s is to define the object map. In Entity Framework the map is defined in a set of Entity Data Model (EDM) files. This tutorial looks at the three basic approaches to creating the EDM in Visual Studio. These are known as the model first, database first and code first approach.
- [Voiceover] The heart of any ORM system…is the mapping definition, this is where the relationships…between the relational tables and the database…are mapped to the object types…that represent those database items…in the chosen programming language.…The object side of the mapping is usually called…the object model, or sometimes it's called the domain model.…In Entity Framework, the mapping is defined…with the Entity Data Model, or EDM.…To help define the EDM, Visual Studio includes…the Entity Framework Designer, which is a…visual designer window that helps visualize the mapping,…plus it allows you to define and modify the mapping.…
Also a word about terms, in Entity Framework…the map is usually called the data model.…The first step is using Entity Framework…is to create the Entity Data Model.…There are three approaches to building…the data model in Visual Studio.…They are referred to as the model first,…database first, or code first approach.…Each of these approaches are based on…what you want to use as a starting point…
- Exploring integration with Azure data sources and other Microsoft databases
- Working with SQL Server Express LocalDB
- Connecting to databases with Server Explorer
- Working with database tables
- Manipulating tables with the SQL Server Object Explorer
- Creating queries and custom views
- Creating stored procedures
- Comparing databases
- Building a data project in Visual Studio
- Refactoring a database object
- Deploying the database
- Connecting to Azure databases
- Deploying data projects to Azure
- Integrating Visual Studio with Entity Framework
Skill Level Beginner
Q: This course was updated on 08/23/2017. What changed?
A: The following topics were updated: installing the SSDT features and why LocalDB is essential for developers.
1. Database and Data Integration
The Azure data sources2m 35s
2. SQL Server Express LocalDB
3. Server Explorer
4. SQL Server Object Explorer
5. Queries, Views, and Stored Procedures
6. Compare databases
7. SQL Server Data Project
8. Azure Data
Get an Azure account1m 10s
9. Entity Framework
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.