The Web Platform and Tools team (WPT) is released an Alpha of the ASP.NET Universal Providers that will extend Session, Membership, Roles and Profile support to SQL Compact Edition and SQL Azure. Other than supporting additional storage options, the providers work like the existing SQL-based providers.
Download and Install : ASP.NET Universal Providers 1.0.1
Download and Install : ASP.NET Universal Providers 1.0.1