![]() ![]() Right-click the solution, and then click Manage NuGet Packages for Solution.Īt this point, you have a choice. NET class library project to contain your data access code, but we won't use one in our example. If you plan to share your data access logic with other client code, you can use a. Let's start by adding a class to your project named DataAccess. ✔️ App load time has the potential to be faster because most likely, the SDK version of SQLite will already be loaded into memory. The Windows version of SQLite is maintained by Microsoft in coordination with. ✔️ Prevents you from having to push a new version of your app to users in the event that SQLite publishes critical fixes to bugs and security vulnerabilities in SQLite. ✔️ Reduces the size of your application because you don't have to download the SQLite binary, and then package it as part of your application. ![]() Instead, your app can use the version of SQLite that comes installed with Windows. We'll start with a basic Windows App SDK project, and then install the SQLite NuGet package.Īll supported versions of Windows support SQLite, so your app does not have to package SQLite libraries. The rest of this guide helps you to use this library. Microsoft actively maintains these implementations, and they provide an intuitive wrapper around the low-level native SQLite API. The library implements the interfaces in the namespace. To try it out, see Getting Started with EF Core. NET apps, you can use the same code in your Windows App SDK app and it will work with appropriate changes to the connection string. If you've already used this framework to work with data in other. Entity Framework CoreĮntity Framework (EF) is an object-relational mapper that you can use to work with relational data by using domain-specific objects. We recommend that you use either Entity Framework Core or the open-source SQLite library built by Microsoft. ✔️ SQLite works across platforms and architectures. ✔️ SQLite is in the public domain so you can freely use and distribute it with your app. The client and the server run in the same process. It's a code library without any other dependencies. ✔️ SQLite is lightweight and self-contained. Some benefits of using SQLite for local storage This guide shows you how to do it in your Windows App SDK apps. -a, -ad-hoc - run using an ad-hoc SSL context.Ī Dockerfile is provided with sqlite-web.You can use SQLite to store and retrieve data in a lightweight database on the user's device.-c, -cert and -k, -key - specify SSL cert and private key.-u, -url-prefix: URL prefix for application, e.g.Multiple extensions, specify -e for each extension. -e, -extension: path or name of loadable extension(s).-R, -rows-per-page: set pagination on content page, default 50 rows.-r, -read-only: open database in read-only mode.Password, but will use the value from the environment. -P, -password: prompt for password to access sqlite-web.Īlternatively, the password can be stored in the "SQLITE_WEB_PASSWORD"Įnvironment variable, in which case the application will not prompt for a.-x, -no-browser: do not open a web-browser when sqlite-web starts. ![]() -l, -log-file: filename for application logs.The export tab supports exporting all, or a subset, of columns:īasic INSERT, UPDATE and DELETE queries are supported: There is an option to automatically create columns for any unrecognized keys in the import file: The import tab supports importing CSV and JSON files into a table. ![]() The query results are displayed in a table and can be exported to either JSON or CSV: The query tab allows you to execute arbitrary SQL queries on a table. Links in the table header can be used to sort the data: The content tab displays all the table data. From this page you can also create, rename or drop columns and indexes. The structure tab displays information about the structure of the table, including columns, indexes, triggers, and foreign keys (if any exist). The index page shows some basic information about the database, including the number of tables and indexes, as well as its size on disk: Columns (with support for older versions of Sqlite).Works with your existing SQLite databases, or can be used to create new databases.$ sqlite_web /path/to/database.db Features ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |