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

Count
Followers 0
Login Register as User

SQLite Manager

10.07.2018 (👁11580)

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.

 

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

https://readdy.net/Notes/Details/527?r=31

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