Join Richard Goforth for an in-depth discussion in this video Populate a SQLite database, part of Accessing Existing Databases with Entity Framework Core.
- [Instructor] All right, now let's try…and get some data into our new SQLite database.…SQLite has some limitations compared to MS SQL server.…One of those limitations is generated columns.…For now, we're going to remove those columns from our model.…In a production environment, you'd probably have…two separate contexts, rather than having…the SQLite context extend an MS SQL context.…Let's open the model folder and open the order model.…We'll remove the last update column.…We'll go now to the customer model…and remove the computed column last first.…
Now we'll go to the context and…remove those columns from there.…With those columns removed, we'll save the files.…Now we need to recreate our SQLite database…without those columns.…We'll start by removing the migrations…that we created before.…(Windows chime)…Next, we'll go to our project folder…and remove the SQLite database file.…Now we'll open up a command window,…navigate to our project folder,…and run dotnet ef migrations add InitialSQLite…with the context SQLiteDBContext.…
- 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.