zzz projects Entity Framework 6 EF 6
Home EF Core Articles Knowledge Base Online Examples
  • Home
  • EF Core
  • Articles
  • Knowledge Base
  • Online Examples

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...
c# ef-code-first entity-framework npgsql
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 ...
c# entity-framework npgsql postgresql
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 ...
asp.net-mvc-4 c# entity-framework entity-framework-6 npgsql
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...
c# entity-framework entity-framework-6 npgsql postgresql
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...
c# entity-framework npgsql postgresql
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...
.net entity-framework-6 npgsql
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 ...
.net c# entity-framework-6 npgsql postgresql
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 ...
c# entity-framework-6 npgsql postgresql visual-studio-2015
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...
connection-string database-connection entity-framework entity-framework-6 npgsql
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...
ef-code-first entity-framework entity-framework-6 npgsql postgresql
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...
entity-framework entity-framework-6 npgsql
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..
c# entity-framework npgsql postgresql
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...
asp.net-mvc entity-framework npgsql postgresql visual-studio
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...
entity-framework-6 npgsql postgresql
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...
ado.net entity-framework npgsql postgresql visual-studio
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...
c# connection-string entity-framework-6 heroku npgsql
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...
entity-framework entity-framework-6 npgsql
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...
c# entity-framework-6 npgsql postgresql
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...
entity-framework-6 npgsql postgresql sql-server-ce visual-studio-2015
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 (??) ...
entity-framework-6 npgsql
asked by inthegarden

Page 1 of 2
  • 1
  • 2
  • »

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

EF Extensions
Try for free now
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!