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.
installation
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
Start
Open SQlite database in the Table Manager / Designer
https://readdy.net/User_Files/Notes/Images/Image_531_0_blog.jpg" 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
https://readdy.net/User_Files/Notes/Images/Image_531_1_blog.jpg" width="1022" height="546">
Dialog: Add SQLite Connection: -> Select Browse
https://readdy.net/User_Files/Notes/Images/Image_531_2_blog.jpg" 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
Example:
C: \ Users \ Raimund \ AppData \ Local \ Packages \ 12345-your-AppID \ Local State
Select the database as sqliteSample.db, confirm with Open and close the dialog.
https://readdy.net/User_Files/Notes/Images/Image_531_3_blog.jpg" width="1022" height="546">
Then you can open the tables with Edit Top 200 Rows
https://readdy.net/User_Files/Notes/Images/Image_531_4_blog.jpg" width="1022" height="721">
These records can also be edited directly.
https://readdy.net/User_Files/Notes/Images/Image_531_5_blog.jpg" width="1022" height="550">
From this you can also conveniently determine the SQL Transact commands
Script as SELECT
Script as INSERT UPDATE DELETE
https://readdy.net/User_Files/Notes/Images/Image_531_6_blog.jpg" width="1022" height="722">
Then you can view the Sqlite database
https://readdy.net/User_Files/Notes/Images/Image_531_7_blog.jpg" 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
database=C:\Users\Raimund\AppData\Local\Packages\709a97e4-xxx\LocalState\sqliteSample.db |
Instructions under