CODEWITHSUNDEEP
c#entity-frameworkddlnpgsql
krlm
krlm

Reputation: 837

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

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.

Upvotes: 0

Views: 1019

Answers (2)

Jean Hominal
Jean Hominal

Reputation: 16796

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.

Upvotes: 0

Francisco Junior
Francisco Junior

Reputation: 2016

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

Upvotes: 1

Related Questions