Entity Framework 6 with Mysql and NullReferenceException

asp.net c# entity-framework entity-framework-6 mysql

Question

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 that. However anyone solved my problem (also another people's problems). I found some bug reports about problem like that. However every reports should solved in .Net Connector 6.8.3. I think I am missing very simple step in EF with Mysql but I could not found what is my mistakes...

Sample Code:

using (prodEntities myEntity = new prodEntities ())
{
  userloginlog log = new userloginlog();
  log.UserRef = pUserID;
  log.Success = pSuccess;
  log.IpNo = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"].ToString();
  log.BrowserInfo = browserInfo;
  log.LoginTime = GeneralHelperC.getCompanyDateTime();
  myEntity.userloginlog.Add(log);
  myEntity.SaveChanges();
}

Table:

CREATE TABLE `userloginlog` (
  `RID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `UserRef` bigint(20) unsigned NOT NULL,
  `LoginTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `IpNo` varchar(15) DEFAULT NULL,
  `Success` tinyint(4) NOT NULL,
  `BrowserInfo` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`RID`),
  KEY `userLoginLog_Staff_Key` (`UserRef`),
  CONSTRAINT `UserLoginLog_User_Key` FOREIGN KEY (`UserRef`) REFERENCES `users` (`RID`)
) ENGINE=InnoDB AUTO_INCREMENT=16903 DEFAULT CHARSET=utf8;

Exception:

   at MySql.Data.Entity.ListFragment.WriteSql(StringBuilder sql)
   at MySql.Data.Entity.SelectStatement.WriteSql(StringBuilder sql)
   at MySql.Data.Entity.InsertStatement.WriteSql(StringBuilder sql)
   at MySql.Data.Entity.SqlFragment.ToString()
   at MySql.Data.Entity.InsertGenerator.GenerateSQL(DbCommandTree tree)
   at MySql.Data.MySqlClient.MySqlProviderServices.CreateDbCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree)
   at System.Data.Entity.Core.Common.DbProviderServices.CreateDbCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree, DbInterceptionContext interceptionContext)
   at System.Data.Entity.Core.Common.DbProviderServices.CreateCommandDefinition(DbCommandTree commandTree, DbInterceptionContext interceptionContext)
   at System.Data.Entity.Core.Common.DbProviderServices.CreateCommand(DbCommandTree commandTree, DbInterceptionContext interceptionContext)
   at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.CreateCommand(DbModificationCommandTree commandTree)
   at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.CreateCommand(Dictionary`2 identifierValues)
   at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary`2 identifierValues, List`1 generatedValues)
   at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()
   at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.<Update>b__2(UpdateTranslator ut)
   at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update[T](T noChangesResult, Func`2 updateFunction)
   at System.Data.Entity.Core.EntityClient.Internal.EntityAdapter.Update()
   at System.Data.Entity.Core.Objects.ObjectContext.<SaveChangesToStore>b__d()
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction)
   at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClassb.<SaveChangesInternal>b__8()
   at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation)
   at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction)
   at System.Data.Entity.Core.Objects.ObjectContext.SaveChanges(SaveOptions options)
   at System.Data.Entity.Internal.InternalContext.SaveChanges()
   at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()
   at System.Data.Entity.DbContext.SaveChanges()

Installed in my computer:

  • Mysql Server 5.6CE
  • MySQL Connector NET 6.8.3
  • Visual Studio 2013

Refenced DLL's in project (everyone installed with nuget):

  • MySql.Data.dll (6.8.3)
  • MySql.Data.Entity.dll (6.7.5)
  • MySql.Data.Entities.dll (6.8.3.0)
  • MySql.Web.dll (6.8.3)
  • EntityFramework.dll (6.1.1)

Project is Asp.Net Webform which running under .Net Framework 4.0

Thank you very much

1
2
7/3/2014 4:54:31 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

We had a similar issue. We didn't have an ID field, but we had a timestamp as primary key. The solution was to introduce an ID, and set that to be the primary key.

1
10/11/2015 11:00:34 PM

Related Questions

NullReferenceException: Entity Framework Code First + MySQL

I need to work with data in a couple of tables in an off site MySQL database we have limited access to and decided to use it as an opportunity to pick up some EFCF experience. No matter what I do i cannot get any data out of the MySQL database. Using MySQL workbench I can confirm the connection details are correct and can access the tables necessar...
asp.net-4.0 c# entity-framework mysql
asked by Hawxby

In System.Data.Entity.dll (Entity Framework), why am I receiving a NullReferenceException?

I got the same problem when accidently loading a Module multiple times in a modular Architecture....Additional, the Module(s) where using 2 copies of the same ...DbContext..., trying to connect one Entity from one Context to another Entity of the other Context....This masked the ...InvalidOperationException... (cannot use an Entity in multiple Trac...
c# entity-framework wpf
asked by FrankM

Connection closed when doing Transaction rollback on Mysql with Entity Framework 6 and Devart provider

I downloaded the new version 8.1.45 of Devart DotConnect and this has solved the problem completely. Now my transactions get a rollback if any query in them gets an error. And I get the correct exception in my EF6 Executionstrategy....So problem solved. Thx Devart. :)
c# devart entity-framework-6 mysql transactions
asked by Steven Engels

Entity Framework with MySql and Migrations failing because "max key length is 767 bytes"

With MySQL Connector/Net 6.8 and Entity Framework version 6, you can solve this problem using MySQL's built-in support for EF. The trick is to tell Entity Framework to use the MySQL resolvers. From the ...Connector/Net Developer Guide...:...This can be done in three ways:...Adding the DbConfigurationTypeAttribute on the context class:...[DbConfigur...
c# entity-framework mysql
asked by KingPong

Entity Framework (EF6) + MySql Database First Model Many to Many Relationship Wrong Query Generation

I have a project which has an existing database structure and data. Currently project is running on PHP + MySQL and I'm trying to switch from PHP to C# EF 6.0 + MySQL Database first approach....I have installed NuGet Packages (EF 6.0 and MySQL.Data, MySQL.Web, MySQL.Data.Entity, MySQL.Data.Entities) and modified my app.config according to use MySQL...
c# ef-database-first entity-framework-4 entity-framework-6 mysql
asked by Cihan Uygun

Entity Framework's Entity Data Wizard Crashes When Connecting to MySQL Database

I had this problem today, following the tips here that it is a "version mismatch" is completely correct!...My important "discovery" is that they have renamed the package you need for EF6! As many people here has discovered (for example "Nofi"), downgrading to match versions fixes the problem. However, ...instead of downgrading the new versions, swa...
c# entity-framework-6 mysql visual-studio-2015
asked by Magnus Ingwersen

Entity Framework 6 MySQL - performance difference vs MySQL engine

So there's a few posts around complaining about the performance of the MySQL plugin for Entity Framework 6. Most of these, however, seem to come down to it generating bad SQL. I'm suffering with this issue but it seems to be due to a performance lag due to the plugin itself....Here's my query in LINQ:...List<Address> matches = _rep.GetAddresses(s =...
c# entity-framework entity-framework-6 linq mysql
asked by Bob Tway

entity framework 6 - seeding database throws System.NullReferenceException

OK! I found the reason. In Main method when I'm creating a new entity of type Province, assigning value to its key parameter causes the error. This solves the problem:...context.Provinces.Add(new Models.Province { //ID = 1, Name = "TEST" }); ...But yet I'm really angry because the exception thrown doesn't show the real error!
c# code-first entity-framework-6 entity-framework-core
asked by Amin

Why do I get a NullReferenceException when using ToDictionary on an Entity Framework query?

I'm very surprised, it seems my lambda expressions are executed as C# code, instead of being converted to SQL....If that is really the case, it's a bit sad. For example:...context.Set<Post>().ToDictionary(post => post.Id, post => post.Comments.Count()) ...This code will apparently load the posts into C# objects first, and then count the comments. I...
entity-framework-6 linq-to-sql
asked by youen

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

With the help of Microsoft, I finally figured it out. Hopefully this helps someone else out there. I had to create my own class inheriting from DbConfiguration...public class MyCustomSQLDbConfiguration : DbConfiguration { public MyCustomSQLDbConfiguration() { SetExecutionStrategy("MySql.Data.MySqlClient", () => new MySqlExecutionStr...
.net c# entity-framework entity-framework-6 mysql-connector
asked by Mike

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