Entity Framework and Mysql fail to insert

Question

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

The Code is

        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();

Thanks

Can you show the larger context of the code (the containing method) — Forty-Two
– Forty-Two, Commented Jan 4, 2013 at 21:39
hi Alex Zheludov i am also getting same error here could you please show me example here how you fixed that? — user123
– user123, Commented Jun 2, 2014 at 8:38

Alex Zheludov · Accepted Answer · 2013-01-04 22:18:41Z

3

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

answered Jan 4, 2013 at 22:18

Alex Zheludov

1715 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework and Mysql fail to insert

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related