ASP.NET Universal Providers add provider support in ASP.NET 4 for all editions of SQL Server 2005 and later and to SQL Azure. If you use these providers to develop your application, the application will be ready for cloud environments like Azure. Other than supporting additional storage options, the providers work like the existing SQL-based providers, so that you can easily switch an application to use cloud storage via SQL Azure. Good thing for Universal Provider is we don't need run aspnet_regsql.exe any more to create database objects to be used for membership, we don't need do anyhing on database end. When create the first user the Universal Provider will create all tables to be needed for membership automaticially.
