EnsureCreated fails with CosmosDB if Scale not set

[SamueleFurnari]

If you want to use the EnsureCreated with a CosmosDB provider, the request fails with a generic 400 - BadRequest if the Cosmos instance does not have Scale setted.

To reproduce this, try to create a CosmosDB Database with Provision throughput unselected and in your code (for example in the Configure method of Startup class, try to execute the code:

dbContext.Database.EnsureCreated();

If you create the database with the Provision throughput selected and configured, the ensure works as expected.

EF Core version:
Database provider: Microsoft.EntityFrameworkCore.Cosmos v.5.0.10 and 5.0.12
Target framework: .NET 5.0
Operating system: Windows 10
IDE: Visual Studio 2019 16.11.7

[ajcvickers]

/cc @AndriySvyryd

[AndriySvyryd]

We might be able to throw a better exception message.

@SamueleFurnari In 6.0 we added methods on EntityTypeBuilder to configure the provisioned throughput on the associated container: HasManualThroughput and HasAutoscaleThroughput

[SamueleFurnari]

@AndriySvyryd thank you. Currently I'm using the v.5.0.10.0 that if I understand well, does not have a way to manage the autoscale throughput.

If I want to maintains the actual EF version, the only way to be sure that EnsureCreated works, is to be sure that the database has the throughput set. Is this correct?

Thank you!

[AndriySvyryd]

@SamueleFurnari Yes or let EF create the database.