This is a plug-in for LINQPad that enables the execution of queries against Azure Table Storage.

It allows you to add storage accounts as connections in LINQPad. It will list all tables for each account and all columns in each table. Since Azure tables can have mixed schemas, a property was added in version 1.1.0 allowing users to specify the number of rows that should be scanned to determine the schema of each table. For the same reason, any value types are made Nullable<> since it cannot be guaranteed that they will have a value for a given row.

Issues and feature requests can be made in the projects issues page on GitHub.

• Updated dependency versions:

  • LINQPad.Reference: 1.1.0 -> 1.3.0
  • SonarAnalyzer.CSharp: 8.0.0.9566 -> 8.48.0.56517
  • Microsoft.CodeAnalysis.CSharp: 3.3.1 -> 3.11.0

• Added explicit reference to Newtonsoft.Json to work around issue #22

• Workaround for problem described in #20
  • The .NET Core 3.1 driver was getting .NET Core 3.0 references, which prevented it from compiling the generated code because the driver itself was a reference and therefore needed 3.1 references.
  • As a workaround, the driver is no longer a required reference for the generated code, which is compatible with either .NET Core 3.0 or 3.1, so no matter what runtime LinqPad provides, the code should compile.

Happy new year! After last month's update, I decided to work on some really old pending PRs, do some cleanup and tackle #19 which came in on the first day of the year.

• Integrate PR #8: add support for china azure(code name:mooncake)
  • Adds support for China, US Government and German "clouds."
  • Found by expanding the Advanced section in the connection properties dialog.
• Integrate PR #12: Enable parallel schema loading
  • Speeds up loading of storage accounts with multiple tables.
  • Max number of parallel queries can be set in the Advanced section in the connection properties dialog.
• Target .NET Core 3.1
  • The Nuget package now includes .NET 4.6, .NET Core 3.0 and .NET Core 3.1 versions.
  • The .NET Core 3.1 version of the DLL should prevent issues such as described in #19: When .NET Core 3.1 installed, "Cannot compile typed context" error

It took a while for a new version to come out, but with LINQPad 6 and big changes in the Azure SDK libraries, I thought it was time. And, although functionally not much has changed, I decided that a new distribution channel and total change in the underlying SDK, deserved a new major version.

• New: Available as a Nuget package for LINQPad 6.
• Switch to Azure Cosmos DB Table API
  • LINQPad 6 plugin uses Microsoft.Azure.Cosmos.Table 1.0.5
  • LINQPad 5 plugin uses Microsoft.Azure.CosmosDB.Table 2.1.2

Note: the Azure Storage SDK used by the LINQPad 5 version is in maintenance mode and it will be deprecated soon according to Microsoft. However, since LINQPad 5 plugins target .NET Framework 4.6, the switch to the package used by the LINQPad 6 plugin is not possible.

• Uses latest version of Azure Storage Client Library (4.2.0)
• Provides a solution to issue #1 by adding a configuration parameter that allows users to specify the number of rows to be scanned to determine the schema of a table (100 by default).

Corrects issue #4.

This is the first public release. Needs real-world testing.