ASP.NET 2.0 SQL Table Profile Provider Released Today
Hao and Stefan just shipped a cool new Profile Provider download on the ASP.NET Sandbox Site. It provides two new profile provider implementations (with complete source code) that you can use. One enables you to map profile properties directly to a SQL table in a database -- enabling you to perform richer queries on the back-end for your personalization data. The second implementation enables you to map profile properties to stored procedures in a database -- enabling you to perform whatever custom data logic you want to persist your user personalization data.
Enabling them within an ASP.NET 2.0 application is easy. You just replace the profile provider mapping within the web.config file for your application (no code changes required). Calls to and from the ASP.NET 2.0 Profile system will then delegate to the configured provider. The profile system allows you to map different profile properties to different providers - so you could have some go against the built-in blob storage provider, some against the SQL table one, some against the SPROC one, and some against a completely new provider you implement (note: I probably wouldn't recommend having 4 different profile providers at once -- but it is nice to know you have the flexibility <g>).
Here are some past posts I've done about the ASP.NET 2.0 Profile system if you are interested in learning more about it:
- ASP.NET 2.0 Profile Feature
- How to add a Login, Roles and Profile system to an ASP.NET 2.0 app in only 24 lines of code
- Cool ProfileView Control
Hope this helps,
Scott