Join Richard Goforth for an in-depth discussion in this video Create a SQLite database, part of Accessing Existing Databases with Entity Framework Core.
- [Instructor] H+ Sports has decided…that they want to develop a mobile app.…We'd like to use a SQLite database,…and we can use Entity Framework Core…to create it from our existing MS SQL Database.…In this video, we'll create a new DB context…to build a schema for the SQLite Database.…In the next video, we'll copy over the data…from our existing database with Entity Framework Core.…Before we get started, let's download a SQLite browser…that we can use to view the new database.…I've selected SQLite browser,…which I've downloaded from sqlitebrowser.org.…
First, we'll need to add the SQLite Libraries…to our project.…Open the project.json file,…and add the SQLite reference.…It's Microsoft.EntityframeworkCore.Sqlite.…If you're going to scaffold from a SQLite database,…like we did from the MS SQL database,…you'll also want to add…Microsoft.EntityframeworkCore.Sqlite.Design.…We won't be doing that in this video,…but it's good to know if you need it.…Now we'll Save the project.json file,…and Visual Studio will restore the packages.…
- 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.