Join Richard Goforth for an in-depth discussion in this video PostgreSQL, part of Accessing Existing Databases with Entity Framework Core.
- [Instructor] To really explore…the flexibility of dotnetcore we're going to create…a new project against the PostgreSQL database on a Mac.…I've already installed a PostgeSQL database…with PG Admin and dotnetcore.…I'll start by opening a terminal window.…Command space to open the spotlight search…and type terminal.…I'll create a new folder for our project…and navigate to that folder.…I'll run dotnet new to create a new dotnet project.…I'm going to open Sublime Text from the spotlight search.…
In my new directory I'll choose the project.json file.…I need to add the EntityFrameworkCore dependencies.…First I'll add Microsoft.EntityFrameworkCore.Design…like we did before.…Now add the PostgreSQL libraries.…Now add the entity framework tools…after the framework section.…Microsoft.EntityFrameworkCore.Tools.…The version here will match the…entity framework core design version.…
Now we'll save the file and go back to the terminal window.…Run dotnet restore.…Entity framework core has been added to our new project.…Now let's restore our database backup to the server.…
- Setting up your project
- Connecting to a legacy database
- Scaffolding an initial model and context
- Improving the model
- Updating properties and indexes
- Adding concurrency tokens and timestamps
- Creating complex relationships
- Working with non-Microsoft databases such as SQLite and PostgreSQL
Skill Level Intermediate
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
Microsoft SQL Server 2014: Backup and Recoverywith Martin Guidry1h 22m Intermediate
1. Get Started with EF Core: On Your Legacy Database
2. Improve the Model
3. Model Complex Relationships
4. Work with Non-Microsoft Databases
- 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.