I would like to ask what is difference betweeen this three membership providers from SQL Server Compact perspective. As far I as I saw first two of them can use compact server by design and third one by coincidence I guess, because of entity framework. So, is there any difference in fact?
Difference is Universal is nearly the same as original with added support for SQL Compact and Azure. Simple membership is a bit simplified, has a few additional modern implementations like token based password resets and works great with ASP.NET Webpages. Both are written by using barebone SQL and have clunky table structures. Code-first is written in EF therefore it supports more databases, it is simplified a bit more as it can only be used on 1 site (in my current implementation) has neater tables which are easily extendable. Code-first provides a better prograiming experience.
Answer by Se3ker