madd0/AzureStorageDriver

I might have the wrong expectations is it possible save changes to table storage not just query?

Closed this issue · 5 comments

rluiten commented

Cheers, for any suggestion.
We may need to look at a console app if it can't.

madd0 commented

Hi,

The driver includes pretty recent versions of Microsoft's Azure Cosmos DB Table APIs, so anything you wanted to do with a console app can be done straight from LinqPad too.

  • LINQPad 6 plugin uses Microsoft.Azure.Cosmos.Table 1.0.5
  • LINQPad 5 plugin uses Microsoft.Azure.CosmosDB.Table 2.1.2

Once you have associated an Azure Table Storage connection to your query, you can use this.TableClient to get a CloudTableClient instance and, for any detected tables, you can use this.MyTestTable.CloudTable to get a CloudTable instance.

I think that with those two, you can do pretty much anything. If you create any new tables in your script, all you have to do is refresh the connection for them to be detected.

rluiten commented

Sorry for my tardy response, this helped us.
Thanks.

rs38 commented

@madd0
I try to follow your hint with Azure StorageEmulator:
with Linqpad6 I am unable to retrieve a TableClient from this context to start with.
the only object I can see is a System.Data.SqlClient.SqlConnection.

is there a way to reuse the associated connection to add rows?

madd0 commented

@rs38 are you sure that you have selected the correct Connection?

This is what it looks like when you're using a connection created by the plugin:

image

rs38 commented

I though I was sure :)
Now it's clear, it must have been sth. very stupid like that...
thanks a lot, I should have asked earlier!

image