Using Microsoft.WindowsAzure.Storage (WindowsAzure.Storage) 9.1.1 in a Function is failing on call to Newtonsoft outside of its dependency

[justin-typsy]

• I am using a Function
• I am using WindowsAzure.Storage 9.1.1, it states that it has a dependency on Newtonsoft >= 10.0.2
• I'm using .NET Framework 4.5
• I have Newtonsoft 11.0.2 installed (using the method suggested at https://github.com/Azure/azure-functions-vs-build-sdk)
• When I execute the following code there is an exception on table.ExecuteBatch
• The code runs fine if called from a Console

InnerException {"Could not load file or assembly 'Newtonsoft.Json, Version=10.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' or one of its dependencies. The system cannot find the file specified.":"Newtonsoft.Json, Version=10.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed"} System.Exception {System.IO.FileNotFoundException}

public void TableStorageDemo()
{
    storageAccount = CloudStorageAccount.Parse("connection");

    tableClient = storageAccount.CreateCloudTableClient();

    table = tableClient.GetTableReference("TABLE_NAME");

    TableBatchOperation batchOperation = new TableBatchOperation();

    var entity = new Entity();
    entity.Test = "Hello World";

    batchOperation.InsertOrReplace(entity);

    if (batchOperation.Count() > 0) table.ExecuteBatch(batchOperation);
}

Why is the it looking for 10.0.0.0 when it has a dependency on Newtonsoft >= 10.0.2

I have tried with various versions of WindowsAzure.Storage and it only works within the Function when using version 8.7.0 which has a dependency on Newtonsoft >= 6.0.8

Another user can reproduce and suggests this is a bug.

It seems the Function App SDK has a dependency related issue. The issue that it seems not related to WindowsAzure.Storage 9.1.1 itself. As WindowsAzure.Storage 9.1.1 and Newtonsoft 11.0.2 are working correctly in the console application.

More information about the bug detailed here: https://stackoverflow.com/questions/49812091/microsoft-windowsazure-storage-windowsazure-storage-9-1-1-failing-on-call-to-n

[GPugnet]

I am facing the same issue.
The Newtonsoft reference in https://github.com/Azure/azure-functions-vs-build-sdk/blob/1.0.13/src/Microsoft.NET.Sdk.Functions.Generator/Microsoft.NET.Sdk.Functions.Generator.csproj
is <PackageReference Include="Newtonsoft.Json" Version="[9.0.1]" /> which is causing the issue.

A PR was submitted: #200 but is not yet pushed to nuget.

[Ruud-cb]

Any news on when this will be released please?

[larsfagerbakke]

I'm getting the same error, any news about this?

Downgrading WindowsAzure.Storage to 8.7.0 makes it workable again.

[JohnReeson]

That PR is closed instead of merged. V1 function locks Newtonsoft.Json to 9.0.1 and it won't be changed, see the explanation.

[vijayrkn]

Related to this issue? #266

[ColbyTresness]

Closing. Please see explanation.