EF6 MySql - All parts of a key must be non-nullable

entity-framework-6 mysql

Question

So this is a new error that just start coming up for me and I'm not sure why. When I try to add a table through EF6, I get the following errors on any fields that are non-nullable. On tables that I have been able to add, if I open the edmx file in XML, I can see that the [Key] section for each table in the StorageSection contains every field in the table. So this is clearly a bug somewhere, but I'm not sure where.

I've done the following: - Double-checked my data model in MySql (using version 5.7.7) - Uninstalled and reinstalled Visual Studio 2015 - Uninstalled and reinstalled Entity Framework (version 6.1.3) - Using the Devart dotConnect MySql Pro Trial (version 8.6.677.0) - Double-checked all web.config options to make sure they are correct.

Sample Error: Error 13101: Key part 'LockOutEndDateUtc' for type 'aspnetusers' is not valid. All parts of the key must be non-nullable. HRSMonitor C:\Users\Kevin\Documents\Visual Studio 2015\Projects\HRSMonitor\HRSMonitor\Models\dbHRS.edmx

Here's the create table script for the aspnetusers table:

'aspnetusers', 'CREATE TABLE aspnetusers ( Id varchar(128) NOT NULL, Email varchar(256) DEFAULT NULL, EmailConfirmed tinyint(4) DEFAULT NULL, PasswordHash varchar(21000) DEFAULT NULL, SecurityStamp varchar(21000) DEFAULT NULL, PhoneNumber varchar(21000) DEFAULT NULL, PhoneNumberConfirmed tinyint(1) DEFAULT NULL, TwoFactorEnabled tinyint(1) DEFAULT NULL, LockOutEndDateUtc datetime DEFAULT NULL, LockoutEnabled bit(1) DEFAULT NULL, AccessFailedCount int(11) DEFAULT NULL, UserName varchar(256) NOT NULL, PRIMARY KEY (Id), KEY Id (Id)) ENGINE=InnoDB DEFAULT CHARSET=latin1'

Any ideas would be greatly appreciated.

1
0
7/16/2016 1:42:33 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Found my problem, in MySql, the following statements need to be run and then EF6 cooperates:

set global optimizer_switch='derived_merge=off'; set optimizer_switch='derived_merge=off';

0
7/16/2016 2:04:31 PM

Related Questions

What am I doing wrong with MySQL and Entity Framework?

I got past this error by adding a reference to MySql.Data.Entity.dll (and MySql.Web.dll)
.net entity-framework mysql nullreferenceexception visual-studio-2010
asked by Rami A.

In a call to 'join' on nullable and non-nullable ints, type inference failed.

To compare Int? and Int, append ....Value... to the nullable property:...var result = from emp in employees join dept in departments on new { Source = emp.EmployeeID } equals new { Source = dept.EmployeeID.Value };
c# entity-framework linq non-nullable nullable
asked by Greg Sansom

Framework for Entities A nullable entity property is mapped to a non-nullable column.

2017 Update (Visual Studio 2017)...If the accepted straight-forward solution mentioned by lLya didn't help you, then this might. You may notice that when you save a diagram it does some work, like changing the class properties according to your diagram changes. One would think that the generator itself would be aware of these changes, right?! You m...
c# entity-framework mapping nullable poco
asked by DerpyNerd

5 Db Entity Framework UpdateException: A non-nullable member has a null value.

Complex types cannot be null - so you have to create an instance of the class before saving. This article helped me solve the same problem. ...http://weblogs.asp.net/manavi/archive/2011/03/28/associations-in-ef-4-1-code-first-part-2-complex-types.aspx
c# entity-framework
asked by Julian Dormon

must be non-nullable in order to use as parameter 'T'

just to help other people...in this case just change ...Property(p => p.Name).HasColumnName("NAME").IsOptional(); ...to ...Property(p => p.Name.Object).HasColumnName("NAME").IsOptional();
.net c# code-first entity-framework
asked by user3104239

Entity Framework Code first making a column non-nullable

That's because you allowed ...NULL... values in that column, then tried to make it non-nullable. It will subsequently try to migrate your existing data into that newly non-nullable column, which will break because you already have ...NULL... values in there....Two solutions:...1) Change it back to nullable ... 2) Give it a default value for items t...
c# entity-framework sql
asked by mattytommo

EF6.0 "The relationship could not be changed because one or more of the foreign-key properties is non-nullable"

In the entity framework 6.0 if you remove the entity from the main context set it will work. For example to remove an investment entity you would do the following:...context.Investments.Remove(entity); context.SaveChanges(); ...This is different than attempting to remove the entity from its parent/owner, as the following:...bankAccount.Investments....
entity-framework fluent-interface
asked by Gerry Polucci

Entity Framework 6.1.3 Mapping Foreign key to non primary key

This is now possible in Entity Framework 7 (that is, EF Core 1.0)....From .Net Entity Framework User Voice ...Unique Constraint (i.e. Candidate Key) Support...:...Support for this feature was added in EF Core 1.0 and we don’t have plans to add it in the EF6 codebase.
c# entity-framework-6
asked by ErikE

Mapping foreign key to non primary surrogate key column in EF code first

As far as I understand it is ...not possible... to do it in EF code first with either attributes or fluent api:...Entity Framework 6.1.3 Mapping Foreign key to non primary key...Entity Framework 5.0 composite foreign key to non primary key - is it possible?...Entity Framework Code first mapping without foreign key...But I can propose you to remodel...
c# ef-code-first entity-framework entity-framework-6 foreign-keys
asked by Eugene Podskal

Entity Framework: one or more of the foreign-key properties is non-nullable

You have to analyze your object to solve this problem....Here some simple code to explain your ...Exception...:...static void Main() { using (MyDbContext ctx = new MyDbContext()) { // Build a new object MyClass o = new MyClass() { Id = 1, ChildObject = null }; // Add it to your Context (It's not in the DB yet!) ...
c# entity-framework entity-framework-6 exception sql-server
asked by kara

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow