Using SQLite with ASP.NET Core MVC yields SQL Server error 52 (Unable to locate a Local Database Runtime installation)

Question

I'm using Visual Studio Code with the .net version 6.0. I have the following extensions installed:

At the third chapter "model" I'm having some issues.

One of my biggest issue is the database. I need to enter this code:

dotnet ef database update

after some time it shows this error: Error Message:

[...] Unable to locate a Local Database Runtime installation [...]

What can I do? Did I forget something? Is that a proxy issue? I am a beginner. Hope you can help me.

Please copy the text from your console into your question as text, not an image. — CodeCaster
– CodeCaster, Commented Nov 25, 2021 at 9:50

CodeCaster · Accepted Answer · 2021-11-25 09:49:43Z

2

You're using SQLite, but the tutorial uses SQL Server. The EF Core console app sample uses SQLite though.

Instead of installing Microsoft.EntityFrameworkCore.SqlServer, use:

dotnet add package Microsoft.EntityFrameworkCore.Sqlite

And instead of UseSqlServer(), use:

options.UseSqlite($"Data Source={DbPath}");

answered Nov 25, 2021 at 9:49

CodeCaster

153k24 gold badges237 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1