After nearly 340.000 downloads, version 4.1 of my SQLite & SQL Server Compact Toolbox extension for Visual Studio 2015, 2013, 2012 and 2010 is now available for download. This blog post is a visual guide to the new features included in this release, many suggested by users of the tool via the CodePlex issue tracker.
Improved SQLite integration
"Add SQLite Connection" dialog improved
The “Add SQLite Connection” dialog has been enhanced to include all the available ADO.NET connection string options, by using SQLiteConnectionStringBuilder. This allows you to easily specify advanced “PRAGMA” statements to be configured, for example:
Enumerate SQLite Server Explorer connections
If you have the SQLite support for Server Explorer installed (requires Visual Studio Community or higher, will not work with Express). See my blog post here for more info on the SQLite DDEX provider. Those connections are now also listed in the Toolbox list of connections:
Enumerate SQLite views and triggers
SQLite allows you to define triggers and views, and these are now listed under each SQLite database file, and you can create CREATE and DROP statements for these object types.
SQL Compact runtime no longer required
The Toolbox no longer requires any version of SQL Server Compact to be installed (useful if you only work with SQLite database files)
Fixes and improvements
- horisontal scrollbar in Explorer window
- less obtrusive handling of DDEX providers installation
- no longer using MessageBox.Show
- update to latest SQLite ADO.NET provider (1.0.94)
- improved parsing/separation of SQL statements spilt with GO in Editor