Entity Framework Core - Knowledge Base (KB)
119 results in tag: mysql
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...
asked by pierce
Dynamic MySQL database connection for Entity Framework 6
I wish to pass a dynamic connection string to the entity framework context. I have over 150 schemas which are identical (one per account) and I would like to select the connection as such:...ApplicationDbContext db = new ApplicationDbContext("dbName"); ..
asked by francisco.preller
EF6+MySQL - Error inserting 2 related objects in a single SaveChanges
I am using EF6 and MySql and attepting to insert two new, related objects Client and Quote (where Quote has a Client) in a single call to save changes. This should map to an insert to the the client table and an insert to the quote table. Code is:... ...
asked by Sam Sippe
ASP.NET-Identity limit UserNameIndex length
How can I limit the UserNameIndex UNIQUE index in the table AspNetUsers?...I am using ASP.NET Identity with a Mysql backend and am running up against another instance of:...Index column size too large. The maximum column size is 767 bytes. ...I have tried...
asked by user1690921
Entity Framework 6 with Mysql and NullReferenceException
When I try to insert same data I am getting NullReferenceException exception....I have read tons of posts in Stackoverflow, asp.net forums and mysql community forums. I could not found any true solution for this problem. There is a lots of answer about t...
asked by Dreamcatcher
DbUpdateConcurrencyException using Entity Framework 6 with MySql
I'm having trouble with concurrency checks using EF6 and MySQL....The problem I'm having is that I get a concurrency exception thrown when I try to save data to the database. If you examine the sql that is output to the console it tries to query the conc...
asked by Rossco
Specified key was too long; max key length is 767 bytes Mysql error in Entity Framework 6
I have start working on Asp.net Mvc-5 application using visual studio 2012. So I have downloaded Entity Framework-6 and MySQL 6.8.3.0 from nuget. When I tried to create database by using db Context command...dbContext.Database.CreateIfNotExists(); ...This...
asked by Shoaib Ijaz
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...
asked by Luke
How to use unsigned int / long types with Entity Framework?
Class properties with the ...long... data type are properly mapped when adding a new migration (code-first), but ...ulong... data types are skipped by mysql's EF provider. How does one map a property to use mysql's ...unsigned bigint...?
asked by arao6
Migration to MySQL and Schema specified is not valid
I have migrated SQL2012 Database to MySQL, apart from one issue....I get the following error when I connect to the MySQL Database....An exception occurred while initializing the database. ...InnerException for details: Schema specified is not valid. Erro...
asked by RentUrApp
Table 'DBNAME.dbo.TableNAME' doesn't exist Entity Framework 6 with MySQL
I am using Entity Framework 6.0.0 with MySql Server 5.6.17...I have added MySql.Data.Entities through nuget and it installed Entity Framework 6.0.0 and MySql.Data 6.8.4...Everything was setup perfectly and working fine with some of my Business Entities. i...
asked by Arjun Vachhani
ASP.NET 5 / MVC 6 with MySQL database
I have plans to build an MVC 6 website which will be hosted on Linux, and I am currently in the initial testing phase to see how the new ASP.NET 5 (vNext) and MVC 6 work and whether I can deploy everything on Linux. ...My website must make use of a databa...
asked by Nick Thissen
how to use canonical functions in Entity Framework and Mysql
I want to add Timespan to DateTime in EntityFramework with MySql Database....i have tried using ...DbFunctions.AddMinutes(someminutes)... and ...EntityFunctions.AddMinutes(someminutes)... but when i execute i get exception something like ...FUNCTION proje...
asked by Arjun Vachhani
What happened to System.Data.Entity.DbConfiguration class in EF7
I am trying to add the MySQL Connector/Net provider for EF7: using one of the following. But ...System.Data.Entity... does not have a class ...DbConfiguration... in EF7. Has this class been moved or am I expected to do something different to add the MyS...
asked by grldsndrs
Entity Framework + MySql + Guid error
I am using Entity Framework with MySql....I have problems inserting items in Database using Guid properties....The error i get is: ...Incorrect string value: '\x9D?Z\xC2\x1C\xB2...' for column 'Id' at row 1...If i change the property Id from ...Guid... to...
asked by Catalin
How do I use Entity Framework 6 with MySQL in ASP.NET 5?
I have an existing site that uses ASP.NET MVC 4, Entity Framework 6 and MySQL. I'm trying to upgrade it to ASP.NET 5, but want to continue using Entity Framework 6 as Entity Framework is missing some features and does not yet support MySQL. How do I use E...
asked by Daniel Lo Nigro
Entity Framework Code First Migration in MySql DataBase
I create code first model using entity framework and after install first version to client we found some change in columns of database , I use migration of Entity Framework and you apply all steps of migration bat the data base of client not exist rows of...
asked by Iskandar Enuml
entity framework 6 mysql rowversion
I am using entity framework 6 with my sql and seems like row version byte array is not supported by mysql. any help how this can be achieved....[Column(TypeName = "timestamp")] [DatabaseGenerated(DatabaseGeneratedOption.Computed)] public DateTime TimeStam...
asked by Ajay Kumar
Entity Framework 6 and mysql TableDetails Strong typing exception
I am trying to generate my model classes from a mysql database schema, with EF6. I use the ado.net wizard database first approach and I get an exception that says :...Unexpected exception occured when generating the model. StrongTypingException:the valu...
asked by Theodora Tzalla
Force engine=innodb when using Entity Framework Code First with mysql
I have created a new .NET MVC 5 web application using Entity Framework 6 and a msyql database. I am using code/model first. The database server has a default storage engine of MyISAM, but I would like for the tables that EF creates to be InnoDb. Does a...
asked by yohnerj