PostgreSQL database connection in asp.net mvc and Entity Framework 6

asp.net-mvc entity-framework npgsql postgresql visual-studio

Question

I'm attempting to connect to a PostgreSQL database from my ASP.NET MVC site. The format for the view and model work for both SQL Server and MySQL, so I shouldn't have problems there, as far as I can tell.

The application is throwing a System.ArgumentException in the System.Data.dll and returns an error:

Keyword not supported: metadata" "Parameter name: keyword

on the webpage.

That it is using the System.Data.dll seems wrong, but I can't corroborate this.

How can I connect to PostgreSQL in this manner?

I have Nuget installed Npgsql 3.0.5 and EntityFramework6.Npgsql 3.0.5.

Please let me know if I left off vital information.

Relevant web.config information is as follows:

<add name="PostgreSQLConnectionString" 
     connectionString="
     metadata=res://*/Models.Test.csdl|res://*/Models.Test.ssdl|res://*/Models.Test.msl;
     provider=System.Data.SqlClient;
     provider connection string=&quot;
     data source=localhost:5432\;
     initial catalog=Test;
     integrated security=False;
     user id=username;
     password=password;
     multipleactiveresultsets=True;
     App=EntityFramework&quot;" 
     providerName="Npgsql" />

<provider invariantName="Npgsql" 
          type="Npgsql.NpgsqlServices, EntityFramework6.Npgsql">
</provider>

<remove invariant="Npgsql" />
<add name="Npgsql - .Net Data Provider for PostgreSQL" 
     invariant="Npgsql" 
     description=".Net Data Provider for PostgreSQL" 
     type="Npgsql.NpgsqlFactory, Npgsql, Version=3.0.5.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" />
1
0
4/20/2016 3:47:44 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Adding to above answer from @Ram Pukar: Make sure you define the correct table- and schema-name in your models. The default schema in Postgres is "public", whereas MsSQL (and EF) expects "dbo".

If you are using delimiter-separated words for column names, you can stop EF complaining by adding column aliases to your definiton, e.g.:

 [Table("your_table", Schema = "your_schema")]
    public class YourModelName
    {
        [Key]
        [Column("id_colum_name")]
        public int Id { get; set; }

        [Column("some_string_colum_name")]
        public string SomeString{ get; set; }
    }
 }
0
1/28/2018 3:18:29 PM

Related Questions

Entity validation best practices in ASP.NET MVC and ADO.NET Entity Framework

i am using ASP.NET MVC & ADO.NET Entity Framework in a project. I want to add validation logic to my entities via partial classes. It works similar like shown in the ...NerdDinner.com ASP.NET MVC Application... which is using LINQ2SQL. The main difference is, that i have to use the"OnPropertyChanging" event instead the "OnValidating" like in LINQ2S...
.net asp.net-mvc entity-framework validation
asked by Alexander

Should I use AutoMapper from ViewModel to Entity Framework entities in ASP.net MVC?

I am currently using AutoMapper to map my Entity Framework entities to my View Model:...public class ProductsController : Controller { private IProductRepository productRepository; public ProductsController(IProductRepository productRepository) { this.productRepository = productRepository; } public ActionResult Detail...
asp.net-mvc automapper c# entity-framework
asked by Dismissile

Entity Framework: Setting correct connection string to SQL Server Compact in ASP.NET MVC 4

I want to use and embedded SQL Server Compact edition in my asp.net mvc 4 project. I try to approaches but I have problems with any approach:...First attempt...I have created a new data connection from visual studio and from server explorer of type Microsoft SQL Server Compact 3.5 and I store the ....sdf... file in my asp.net mvc 4 project under ..
asp.net-mvc-4 embedded-database entity-framework sql-server-ce
asked by Ralph

Does new ASP.NET MVC identity framework work without Entity Framework and SQL Server?

I am new to ASP.NET MVC 5 and so I am trying to use it as much as possible to learn it by practice. ...So I am thinking of using the new OWIN implementation of ASP.NET MVC to implement the authentication and authorization of my project. That said, I am building the project in a way that it can work with various types of databases. ...So far I have ...
asp.net-mvc-5 entity-framework owin sql-server
asked by Aref

ASP.NET MVC Entity Framework 6 Navigation Property not saving on SaveChanges() Repository Pattern on Edit

I am having a strange problem where a navigation property is not persisiting on the Update of a page, but is on a Create. I am using a Generic Repository pattern with Entity Framework 6, ASP.NET MVC 5....Here's the skeleton code:...My context:...public class ApplicationDbContext : IdentityDbContext<ApplicationUser> { public ApplicationDbContext...
asp.net asp.net-mvc-5 c# entity-framework-6 repository-pattern
asked by Rhys Stephens

Delete row ASP.NET MVC ADO.NET entity Model

I'm kinda newbie with asp.net MVC environment...i'm trying to delete ROW from 3 table/entity(cause i'm using ado.net entity data model to generate the database automatically) the problem is when my delete function is executed only ROW from 1 table is deleted.....PS: i've also already create the relationship between 3 table...here is my controller:....
ado.net asp.net asp.net-mvc c# entity-framework
asked by user3848402

Store JSON data object to database in ASP.NET MVC (Entity Framework)

I have JSON data like this one:...{ "id":"", "firstName":"John", "lastName":"Doe", "phones":[ { "value":"555-555-555", "$$hashKey":"object:8" }, { "value":"444-444-444", "$$hashKey":"object:10" } ], "emails":[ { "value":"example@mail.com", "$$hashK...
asp.net asp.net-mvc c# entity-framework json
asked by jureispro

Is ASP.NET MVC 6 framework/ Entity Framework 7 out?

I am trying to learn asp.net MVC. I have been reading tutorials about ASP.NET MVC 5. However, I see a lot of challenges with the framework. However, I heard there are better feature/architecture in ASP.NET MVC 6....Is ASP.NET MVC 6/ Entity Framework 7 out? If not, what is it the release date?
asp.net asp.net-mvc-5 c# entity-framework
asked by Jaylen

Populate DropDownList in ASP.NET MVC from database table using Entity Framework 6 and ViewModel

I have been scratching my head for a whole night on an issue I can do quickly using ajax/jquery and stored procedures. I want to ...1) Populate a drop down list from values obtained from a database table using Entity Framework and view model. I DO NOT WANT TO USE VIEWBAG OR VIEWDATA. Any help appreciated....2) How can I generate a Create View using...
asp.net-mvc dropdownlistfor entity-framework razor viewmodel
asked by TropicalViking

PopUp not sending data in database in ASP.NET MVC 5 and Entity Framework

The popup code works just fine but after I add the credentials and click on the submit button to create the record nothing happens. I'm new to ASP.NET MVC 5 and Entity Framework 6. Any guidance will be most appreciated. ...@model IEnumerable <LogInTest1.Models.Credentials> @{var createModel = new LogInTest1.Models.Credentials();} @* I think I didn...
asp.net-mvc-5 c# entity-framework-6 popup
asked by Khwaja Hussam Quasmi

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