实体框架和MySQL无法插入 [英] Entity Framework and Mysql fail to insert

问题描述

我想插入一行MySQL数据库和我得到这个错误。

I'm trying to insert row to mySql db and I'm getting this error.

   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SELECT
 `groups_users`.`groupID`, 
 `groups_u' at line 1

在code是

        groups_users ug = new groups_users();
        ug.groupID = 1;
        ug.userID = 1;
        ug.isDeleted = false;
        ug.created = DateTime.Now;
        ctx.groups_users.Add(ug);

        ctx.SaveChanges();

感谢

推荐答案

固定它。
在EDMX文件有问题。所有字段都设置为实体按键。

Fixed it. Had issue in edmx file. all fields were set to be entity keys.

这篇关于实体框架和MySQL无法插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！