Release notes
Erik Ejlskov Jensen edited this page Mar 19, 2024
·
196 revisions
Visual Studio 2017 and later (daily build)
SQL Server Management Studio 18.x (daily build) - see readme for install instructions!
New features
- Support for Microsoft.Data.SqlClient #980
- Update to System.Data.SQLite 1.0.118
Improvements
- Better Sqlite foreign key triggers
New features
- Update to System.Data.SQLite 1.0.117
Bug fixes
- Add transparency to MarketPlace icon
- SQLite autoinc was not detected correctly #832
- Messageboxes had Yes/No for no good reason
New features
- Updated SQLite to 1.0.116 with support for STRICT tables (does not work in VS 17.2.5, you must update to 17.2.6 or later) #921
Bug fixes
- Add LINQ to SQL DataContext to Current Project was broken #942
- Server Explorer connections not displayed at launch
Improvements
- Update AppInsights dependency #930
- Fix Telemetry crash
- Fix broken Add Reference support #909
Bug fixes
- Fix loading crash in 17.2 and later #935
New features
- Added support for VS 2022
New features
- Made package async
- Removed support for VS 2010, 2012, 2013, 2015
- Update to System.Data.SQLite 1.0.114
- Downgrade to System.Data.SQLite 1.0.112 - download from Releases
New features
- Update to System.Data.SQLite 1.0.113
- Reformat SQL used in "Edit top xxx rows" window
Bug fixes
- Fix sizing of SQL pane in "Edit top xxx rows" window
- Fix issues with dynamic SQL in "Edit top xxx rows" window
- Fix for #842 (COMException if WiX project is included in solution)
- Fix invalid query duration in standalone .exe
New features
- Remove EF 6 Reverse POCO Feature
- Update to System.Data.SQLite 1.0.112
Bug fixes
- Fix for NRE when scripting SQL Server to SQLite
- Improve required dependency list, to prevent crash with grid
New features
- Allow scripting to editor window when scripting a full SQL Server/SQLCE/SQlite database
- Add API to script views
Bug fixes
- Crash in VS 2019 if no relevant workloads were installed
Improvements
-
Update to System.Data.SQLite 1.0.110
-
Improve scripting of DEFAULT values (enclose in () )
-
Avoid SQL Server timeout when getting the column list from a database with many columns and running a newer version of SQL Server.
-
Remove artificial limit on number of files processed during Migrate (max number of files is now 9999)
Bug fixes
- Add DGML escaping
New features
- EF Core Power Tools created, and EF Core reverse engineering removed.
- Addition of include option to SQL Server export
- Addition of where filter to ExportSqlCe
- Support for VS 2019
Improvements
- SQLite scripting: Improve handling of views
- SQLite scripting: Improved export from SQL Server to SQLite
Bug fixes
- Fix NRE on Export (Migrate)
- SQLite scripting: Various bug fixes
Improvements
- Update to use latest System.Data.SQLite version (1.0.107)
- Improved date format in query results
Bug fixes
- SQLite "Remove Connection" was broken
- SQLite tables created with "WITHOUT ROWID" could not be opened
- Fixed scripting of SQLite views with comments
- Fixed scripting of SQLite computed view columns
Improvements
- Allow code generation in SDK type projects
Bug fixes
- Improve SQLmetal.exe detection
New features
- Support for the IntegratedShell VS edition, including SSDT 15.3
Improvements
- Added new 3.5 value to SQL CE version detector range
- Removed EF Core Reverse Engineer, use "EF Core Power Tools" to get the latest and greatest
Bug fixes
- Download count in About dialog fixed
Visual Studio 2012 and later (daily build)
SQL Server Management Studio 16.x/17.x (daily build)
Bug fixes
- Error during Server Export (IOException: The handle is invalid) fixed
Improvements
- Update "Remove broken Connections" to better support SQLite
Bug fixes
- Prevent crash on load when DDEX configuration was invalid
- "Add Connections from Solution" was disabled when SQL Compact was not installed
- Index statistics should never be scripted for SQLite indexes - thanks mwallnoefer
- SQLite "DROP INDEX" syntax was wrong - thanks mwallnoefer
Bug fixes
- Made getting font for SQL editor more robust (discovered via App Insights)
- Fix potential SQLite PK scripting bug
- Revert: Avoid opening new tabs in Debug mode #321
- Remove Connection was not working in many cases
New features
- SQLite DDEX provider for use with EF6 added (due to lack of support for VS 2017 from System.Data.SQLite)
- [SSMS] Add SQLite Toolbox context menu to databases in SSMS 17 Object Explorer (experimental/flaky)
Improvements
- SQLite triggers were not scripted - thanks mwallnoefer
- SQLite views - add "Script as SELECT" - thanks mwallnoefer
- Improve experience for numeric columns in the table designer
- Improve feedback with progress bar during large export/import
- Clean up temp files during large export/import
- Made difference between EF Core / EF6 menu items clearer
- Various refactoring of menu item classes
Bug fixes
- SQLite defaults were not scripted - thanks mwallnoefer
- Toolbox and About dialog crashing in VS 2017 when SQL Compact installation is broken
- Remove warning re DDEX 3.5 provider from Connection dialog
- Avoid opening new tabs in Debug mode
- Improve resiliency for invalid SQL Server connections
- Search feature in query editor was broken
- [SSMS] Some databases in SSMS Object Explorer were not shown in the Toolbox
New features
- Added "Save Selection" and "Load Selection" to the table picker dialog to save and load a list of selected tables
Improvements
- The broken SQL Server Compact 3.5 DDEX provider was removed
Bug fixes
- The SQL Server Compact 4.0 DDEX provider (for Server Explorer integration) was not present after updates/install
- The query duration displayed in the Query Editor was wrong
- Fix potential "invalid cast exception" in code generation
- Make About dialog more robust
New features
- EF Core model code generation: Added option to install the relevant provider NuGet package
- EF Core model code generation: Added option to choose what to generate (DbContext / EntityTypes / both)
Improvements
- Error messages when running script commands now include the failing statement for SQLCE
- Reduce chances of OOM errors during Excel export from SQL Editor
Bug fixes
- Is was not possible to add a SQL Server connection using SQL Server authentication
- Export of geography and geometry columns from SQL Server did not work (during test with AdventureWorks2014) - these data types are now scripted as nvarchar(4000)
New features
- New code generation option for SQL Server, SQLite and SQL Compact: Entity Framework Core Model live demo
- New code generation option for SQL Server: Entity Framework Code/Database First from DACPAC using EF Reverse POCO Template
- "Add SQL Server Connection" menu item added (adds connection to Server Explorer)
- SQLite database script now includes views and triggers
- SQLite views: added "View Data as Report" option
- SQLite database: added Maintenance menu with Vacuum and Re-index
- Support for VS 2017 RTW
- [SSMS] Toolbox lists connected databases from Object Explorer (on-demand)
- [SSMS] Get data directly from a SQL Server Compact table in a SQL Server database via OLEDB and SQLCLR
- [SSMS] Initial support for SSMS 17.x
Improvements
- SQLite triggers moved under related table in Explorer tree
- SQL panel in Edit Data grid now works much better with keyboard controls
- Added Connect and New Query buttons to Explorer Toolbar
- SQL editor queries now run in background, preventing app from "freezing"
- Made VS 2010 edition available (on demand only)
- EDMX generation no longer available/supported (use EF Tools + Toolbox DDEX provider for this in VS 2012+)
- Warn if Report Viewer 2010 is not installed
Bug fixes
- Unable to script SQL Server computed, persisted columns
- FixConnections could throw due to not catching SqlCeInvalidDatabaseFormatException
- Individual SQL query editor windows options did not stick
- SQLite CSV import used invalid datetime format in generated INSERTs
Bug fixes
UI
- Font size was too small compared to editor font (needed to multiply by 1.33333!)
New features
- New code generation option for SQL Server Compact: Entity Framework Code First from Database (using https://github.com/sjh37/EntityFramework-Reverse-POCO-Code-First-Generator )
- Graphical Query Plan directly in the product, no longer need to launch SSMS or similar. (Using: https://github.com/Giorgi/LINQPad.QueryPlanVisualizer )
- Enable support for Visual Studio 2017 RC
Improvements
- Minimized VS UI blocking on launch, by getting the list of databases in the background
- Only show SQLite data types in Table Builder
- Improved About dialog with 150% font size
- Improved Visual Studio version check
- Clarify that the DDEX providers do not support the Data Source Configuration Wizard
- Made simple result grid the default
- Query editor and text result pane now use the default Text Editor font size
- Improved visibility of Column Search dialog in Edit grid
Bug fixes
UI
- Connection dialog should not close on error when clicking OK
- Scroll bars were always visible in Query editor
- Fix for OOM exception with large files in SQL Editor (thanks https://github.com/AlexL70 )
SQL Server Compact
- Forcing DDEX registration for the SQLCE 3.5 provider did not work (from the About dialog)
- Crash caused by broken SQL Compact 3.5 SP1 installation prevented by requiring version 3.5 SP2 in order for SQL Compact 3.5 support to be available
SQLite
- Enable SQLite datetime editing in "Edit Table Data" to be optional
- Fix SQLite date default (was missing a space after "current_timestamp")
- Enable SQLite DataAccess.cs code gen with .NET Core projects
- SQLite foreign keys with multiple columns were not scripted correctly
- SQLite rowid primary keys were sometimes scripted incorrectly
- SQL Server and SQL Compact => SQLite scripts now include rowversion column