Using SimpleMembership with EF model-first

by

SimpleMembership can work with model first. Here is the solution.

1.InitializeSimpleMembershipAttribute.cs from MVC 4 Internet Application templete should look like this 

namespace WebAndAPILayer.Filters
{
    [AttributeUsage(AttributeTargets.Class | AttributeTargets.Method, AllowMultiple = false, Inherited = true)]
    public sealed class InitializeSimpleMembershipAttribute : ActionFilterAttribute
    {
        private static SimpleMembershipInitializer _initializer;
        private static object _initializerLock = new object();
        private static bool _isInitialized;

        public override void OnActionExecuting(ActionExecutingContext filterContext)
        {
            // Ensure ASP.NET Simple Membership is initialized only once per app start
            LazyInitializer.EnsureInitialized(ref _initializer, ref _isInitialized, ref _initializerLock);
        }

        private class SimpleMembershipInitializer
        {
            public SimpleMembershipInitializer()
            {
                try
                {
                    WebSecurity.InitializeDatabaseConnection("ConnStringForWebSecurity", "UserProfile", "Id", "UserName", autoCreateTables: true);
                }
                catch (Exception ex)
                {
                    throw new InvalidOperationException("Something is wrong", ex);
                }
            }
        }
    }
}

2.Delete CodeFirst Classes from AcountModel.cs

3.Fix AccountCotroler.cs to work with your Model-first DbContext (ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl) method)

4.Define your "ConnStringForWebSecurity" connection string which is not same as that funky conn string for model-first db access, notice that we use provider System.Data.SqlClient not System.Data.EntityClient

 <connectionStrings>
         <add name="ModelFirstEntityFramework" connectionString="metadata=res://*/Context.csdl|res://*/Context.ssdl|res://*/Context.msl;provider=System.Data.SqlClient;provider
 connection string=&quot;data source=.\SQLEXPRESS;Initial
 Catalog=aspnet-MVC4;Integrated
 Security=SSPI;multipleactiveresultsets=True;App=EntityFramework&quot;"
 providerName="System.Data.EntityClient" />
         <add name="ConnStringForWebSecurity" connectionString="data source=.\SQLEXPRESS;Initial Catalog=aspnet-MVC4;Integrated
 Security=SSPI" providerName="System.Data.SqlClient" />
       </connectionStrings>

More Related Contents:

  1. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  2. No Entity Framework provider found for the ADO.NET provider with invariant name ‘System.Data.SqlClient’
  3. Entity Framework and SQL Server View
  4. How to mock the limitations of EntityFramework’s implementation of IQueryable
  5. EntityFramework code-first custom connection string and migrations
  6. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  7. Debug code-first Entity Framework migration codes
  8. Asp.Net Web API Error: The ‘ObjectContent`1’ type failed to serialize the response body for content type ‘application/xml; charset=utf-8’
  9. Unique keys in Entity Framework 4
  10. Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths
  11. Entity Framework: Re-finding objects recently added to context
  12. ObjectContext.Refresh()?
  13. How do I map a char property using the Entity Framework 4.1 “code only” fluent API?
  14. combination of two field must be unique in Entity Framework code first approach. how it would?
  15. mapping private property entity framework code first [duplicate]
  16. EntityFramework Core automatic migrations
  17. Entity Framework 4.1+ many-to-many relationships change tracking
  18. what is difference between a Model and an Entity
  19. Mocking or faking DbEntityEntry or creating a new DbEntityEntry
  20. Map two different entities to the same table?
  21. Include Grandchildren in EF Query
  22. Changes in IDENTITY column after EF core 3
  23. What would cause the Entity Framework to save an unloaded (but lazy loadable) reference over existing data?
  24. AutomaticMigrationsEnabled false or true?
  25. Using the Entry().CurrentValues.SetValues() is not updating collections
  26. Entity Framework Code First Many to Many Setup For Existing Tables
  27. Compose queries across Entity Data Models
  28. Changing Inherited Types in Entity Framework
  29. Why is my Entity Framework Code First proxy collection null and why can’t I set it?
  30. Why does the entity framework need an ICollection for lazy loading?

Leave a Comment