Entity Framework 6 - Knowledge Base (KB)

ADO.Net Entity framework, Fatal error encountered during data read

I am getting the following error while using MySql with Entity framework. I have set the default connection timeout to 300000 on the connection string of EntityConnectionStringBuilder. How to resolve this in Entity framework?... Unhandled Exception: Sy...

EntityFramework 6 Alpha 2 & MySQL Connector/NET 6.6.4

The 6.6.4 MySQL .NET connector apparently has support for EF6. I've upgraded from EF5 and .NET 4 to EF6 alpha2 and .NET 4.5. I've recreated the ADO.NET Entity Data Model since upgrading....Upon doing anything to the database it throws up an exception mess...

Is the MySQL Entity Framework Connector Incompatible with OrderBy()?

I'm using the MySQL Entity Framework Connector to connect to my MySQL Database....Is it compatible with any order by functionality? Whenever I remove ....OrderBy()... from the code below, it works fine, but with it I get an error....using Microsoft.AspNe...

Can't Create Entity Data Model - using MySql and EF6

I'm trying to add an edmx Entity model to my C#/Web Project in Visual Studio 2013. My problem is that the file is not created....I do the following steps:...Give the item a name...Choose 'EF Designer from database'...Choose the connection from the drop do...

Unable to update EntityFramework models from MySQL database in Visual Studio 2015 RC

My organization upgraded from Visual Studio 2013 to Visual Studio 2015 RC a couple months ago, and we only just now attempted to update some of our existing "db-first" EntityFramework models from our MySQL database. When doing so, we received the followin...

error 0004: Could not load file or assembly 'MySql.Data.Entity, Version=6.9.7.0

I built an ASP.NET application using MySQL database. On my pc development server it works perfectly but gives the following error on host/production server...Error 0004: Could not load file or assembly 'MySql.Data.Entity,... Version=6.9.7.0, Culture=neu...

Unknown column in field list - After MySQL changes

I have a query which pulls some data after making a couple of joins, this worked fine when the application used SQL Server. However after making the transfer to MySQL I'm having some issues. ...For example I keep getting the error 'Unknown column Extent.G...

"Error ... Could not load file or assembly 'MySql.Data.Entity.EF5, Version=6.9.9.0 ..."

In fact, I wanted ...MySql.Data.Entity.EF6..., however, for some reason Visual Studio ADO EDMX editor wanted ...MySql.Data.Entity.EF5... (same version, 6.9.9.0)....First, I checked if the NuGet packages 'MySql.Data' and 'MySql.Data.Entity' were installed....

Type is not resolved for member 'MySql.Data.MySqlClient.MySqlException,MySql.Data, Version=6.9.9.0,

I use EntityFramework(v.6.0.0.0) code first. .Net framework 4.6.01586. MySQL connector Version=6.9.9.0. MySQL server version = '5.5.28' .When I try to "update-database" i get this error "...Type is not resolved for member 'MySql.Data.MySqlClient.MySqlExce...

Why does EntityFramework Raw SqlQuery returns objects from MySql with undesired values?

When I am running a RawSqlQuery against a DBContext to get a List Objects from a MySql database, the objects are not being returned with their real values in database. All objects in the list are having default values for all the properties after query...

Entity framework with mysql database migrations fail, when creating indexes

what causes this error in MySQL with entity framework? I can generate the migration script and connect to the database but it doesn't like the SQL generated particularly "hash" when trying to create indexes....Example:...CREATE index `IX_Facility_ID` on ...

Using Entity Framework with Multiple Databases and Providers in the Same Project (SQL Server and MySql)

Background:...I have an application (both web forms and console) that easily accesses multiple SQL Server databases using Entity Framework code first with no problems. I can switch back and forth between contexts with no errors. Now I'm trying to add in a...