Unable to connect to Azure Cosmos Db Account (Core SQL API) using EF Core 3.0 CosmosDb provider

.net-core-3.0 azure-cosmosdb azure-cosmosdb-sqlapi entity-framework-core entity-framework-core-3.0

Question

I'm unable to connect to an Azure CosmosDB with the CosmosDb provider using the following packages:

Microsoft.EntityFrameworkCore 3.0.0 Microsoft.EntityFrameworkCore.Cosmos 3.0.0

Getting this message back:

Response status code does not indicate success: 503 Substatus: 0 Reason: (The request failed because the client was unable to establish connections to 3 endpoints across 1 regions. Please check for client resource starvation issues and verify connectivity between client and server.

Stacktrace

at Microsoft.Azure.Cosmos.ResponseMessage.EnsureSuccessStatusCode() at Microsoft.Azure.Cosmos.CosmosResponseFactory.ToObjectInternal[T](ResponseMessage cosmosResponseMessage, CosmosSerializer jsonSerializer) 
at Microsoft.Azure.Cosmos.CosmosResponseFactory.<>c__DisplayClass6_0.<CreateDatabaseResponseAsync>b__0(ResponseMessage cosmosResponseMessage) 
at Microsoft.Azure.Cosmos.CosmosResponseFactory.<ProcessMessageAsync>d__121.MoveNext()
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Microsoft.Azure.Cosmos.CosmosClient.<CreateDatabaseIfNotExistsAsync>d__40.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1.ConfiguredTaskAwaiter.GetResult()
at Microsoft.EntityFrameworkCore.Cosmos.Storage.Internal.CosmosClientWrapper.d__13.MoveNext()
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Microsoft.EntityFrameworkCore.Cosmos.Storage.Internal.CosmosClientWrapper.CreateDatabaseIfNotExistsOnce(DbContext context, Object state) 
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementation[TState,TResult](Func3 operation, Func3 verifySucceeded, TState state) 
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded) 
at Microsoft.EntityFrameworkCore.Cosmos.Storage.Internal.CosmosClientWrapper.CreateDatabaseIfNotExists() at Microsoft.EntityFrameworkCore.Cosmos.Storage.Internal.CosmosDatabaseCreator.EnsureCreated() 
at Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade.EnsureCreated() at EFCoreCosmosDbTest.Test.<Run>d__0.MoveNext() in C:\Git\EFCoreCosmosDbTest\EFCoreCosmosDbTest\Test.cs:line 26 
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at EFCoreCosmosDbTest.Program.<Main>d__0.MoveNext()
in C:\Git\EFCoreCosmosDbTest\EFCoreCosmosDbTest\Program.cs:line 9

If I change to the Microsoft.Azure.DocumentDB.Core 2.8.1 and use the DocumentClient I have no issues connecting to the same CosmosDb account in Azure and create my database, container etc. from the same solution.

Also, if I download the .net core quickstart project from Azure, it works without issues.

Note, that It works fine connecting to a the Azure Cosmos Db Emulator locally with EF.

I used the https://github.com/aspnet/EntityFramework.Docs/tree/master/samples/core/Cosmos repo to run the test.

Any ideas what I'm doing wrong?

  • EF Core version: 3.0
  • Database provider: Microsoft.EntityFrameworkCore.CosmosDb
  • Target framework: .NET Core 3.0
1
0
10/18/2019 8:40:44 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

The EF Provider is using the Cosmos SDK package underneath.

enter image description here

Please add the Microsoft.Azure.Cosmos package to your project targeting the latest version (3.2.2).

You can do this through the NET Core CLI by running dotnet add package Microsoft.Azure.Cosmos on the folder with your current project files, and it should update your CSPROJ with the PackageReference.

0
10/18/2019 2:37:48 PM

Related Questions

NotImplemented Exceptions using MySQL Provider in ASP.NET Core With EF Core

I am building an ASP.NET Core 1.1.0 application that needs to access an existing MySQL database using Entity Framework Core, which I'm building in Visual Studio 2015 with all the latest updates. I started using the "official" MySQL provider (MySql.Data.EntityFrameworkCore), but have the same problem with the Pomelo prvider (Pomelo.EntityFrameworkCo...
asp.net-core c# entity-framework-core mysql
asked by RiverRunner

Connect to Azure SQL server via AAD Authentication using EF Core

Azure SQL servers support AAD authentication, and I want my applications to connect to SQL server using AAD authentication and not SQL server admin credentials. I am using EF core to connect to SQL, how do I enable EF Core to use AAD authentication....My application is deployed in Azure App Service and it has MSI extension enabled, so I am looking ...
azure-active-directory azure-sql-database azure-sql-server azure-web-sites entity-framework-core
asked by Pratik Bhattacharya

Cosmos DB provider in Entity Framework Core throwing 400 BadRequest

I've integrated Cosmos DB in my ASP.NET Core API project, using the latest EF Core package that ships with a Cosmos DB provider....I'm able to successfully use this provider when running locally in my local ASF cluster, connecting to a local Cosmos DB emulator instance. However, when trying to either run in local ASF or Azure-hosted ASF, I'm unable...
azure-cosmosdb azure-cosmosdb-sqlapi c# entity-framework-core
asked by Mortana

Default Azure SQL DB pricing when created automatically through EF Core

We have a web app that uses Entity Framework Core. If it is given a connection string to a database on Azure that doesn't exist, calling ...dbContext.Database.Migrate()... will create it automatically. This is great for our development branches as we call it with a connection string with a database name equal to the branch name and it creates the A...
azure azure-sql-database entity-framework-core
asked by zola25

Exception with owned collections with EF Core and CosmosDB provider

I have an Entity Framework Core context with CosmosDB provider and only one entity:...public class Entity1 { public Guid Id { get; set; } public List<Item> Items { get; set; } } ...here are the inner objects of the entity:...public class Item { public Guid Id { get; set; } public List<SubItem> SubItems { get; set; } } public clas...
.net-core azure-cosmosdb c# entity-framework-core
asked by aperezfals

How to set Azure Sql Service Tier when creating DB via EF Core EnsureCreated?

When I use the Entity Framework Core EnsureCreated to automatically generate my Azure Sql Database it sets the service tier of the database to be an expensive tier by default....How do I force the database to be created using the Basic service tier?...I found an example for but it doesn't apply to EF for .NET Core.
azure-sql-database entity-framework entity-framework-core
asked by PatrickNolan

EF Core 2.1 Linq Query to EF Core 3.0

I am dealing with a query that i cannot get to work on ef core 3.0 and it worked fine in the 2.1 version, i would like if anyone can help figure how i can get it work in the 3.0 version....So let me start with the challenge. ...i have a table that is named Zone and it has a one to many relationship to a table called Bin, and bin has a one to many r...
c# ef-core-3.0 entity-framework entity-framework-core linq
asked by Sol Stein

Error while using CosmosDB provider for Entity Framework Core with Azure Tables

I'm trying to do a simple CRUD application with EF Core and Azure Table (from Azure Storage Account)....I'm passing name of the storage account as database name (The docs aren't exactly clear on that)...services.AddDbContext<HomioDbContext>(options => options.UseCosmos( "https://homiostorage.table.core.window...
.net-core azure azure-cosmosdb c# entity-framework-core
asked by Pratik

Unable to connect to Azure Cosmos Db Account using Microsoft.EntityFrameworkCore.Cosmos - Response status code

The CosmosDb provider is sending this message:...“Response status code does not indicate success: 503 Substatus: 0 Reason: (The request failed because the client was unable to establish connections to 3 endpoints across 1 regions. Please check for client resource starvation issues and verify connectivity between client and server.”...In my test...
azure azure-cosmosdb entity-framework-core
asked by Luis Augusto Barbosa

EF Core Cosmos DB with Azure Table Storage

Since Microsoft recently have merged Azure Table Storage namespaces and api with Cosmosdb, I thought it would be possible to use Entity Framework Core Cosmos with Azure Storage Tables.. only I'm not able to provide a database name in the configuration:...protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) => optionsBuilder...
azure azure-cosmosdb azure-table-storage entity-framework-core
asked by Morten_564834

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow