CreateDatabase

[-arno-]

Hello,
i have dowloaded the dotConnect for postgreSQL trial version 5.00 beta, in order to test the Entity Framework link. Some methods are not working (tried also in 4.95) :
- MyContext.DataBaseExists returns true while database does not exists
- MyContext.CreateDatabase throws an error saying that my database does not exists (yes, i want to create it )
I tried the same code using your dotConnet for MySQL, and it's working great.
If i create manually the database, and create the sql script to fill the database table, then the link is working, but i need the dynamic creation to work.
(another problem : the SQL script generated is not ok on a newly created database : the "DROP CONSTRAINT" lines are not accepted by postgresql if they do not exists.)


My PostgreSQL version is 9.0.1, i am using Visual studio 2010, EF and c# 4.0 and windows 7.

Am i missing something ? Where could i tweak something ?

Thank you for any help

[AndreyR]

As for the DatabaseExists method, it is a designed behaviour at the moment.
We will investigate the situation with the CreateDatabase method.
I will let you know about the results of our investigation.

[AndreyR]

We have implemented the CreateDatabase method in the latest build.
Please let us know if anything goes wrong.

[-arno-]

I've downloaded the last version (5.00.86 12-Jan-11).
The only change i've found is that the DatabaseExists returns true when the database exists, but it now throws an exception if the database does not exists.
The createDatabase still throws an exception when the database does not exists (works well only to create the structure).
Thanks to help me....

[AndreyR]

We will investigate the possibility to make some changes in this functionality.
I will let you know about the results of our investigation.

[AndreyR]

The latest Beta build provides a possibility to create a schema.
It can be downloaded from here (Trial version) or from Registered Users' Area.