EF MySQL ApplicationUser MVC5

Vote count:

0

I updated my visual studio with update 4, and since then I'm having problems connecting projects to MySQL.

I followed this tutorial and before everything was working good, but now with the new update 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 'FROM ((SELECT
CASE WHEN (`Extent2`.`UserId` IS  NULL) THEN (NULL)  ELSE (1) END' at line 28

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: MySql.Data.MySqlClient.MySqlException: 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 'FROM ((SELECT
CASE WHEN (`Extent2`.`UserId` IS  NULL) THEN (NULL)  ELSE (1) END' at line 28

Source Error: 


Line 76:             // This doesn't count login failures towards account lockout
Line 77:             // To enable password failures to trigger account lockout, change to shouldLockout: true
Line 78:             var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout: false);
Line 79:             switch (result)
Line 80:             {

The only difference from the tutorial is this line:

public ApplicationDbContext()
            : base("DefaultConnection", throwIfV1Schema: false)
        {
            Database.SetInitializer(new MySqlInitializer());
        }

        public static ApplicationDbContext Create()
        {
            return new ApplicationDbContext();
        }

My question is, How can I make this working like before?

asked 24 secs ago

bramalho

33

EF MySQL ApplicationUser MVC5