Strongly-typed data accessors
Data contexts offer access to data from various sources, but this access is not strongly typed. This is not a problem for SQL scripts, but .NET code and C# scripts can benefit from strongly typed access to the data context.
To add strongly typed access to the data context, projects in QueryStorm automatically generate a dll which contains wrapper types for all tables inside the data context. The file is saved into the
lib folder and uses the following naming convention:
This dll file is automatically recreated whenever the data context of the project changes. For workbook data contexts this will happen when a table or a named range is added/removed or when an existing table's structure is changed.
The context types dll is also recreated whenever the
project.config file is saved, so data context scripts also trigger it when they register their output types in the
Regardless of how many data contexts a project defines, there will be only one dll that will define strong types for all of their tables.