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

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...
entity-framework entity-framework-6 mysql mysql-connector
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"); ..
asp.net c# entity-framework entity-framework-6 mysql
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:... ...
entity-framework entity-framework-6 mysql
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...
asp.net-identity ef-code-first entity-framework entity-framework-6 mysql
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...
asp.net c# entity-framework entity-framework-6 mysql
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...
concurrency entity-framework entity-framework-6 mysql
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...
c# entity-framework entity-framework-6 mysql
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...
c# entity-framework entity-framework-6 mysql mysql-connector
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...?
entity-framework entity-framework-6 mysql
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...
entity-framework entity-framework-6 entity-framework-6.1 mysql
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...
c# entity-framework entity-framework-6 mysql
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...
asp.net-core entity-framework-core mysql mysql-connector
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...
c# entity-framework entity-framework-6 mysql
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...
entity-framework entity-framework-6 entity-framework-core mysql
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...
entity-framework entity-framework-6 mysql
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...
asp.net-core entity-framework entity-framework-6 mysql
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...
c# entity-framework entity-framework-6 migration mysql
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...
c# ef-code-first entity-framework entity-framework-6 mysql
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...
entity-framework entity-framework-6 mysql strong-typing
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...
asp.net-mvc ef-migrations entity-framework entity-framework-6 mysql
asked by yohnerj

Page 1 of 6
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • ยป

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
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!