Npgsql - generation ddl scripts from Entity Framework's data model

0
votes

I've crated a data model in VS 2010 and now I want to generate a DDL scripts for my PostgreSQL database. I've registered a Npgsql provider in the .NET 4.0 profile machine.config file and created proper connection string in app.config file but still I cannot find a Npgsql provider on a provider's list when I'm trying to write model to database.

Thanks in advance for any help.

2
c#entity-frameworkddlnpgsql

2 Answers

1
votes

Unfortunately, Npgsql doesn't have support for vs.net 2010 design time. You will need to use edmgen command line tool. Sorry for that... :(

0
votes

Unfortunately, I do not think that you will be able to generate a script for the database by using Npgsql.

The root of the support for creating a database script is the DbServicesProvider.CreateDatabaseScript method. However, the Npgsql implementation of the abstract class, NpgsqlServices, does not override DbCreateDatabaseScript method, which means that it cannot generate a SQL script.