In this video, create our first database. Visual Studio by default installs a local database. Explore how to access it as well as manipulate data in it. Review how to test if the database is truly installed and configured as expected from the console and more.
- [Instructor] In our Console app,…we'll be using a local database…that Visual Studio has installed by default…called SQL Server Local DB.…If you're comfortable with SQL Server,…you're able to use any other database.…Local databases, remote databases.…As long as you have permission to create a new database…on the instance, you'll be fine.…We'll be using Local DB.…And the first thing that I want to show you,…is how to verify that we have this Local DB installed.…So what you need to do,…is just scroll down to the lower left-hand corner…of your screen, and enter in developer.…
And one of the first things that should show up,…is the developer prompt for Visual Studio 2015.…This is what Visual Studio installs to set up the path…so that you can reach several command line tools.…Now if you want to increase the font,…all you need to do is go to the upper left-hand corner…of the window, hit Properties, and choose Font,…and select the font size that you want,…and go ahead and click OK.…Now I already have an instance open of this,…
- Entity Framework (EF) overview
- Uses for EF
- Installing EF
- Creating entities
- Creating the DbContext
- Performing migrations
- Creating an MVC application
- Installing EF packages
- Reverse engineering the model
- Performing context and dependency injection
- Creating the controller and the view
- Using SqlServerTypeMapper
Skill Level Intermediate
Q: This course was updated on 06/23/2017. What changed?
A: The following topics were updated: using the exercise files; Mac install prerequisites; Entity Framework on Mac, part 1; and Entity Framework on Mac, part 2.