EFCore: DbContext.Database.EnsureCreated() can't create Database

[dresel]

Hi,

I'm using 7.6.763.0 of dcpostgresql76pro.

DbContext.Database.EnsureCreated() throw an "Database 'test' does not exist." exception instead of creating the database.

Code: Select all

	class Program
	{
		static void Main(string[] args)
		{
			var context = new MyDbContext();
			context.Database.EnsureCreated();
		}
	}

	public class MyDbContext : DbContext
	{
		protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
		{
			optionsBuilder.UsePostgreSql(@"Host=localhost;User Id=postgres;Password=postgres;Database=test;Unicode=true;");
		}
	}

[Shalex]

Please turn on the following option and try again:

Code: Select all

            var config = Devart.Data.PostgreSql.Entity.Configuration.PgSqlEntityProviderConfig;
            config.DatabaseScript.Schema.DeleteDatabaseBehaviour = Devart.Data.PostgreSql.Entity.Configuration.DeleteDatabaseBehaviour.Database;

For more information, refer to https://www.devart.com/dotconnect/postg ... ation.html.

[dresel]

Well I was trying the http://blog.devart.com/entity-framework ... 1479454278 blog post, there it says:

Additionally, our providers support only a part of provider configuration settings. For example, for config.DatabaseScript.Schema.DeleteDatabaseBehaviour setting, only the DeleteDatabaseBehaviour.ModelObjectsOnly value (default value) is supported.

Did you try your solution? Maybe I did something wrong, but

Code: Select all

		static void Main(string[] args)
		{
			var config = Devart.Data.PostgreSql.Entity.Configuration.PgSqlEntityProviderConfig.Instance;
			config.DatabaseScript.Schema.DeleteDatabaseBehaviour = Devart.Data.PostgreSql.Entity.Configuration.DeleteDatabaseBehaviour.Database;

			var context = new MyDbContext();
			context.Database.EnsureDeleted();
			context.Database.EnsureCreated();
		}

still does not work.

[Shalex]

Your remark is correct, sorry for my mistake.

DeleteDatabaseBehaviour.Database is currently not supported for EF Core. We will notify you when the corresponding feature is implemented.

[Shalex]

The config.DatabaseScript.Schema.DeleteDatabaseBehaviour option is supported in EF Core: viewtopic.php?f=3&t=34690.