TryGetSqlShardMapManager returns exception

[pristinesource]

TryGetSqlShardMapManager returns exception

[thuru-zz]

Same issue on both .NET 4.7 and .NET Core as well

[206mph]

I'm getting the same error as well in .NET Core.

[206mph]

Has anyone found a workaround for this?

[thuru-zz]

seems like the elastic pool development in the asp.net core is not active. I ended up handling this manually using custom code and switching the context in EFCore.
https://thuru.net/2017/05/28/ef-core-with-azure-elastic-database-pool-on-net-framework/

[thePmr]

@206mph yes, there's a workaround.

Seems what happened with the project when you've opened it is described here – files .xproj and project.json have been converted to good old .csproj. The problem here is that resource files were expelled from project during this upgrade. What you need is to add them manually:

1. Open .csproj with text editor.
2. Copy the following in the end of this file, right before tag:

...
  <ItemGroup>
    <Compile Update="ShardManagement\Errors.Designer.cs">
      <DesignTime>True</DesignTime>
      <AutoGen>True</AutoGen>
      <DependentUpon>Errors.resx</DependentUpon>
    </Compile>
    <Compile Update="ShardManagement\PerformanceCounters.Designer.cs">
      <DesignTime>True</DesignTime>
      <AutoGen>True</AutoGen>
      <DependentUpon>PerformanceCounters.resx</DependentUpon>
    </Compile>
    <Compile Update="ShardManagement\ReadOnlyScripts.Designer.cs">
      <DesignTime>True</DesignTime>
      <AutoGen>True</AutoGen>
      <DependentUpon>ReadOnlyScripts.resx</DependentUpon>
    </Compile>
    <Compile Update="ShardManagement\Scripts.Designer.cs">
      <DesignTime>True</DesignTime>
      <AutoGen>True</AutoGen>
      <DependentUpon>Scripts.resx</DependentUpon>
    </Compile>
  </ItemGroup>

  <ItemGroup>
    <EmbeddedResource Update="ShardManagement\Errors.resx">
      <Generator>ResXFileCodeGenerator</Generator>
      <LastGenOutput>Errors.Designer.cs</LastGenOutput>
      <CopyToOutputDirectory>Never</CopyToOutputDirectory>
    </EmbeddedResource>
    <EmbeddedResource Update="ShardManagement\PerformanceCounters.resx">
      <Generator>ResXFileCodeGenerator</Generator>
      <LastGenOutput>PerformanceCounters.Designer.cs</LastGenOutput>
    </EmbeddedResource>
    <EmbeddedResource Update="ShardManagement\ReadOnlyScripts.resx">
      <Generator>ResXFileCodeGenerator</Generator>
      <LastGenOutput>ReadOnlyScripts.Designer.cs</LastGenOutput>
    </EmbeddedResource>
    <EmbeddedResource Update="ShardManagement\Scripts.resx">
      <Generator>ResXFileCodeGenerator</Generator>
      <LastGenOutput>Scripts.Designer.cs</LastGenOutput>
    </EmbeddedResource>
  </ItemGroup>

</Project>

3. Run the project from VS
4. May be you will need to regenerate resources. To do so: right click on each .resx file and select "Run custom tool".

[PraisyA]

Hello ,

I got same issue , is anybody got the solution . If you get solution please share with us .

I got below error today (after i upgraded to .NetCore2.0 ) .

Could not find any resources appropriate for the specified culture or the neutral culture. Make sure "Microsoft.Azure.SqlDatabase.ElasticScaleNetCore.ShardManagement.ReadOnlyScripts.resources" was correctly embedded or linked into assembly "ElasticScaleNetCore.Client" at compile time, or that all the satellite assemblies required are loadable and fully signed.

Thanks.