EF/Postgres SQL database-first approach possible?

entity-framework postgresql

Question

After hours of searching, I am little bit disappointed. Can anybody confirm (or not) that using EF database-first approch (I mean, using the VS EDMX degigner) is possible with an existing Postgres SQL database?

Some requirements :

  • I want to use ngsql provider because it is free (but I am not sure it is working in database-first approach)
  • I don't want to use the Devart Connect provider because it is not free and it is for a personal project. I can consider the express version but I don't think it is working on design mode.

Cheers

1
3
5/6/2013 9:08:56 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Yes it is possible. A quick Google search found a walkthrough which did not suggest there were any special gotchas.

I will note I am quite sceptical of code first ORM frameworks as I think that they leave out key aspects of database design and thus encourage databases where no real planning for the future has occurred and so I think it is somewhat of a specialized tool, but the answer seems to be yes, it works.

-2
6/5/2013 2:14:06 PM

Popular Answer

This question appears on most google searches for EF Database First with Postgres and the accepted answer directs to a walk-through on CODE first not DATABASE first so I'll add a pointer to this answer which got me most of the way to solving it:

PostgreSQL data provider missing from wizard in Visual Studio 2015

Essentially there is a Visual Studio extension for postgres (simply search in the extensions and updates for Postgres) but I also had to modify the entity framework node in my app.config as it was added before I installed the extension to look like this:

  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />      
      <provider invariantName="Npgsql" type="Npgsql.NpgsqlServices, EntityFramework6.Npgsql" />
    </providers>
  </entityFramework>

This added npgsql as a data provider and after I did this the data provider appears in the EF Database first wizard as an option.

Mordy

Related Questions

From the EF Code-First DbContext class, create a SQL CE database.

I've defined a set of classes in the style of Entity Framework Code-First conventions and annotated the class properties with System.ComponentModel.DataAnnotations attributes....Now I want to generate a SQL Server Compact Edition (SCSE) (4.0) database from this code....What code is needed to do this and what assemblies need to be imported?...So far...
.net code-first ef-code-first entity-framework sql-server-ce
asked by Bent Rasmussen

Database-first strategy with EF Migrations?

We're using Database first approach with EntityFramework. We've several customers, and when we deploy new product version, we're now applying DB schema changes "manually" with tools like ...SQL Compare.......Is there a way how EF Migrations could help to apply changes to customers DB automatically?
c# database-migration entity-framework
asked by Shaddix

Mapping SQL view in code-first approach

I have a SQL view:...WITH DirectReports (ID,ParentFolderID, ParentFolderName,FolderID,FolderName,OwnerOCID,OwnerArName,OwnerEnName,FolderType,LEVEL) AS ( SELECT e.Id AS ID,cast(cast(0 AS binary) AS uniqueidentifier) AS ParentFolderID, cast('MainFolder - ' + MainFolders.enName AS nvarcha...
ef-code-first entity-framework
asked by user1924973

How to update database on remote ms sql server (EF Code First)

While developing an application I used EF automatic migrations. So now when I have deployed my app on VPS, I don't know how to add new tables and fields to my database. ...Can I connect to the remote database directly from my project in VS2012, updating a connection string, and update the database using "update-database" in package manager console?...
asp.net-mvc-4 c# entity-framework sql-server
asked by Ilya Leykin

How to use Dapper with code first?

My personal preference for the current application which I am working is to go with ORMs for this purpose....I haven't used any ORMs yet and I have little knowledge about EntityFramework. Recently I heard of Dapper and have thought of using it....My question is: is it possible in Dapper to use a code first approach to create a database from classes...
c# dapper entity-framework
asked by shanmugharaj

Share connection between DbContext objects in Entity Framework 6 Database first approach

I am trying to share a connection in between 2 different DB context objects using EF 6 . I have got the code mentioned here ...https://msdn.microsoft.com/en-us/data/dn456843.aspx... to work for a single DB Context but as soon as I try to share the connection with another DB Context object I am running into trouble. Below is what I have done so f...
c# entity-framework entity-framework-6
asked by Pratik

Entity Framework 6 Database First Approach Not Creating All Tables From SQL Server

When I create a model using the "Database First" approach in my ASP.NET MVC 5 project, not all my tables from SQL Server are created in my project....I've followed everything in this article step by step: ...https://www.asp.net/mvc/overview/getting-started/database-first-development/creating-the-web-application...ASP.NET MVC Project Model:...SQL Se...
asp.net-mvc asp.net-mvc-5 entity-framework entity-framework-6 sql-server
asked by SJCypher

How to add stored procedures to existing database model (in Code first Approach)?

I am working on a project where code first E-F was implemented but not able to access the stored procedures.How could I add them to the model now?
c# ef-code-first entity-framework-6
asked by Praveen Kumar Rejeti

Migrate EF6 database-first from SQL Server to PostgreSQL

I am looking for easy way to reuse edmx file created with EF6 over SQL Server to PostgreSQL...I have used database-first with EF6 on SQL Server and everything worked fine. We are going to use PostgreSQL. I have already migrated the database to PostgreSQL, and installed EntityFramework6.Npgsql, and I wanted use database-first approach again....I tri...
c# ef-database-first entity-framework-6 postgresql sql-server
asked by Ozzy

Convert query from SQL to Entity Framework code first approach

I want to convert my SQL query into Entity Framework code-first but unable to do it....This is my SQL query...select * from tests where id in(select testid from PatientTests where PatientId=@id) ...This is Test Model from this model I want to fetch records....public class Tests { [Key] public int Id { get; set; } [Required] [Displa...
entity-framework entity-framework-6 entity-framework-core sql-server
asked by SK jha

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow