22.2. Using the SqlProfileProvider

The SqlProfileProvider allows you to store profile information in a SQL Server 7.0 (or later) database (including SQL Server 2005 Express Edition). You can choose to create the profile tables in any database. However, you can't change any of the other database schema details, which means you're locked into specific table names, column names, and serialization format.

From start to finish, you need to perform the following steps to use profiles:

  1. Enable authentication for a portion of your website.

  2. Configure the profile provider. (This step is optional if you're using SQL Server 2005 Express. Profiles are enabled by default.)

  3. Create the profile tables. (This step isn't required if you're using SQL Server 2005 Express.) ...

Get Beginning ASP.NET 3.5 in C# 2008: From Novice to Professional, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial