Can't create a database with automatic migration

[t_suzuki]

I use the "MigrateDatabaseToLatestVersion".
In this case, it is necessary to create database in advance?

Or, Require connectionString of multiple to create database?


from the state of only postgres database:

Code: Select all

  <connectionStrings>
    <add name="MyContext"
         connectionString="User Id=postgres;Password=pass;Host=localhost;Database=sample1;Unicode=True;Character Set=UTF8;Initial Schema=public"
         providerName="Devart.Data.PostgreSql" />
  </connectionStrings>

Code: Select all

public class MyContext : DbContext
{
...

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

config.Workarounds.IgnoreSchemaName = true;
config.Workarounds.IgnoreDboSchemaName = true;


Database.SetInitializer(
    new MigrateDatabaseToLatestVersion<MyContext, Migrations.Configuration>());

config.DatabaseScript.Schema.DeleteDatabaseBehaviour
    = Devart.Data.PostgreSql.Entity.Configuration.DeleteDatabaseBehaviour.AllSchemaObjects;

MyContext context = new MyContext();
if (!context.Database.Exists())
{
    context.Database.Create();  // <<--System.Data.Entity.Core.ProviderIncompatibleException
}

InnerException: {"database \"sample1\" does not exist"}

[Shalex]

Please use DeleteDatabaseBehaviour.Database instead of DeleteDatabaseBehaviour.AllSchemaObjects (documentation). Does this help?

[t_suzuki]

I changed to DeleteDatabaseBehaviour.Database.
Is Another issue.

InvalidOperationException: Unexpected server type 'a'.

Code: Select all

at System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)
   at System.Data.Entity.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection)
   at Devart.Data.PostgreSql.Entity.ao.b(Version A_0)
   at Devart.Common.Entity.b5.d(Version A_0)
   at Devart.Common.Entity.b5.g()
   at Devart.Data.PostgreSql.Entity.PgSqlEntityProviderServices.GetDbProviderManifestToken(DbConnection connection)
   at System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)</StackTrace><ExceptionString>System.InvalidOperationException: Unexpected server type 'a'.
   at Devart.Data.PostgreSql.Entity.ao.b(Version A_0)
   at Devart.Common.Entity.b5.d(Version A_0)
   at Devart.Common.Entity.b5.g()
   at Devart.Data.PostgreSql.Entity.PgSqlEntityProviderServices.GetDbProviderManifestToken(DbConnection connection)
   at System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)

PostgreSQL 9.5.3 x86 Windows (Default Settings)
EF 6.1.1
dotConnect for PostgreSQL 7.3.254


I'll try to go in the program outside Create Database.

Thanks.

[Shalex]

We have reproduced the issue. We will notify you when it is fixed.

[Shalex]

The bug with throwing "Unexpected server type 'a'" error when using DeleteDatabaseBehaviour.Database in the Code-First functionality is fixed in the latest (7.3.264) build of dotConnect for PostgreSQL.

It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=3&t=30560.

[t_suzuki]

Thank you support Code-First.

Database has been created. I expected.