Readdy Write  
0,00 €
Your View Money
Views: Count
Self 20% 0
Your Content 60% 0

Users by Links 0
u1*(Content+Views) 10% 0
Follow-Follower 0
s2*(Income) 5% 0

Followers 0
Login Register as User

SQLite Manager

10.07.2018 (👁12253)

SQLite Manager

03.07.2018 (👁49)

SQLite Manager under Visual Studio


With the Visual Studio Extension: SQLite / SQL Server Compact Toolbox you can edit and edit local SQLite databases.

This small database manager is helpful in developing UWP applications with local databases.



You can install the tool under Visual Studio-> Tools-> Extensions and Updates.

After installation you will find the SQlite Database Manager under Visual Studio-> Tools-> SQLite / SQL Server Compact Toolbox



Open SQlite database in the Table Manager / Designer" width="1022" height="520">



Append SQLite database

Your own current database must then be added manually via the connection.


Add Database:

In the View tab: SQLite / SQL Server Compact Toolbox -> Menu -> Add SQLite Connection" width="1022" height="546">


Dialog: Add SQLite Connection: -> Select Browse" width="1022" height="669">



Insert current app database

If you install a UWP App with Debug and / or Deploy, the database will be added to Runtime in the installation directory of the Windows 10 App.


Then enter the path of the connection to the UWP app above


You can find the database in the% AppData% \ Local \ Packages \ yourApp \ Localstate directory


C: \ Users \ Raimund \ AppData \ Local \ Packages \ 12345-your-AppID \ Local State

Select the database as sqliteSample.db, confirm with Open and close the dialog." width="1022" height="546">


Then you can open the tables with Edit Top 200 Rows" width="1022" height="721">


These records can also be edited directly." width="1022" height="550">


From this you can also conveniently determine the SQL Transact commands

Script as SELECT

Script as INSERT UPDATE DELETE" width="1022" height="722">




Then you can view the Sqlite database" width="1022" height="607">


Find the path to the SQLite database

Application code for displaying the SQLite database

SqliteConnection cn_connection = clsDB.Get_Sqlite_Connection();

string sConnection=cn_connection.DataSource;



Results in the edition



Instructions under

https://Readdy.Net/Notes/Details/531?r=44" data-numposts="10">