This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I'm writing a Minimal API application using .NET 9. I started this on my laptop, then committed the changes to my GitHub repo and tried to pick up where I left off on my desktop. However, when I tried to test it using Postman to retrieve the dishes of a fictional business, I got the error:
No such table: Dishes
The tutorial I'm following uses a Sqlite database. I've created it on my laptop and expected it to work on my desktop, but it doesn't. I put this code snippet into the Program.cs file:
using (var serviceScope = app.Services.GetService<IServiceScopeFactory>()?.CreateScope())
{
var context = serviceScope?.ServiceProvider.GetRequiredService<MyDishesDbContext>();
context?.Database.EnsureDeleted();
context?.Database.Migrate();
}
I think the problem is the Sqlite database that I generated using EF Core migrations on my laptop, doesn't appear to be in my desktop. How do I get that Sqlite database to be in both places? Or if that's not the issue, then what is the issue and how do I resolve it?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
SQLite is a local database file. Unless it’s read only, two applications can not access the same database file concurrently. If you created the db file it on your laptop, you need to copy it to the desktop. If the desktop changes the file, you would need to copy it back to the laptop to see the changes on the laptop.
if you want the desktop and laptop to share access to a SQLite database, you should create a webapi application that hosts the database on a computer they can both access. Then the laptop and desktop could call the same webapi.
OK, I'll look for the database on my laptop, then copy it to my desktop.
Hi @Bruce (SqlWork.com) I looked on my laptop, but couldn't find a file there with an extension of .db, which I've seen used for Sqlite databases. However, I did find a file named slnx.sqlite in the .vs folder of the project on my laptop. And there isn't a .vs folder in the same project that I cloned to my desktop. However, I'm sure that is because the Gitignore file, for Visual Studio, specifically ignores the .vs folder.
Assuming I'm correct about that, can I just create a .vs folder in the project on my desktop and copy the slnx.sqlite file into it? Or should VS 2022 create the .vs folder in some other way?
the slnx.sqlite is just a preferences file, its not the database. the database is typically a .db, and the directory should be specified in the connection string. if not specified it would be the bin folder that app is running in.