SQLite Setup
This is a simple post about how to add and use SQLite to your project. We will be adding Sqlite to a console app to start with. We will cover: Why SQLite Add Sqlite Adding the tools needed Create database Making schema changes Apply schema changes Why SQLite SQLite is a free lightweight single-file database that requires no engine. For its size, it is a great choice for mobile, desktop, and small to medium web applications (SQLite) . If you are running a large web application or need to support complex joins or queries, this is not the database you want to use. SQLite has an entity framework provider, so all data access is the same as any entity framework application. Another strong point was using it. For the Blazor applications that I blog about, it is a perfect choice. Defined Project We will be building a simple app to showcase SQLite. Our model will be a Blog Post: public class Post ...