This shows you the differences between two versions of the page.
Next revision | Previous revision Next revision Both sides next revision | ||
sqlite_dotnet_ef_vscode [2021/09/01 09:46] sausage created |
sqlite_dotnet_ef_vscode [2021/09/22 05:20] sausage [Creating a .NET Core application with Entity Framework and SQLite in VSCode] |
||
---|---|---|---|
Line 3: | Line 3: | ||
{{:sqlite:sqlite-ef-vscode.png?direct&400 |}} | {{:sqlite:sqlite-ef-vscode.png?direct&400 |}} | ||
- | One of the nice things about SQLite databases is that they are so much easier than other databases to spin up and work with. That's opposed to something like SQL Server and it's heavy overhead with a SQL Server installation. | + | One of the nice things about SQLite databases is that they are so quick to spin up and work with. That's opposed to the overhead of something like SQL Server and it's installation. |
Also that SQLite databases can sit comfortably with the application itself for deployments of simple web architectures. There is something simply refreshing about that. | Also that SQLite databases can sit comfortably with the application itself for deployments of simple web architectures. There is something simply refreshing about that. | ||
Line 35: | Line 35: | ||
===== Packages ===== | ===== Packages ===== | ||
- | To use Entity Framework and an API to access SQLite, we need the ''Microsoft.EntityFrameworkCore.Sqlite.'' package. | + | To use Entity Framework and an API to access SQLite, we need the ''Microsoft.EntityFrameworkCore.Sqlite'' package. |
This can be installed (in my case) for .NET 5 with: | This can be installed (in my case) for .NET 5 with: | ||
- | Install-Package Microsoft.EntityFrameworkCore.Sqlite -Version 5.0.9 | + | dotnet add package Microsoft.EntityFrameworkCore.Sqlite --version 5.0.9 |
It will depend on what version of .NET Core you are using. If you are not having luck installing the package, head over to ''nuget.org'': | It will depend on what version of .NET Core you are using. If you are not having luck installing the package, head over to ''nuget.org'': |