Entity Framework 6 - Knowledge Base (KB)
34 results in tag: npgsql
npgsql and Entity Framework code first setup problems
The most recent error im getting is...ERROR: 42P01: relation "dbo.__MigrationHistory" does not exist ...but im convinced that this is just because something earlier hasnt been set up properly....Im currently trying to set up entity framework 4.4 code firs...
asked by Ankou
Using npgsql 12 and ef 6 together - have anyone succeeded with it?
I'm trying to create a small POC for my boss about the hybrid of npgsql 12 and ef6, created a new project on visual studio created a sample database created the corresponding classes and the dbcontext yet, whenever I try and use ef to access the database ...
asked by Koby Yehezkel
Error when executing SaveChanges() with key field on Npgsql
I have a problem with my ...Npgsql... model when execute ...SaveChanges... method from a DbContext: ... A null store-generated value was returned for a non-nullable member 'Id' of type 'Easylab.DAO.Contextos.LogCad'. ...Maybe ...Npgsql... doesn't ...
asked by GustavoAdolfo
Trying to using EF 6 with PostgreSQL - Failed to find or load the registered .Net Framework Data Provider
I am trying to use EF 6 Code First with Npgsql provider. When I try to run Add-Migration command in package manager I have the following exception: ...Failed to find or load the registered .Net Framework Data Provider....PM> Add-Migration -Force -Configur...
asked by Don Tomato
npgsql 2.1.3 and EF 6: Could not determine storage version; a valid storage connection or a version hint is required
I'm adding the support to EF 6 to my sql generator for PostgreSQL: ...PostgreSQL Migration Generator...I have created a test project to try it but when I create a new connection ...return new NpgsqlConnection();..., it throw this exception to me:...An exc...
asked by Darion Badlydone
Is it possible to configure a custom provider for migrate.exe without using the machine.config
I am trying to setup automated migrations using migrate.exe that is provided in the EntityFramework v6 nuget package. My application uses a PostgreSQL database and uses a custom database provider (Npgsql), which requires additional configuration for Entit...
asked by matthewrwilton
Cannot generate C# class from PostgreSQL view using Npgsql + EF6 code first
I am trying to use entity framework code first method to connect to PostgreSQL database, and when I use entity data model wizard in visual studio to generate C# class from database, it can generate classes for each table in database successfully, but the ...
asked by TerryLi
postgresql does not appear in Data Source when generating .ADO.net Entity Data Model
I succeeded in accessing an existing postgresql dbase by using npgsql directly. I used for this: ...PostgreSQL 9.0.10 (32 bit)...Visual Studio 2015 Community (64 bit) ...NpgSql 2.2.5 (through Manage Nuget Packages)...The dbase however has 25+ tables ...
asked by mcCfq4
Entity Framework 6 Programmatically Connect to Postgres
I'm working on programmatically establishing a connection to PostgresSQL using Entity Framework 6. I have this class:...public class ClearspanDatabaseContext : DbContext ...with this constructor:...public ClearspanDatabaseContext() : base(buildConnect...
asked by Nick Gilbert
Configuring EF and Npgsql for code first
I'm trying to get EF to work with Postgresql. I would like code-first migrations if possible. So far, I got a simple ADO command to work, so I'm pretty sure at least my connection string is right. But I can't get EF code migrations to work for the life of...
asked by Sava B.
NpgSQL 3 Code First Connection String
I am trying to setup a project with EF6 and NpgSQL 3.x...I took the following steps:...Used Nuget to install Entity Framework 6...List item...Add connections string to .config file using syntax described here: ...http://www.npgsql.org/doc/connection-strin...
asked by Element
Postgresql and Entity Framework
In my project I am trying to use Entity Framework along with PostgreSql. But I am not able to connect to my database. I am not getting any error, it just gets stuck. I think something is wrong with my ...app.config..., but I am not able to find out what..
asked by N.J
PostgreSQL database connection in asp.net mvc and Entity Framework 6
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.Argument...
asked by Kamurai
Query PostgreSQL with Npgsql and Entity Framework using unaccent
Is possible to use Npgsql and Entity Framework 6 for query PostgreSQL ignoring accents? In play SQL it's possible to use the unaccent extension and could be indexed with a index also based in unaccent:...select * from users where unaccent(name) = unaccent...
asked by Max Bündchen
How to install Npgsql as a data provider for ADO.NET Entity Framework?
I have read all that I can find, but no luck. In Visual Studio 2015 Community, here is what I did (with no luck):...Ran: Setup_NpgsqlDdexProvider. This installed Npgsql 3.0.7 and EntityFramework 6.0.0. It also installed Npgsql 3.0.7 in the GAC and the mac...
asked by Alan Wayne
Entity Framework 6 - Npgsql - connection string error
A tricky (and frustrating problem) - perhaps you folks may be clever enough to solve it:...Problem...I want to be able to read/write to my database using Entity Frameworks. I have got a simple app rails running on Heroku (straightforward scaffold). I want...
asked by BKSpurgeon
npgsql - stop using 'template1' database
I want to use elephantsql database with entity framework (whichever version). I found tutorial on the internet about npgsql which can help me connect those 2 piece of technology....I made an object which will represent object from DB :...[Table("typychoro...
asked by Shoter
Postgresql npgsql first connection takes too long
I am new to Postgresql. I am tring to use Postgresql with entity framework6, using npgsql....I already have a database. I am using "Code First form database" option....The problem is that the first time a query is executed, it takes me lots of time to exe...
asked by bruno.almeida
PostgreSQL data provider missing from wizard in Visual Studio 2015
I've spent a day trying to migrate an Entity Framework 6 SQL Server CE to PostgreSQL....I've copied the database over fine, but I can't seem to get the data provider to work....Firstly I tried the older 2.2.7 version of the EF provider, which doesn't requ...
asked by Nintynuts
EF6 + NPGSQL - App.Config Settings - Provider with invariant name 'Npqsql' is either not registered etc. etc
Visual Studio 2015 / .NET Framework 4.5...EntityFramework v6.1.3...EntityFramework6.Npgsql v3.1.0...Npgsql 3.2.2...I have inherited a project which contains and EDMX EF6 model which I cannot open in Visual Studio (although the code runs OK) possibly (??) ...
asked by inthegarden
