QueryStorm 2.5

Updates C# from 7.1 to 9 and upgrades SQLite to latest version with window functions.
September 3, 2021
New Version

Features

  • Roslyn has been updated from v3.5 to v3.11 and as a consequence, the version of C# in QueryStorm has been upgraded from C# 7.1 to C# 9. New features this adds are:
    • Record types [C# 9].
    • Indices and ranges [C# 8].
    • Async streams [C# 8].
    • Nullable reference types [C# 8].
  • The version of SQLite used by QueryStorm has been upgraded from 3.15.2 to 3.36.0 which introduces the availability of SQLite window functions. These make it easy to perform calculations that depend on surrounding rows. A typical example would be calculating a running total or a moving average.
  • Introduces a new Cached attribute that can be applied to user defined Microsoft Excel functions.
  • Adds support for opening txt files in the IDE.
  • Allow binding component properties with enum types.
  • Limited the Package Manager to stable NuGet packages since, most often, choosing a stable release is the correct option.
  • Added syntax highlighting for the new with keyword in C#.
  • Logging compilation warnings even if build succeeds (previously warnings were shown only when a build failed).
QueryStorm

QueryStorm

Excel Plugin adds powerful development and data processing capabilities into Microsoft Excel.

Got a Question?

Live Chat with our QueryStorm licensing specialists now.