Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

The context cannot be used while the model is being created. dbContext is being used somewhere else?

I am using EF6 and Identity2 Here is the error I am getting:

{"The context cannot be used while the model is being created. This exception may be thrown if the context is used inside the OnModelCreating method or if the same context instance is accessed by multiple threads concurrently. Note that instance members of DbContext and related classes are not guaranteed to be thread safe."}

I also looked at this code and couldnt figure out:

"Context cannot be used while the model is being created" exception with ASP.NET Identity

and here is my code:

Startup.Auth.cs:

namespace IdentitySample {
public partial class Startup {
    // For more information on configuring authentication, please visit http://go.microsoft.com/fwlink/?LinkId=301864
    public void ConfigureAuth(IAppBuilder app) {
        // Configure the db context, user manager and role manager to use a single instance per request
        app.CreatePerOwinContext(ApplicationDbContext.Create);
        app.CreatePerOwinContext<ApplicationUserManager>(ApplicationUserManager.Create);
        app.CreatePerOwinContext<ApplicationRoleManager>(ApplicationRoleManager.Create);

        // Enable the application to use a cookie to store information for the signed in user
        // and to use a cookie to temporarily store information about a user logging in with a third party login provider
        // Configure the sign in cookie
        app.UseCookieAuthentication(new CookieAuthenticationOptions {
            AuthenticationType = DefaultAuthenticationTypes.ApplicationCookie,
            LoginPath = new PathString("/account/login"),
            Provider = new CookieAuthenticationProvider {
                // Enables the application to validate the security stamp when the user logs in.
                // This is a security feature which is used when you change a password or add an external login to your account.  
                OnValidateIdentity = SecurityStampValidator.OnValidateIdentity<ApplicationUserManager, ApplicationUser>(
                    validateInterval: TimeSpan.FromMinutes(30),
                    regenerateIdentity: (manager, user) => user.GenerateUserIdentityAsync(manager))
            }
        });
        app.UseExternalSignInCookie(DefaultAuthenticationTypes.ExternalCookie);

        // Enables the application to temporarily store user information when they are verifying the second factor in the two-factor authentication process.
        app.UseTwoFactorSignInCookie(DefaultAuthenticationTypes.TwoFactorCookie, TimeSpan.FromMinutes(5));

        // Enables the application to remember the second login verification factor such as phone or email.
        // Once you check this option, your second step of verification during the login process will be remembered on the device where you logged in from.
        // This is similar to the RememberMe option when you log in.
        app.UseTwoFactorRememberBrowserCookie(DefaultAuthenticationTypes.TwoFactorRememberBrowserCookie);

        // Uncomment the following lines to enable logging in with third party login providers
        //app.UseMicrosoftAccountAuthentication(
        //    clientId: "",
        //    clientSecret: "");

        //app.UseTwitterAuthentication(
        //   consumerKey: "",
        //   consumerSecret: "");

        //app.UseFacebookAuthentication(
        //   appId: "",
        //   appSecret: "");

        app.UseGoogleAuthentication();
    }
}

}

here is my db initializer:

        public override void InitializeDatabase(ApplicationDbContext context)
    {
        if (!context.Database.Exists())
        {
            // If database did not exist before, create it
            context.Database.Create();
        }
        else
        {
            // Query to check if MigrationHistory table is present in the database 
            var migrationHistoryTableExists = 
                ((IObjectContextAdapter)context).ObjectContext.ExecuteStoreQuery<int>(
            string.Format(
              "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = '{0}' " 
                + "AND table_name = '__MigrationHistory'",
              "[worldbigtree.security]"));

            // If MigrationHistory table is not there (which is the case first time we run), create it
            if (migrationHistoryTableExists.FirstOrDefault() == 0)
            {
                if (settings.RecreateDatabase)
                {
                    context.Database.Delete();
                    context.Database.Create();
                    InitializeIdentityForEF(context);
                }
            }
        }


        base.Seed(context);
    }

applicationDbContext:

    public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
{
    public ApplicationDbContext()
        : base("DefaultConnection", throwIfV1Schema: false)
    {
        Database.SetInitializer<ApplicationDbContext>(new MySqlInitializer());
    }

    static ApplicationDbContext()
    {
        // Set the database intializer which is run once during application start
        // This seeds the database with admin user credentials and admin role
        Database.SetInitializer<ApplicationDbContext>(new MySqlInitializer());
    }

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

    public DbSet<Person> People { get; set; }
}
like image 576
user3311522 Avatar asked Oct 31 '22 23:10

user3311522


1 Answers

You can not do it. Answer of your question is Yes. In constructor of your context, you're initializing Database. And you can not do any CRUD operations in same time, while Initializing the Database is not finished. You would insert or select, but Context is used for Database.SetInitializer. I have not tried this, but check could you do it with ADO.NET? If you couldn't, check this: ODBC(Open Database Connectivity)

like image 124
ILOVECSHARP Avatar answered Nov 15 '22 05:11

ILOVECSHARP