ASP.NET 2.0 Table Profile Provider Samples

Overview

The default SqlProfileProvider that ships with = ASP.NET 2.0=20 "blobicizes" Profile data using string, XML or binary = serialization prior=20 to storing information in SQL Server. A frequent request = from=20 developers is the ability to store Profile data "in the clear" in = the=20 database so that the data is available for querying and use in = stored=20 procedures. The two samples in this download solve this = problem.

Features

The first sample provider = (SqlTableProfileProvider) stores=20 each Profile property in a separate database column. Furthermore = the=20 provider stores the Profile data without serializing it, which = means that=20 the Profile property type needs to be compatible with the target = database=20 column.

The second sample provider=20 (SqlStoredProcedureProfileProvider) maps each Profile property to = a=20 parameter on a custom stored procedure. Like the table based = provider,=20 this provider expects that each Profile property is of a type that = is=20 compatible with its corresponding stored procedure parameter. The = powerful=20 aspect of the stored procedure based provider is that other than = the=20 requirement to implement some stored procedures with a specific = set of=20 parameters, you can implement whatever business logic you need in = the=20 stored procedures to map the Profile data to your own database = schema and=20 database logic.

Setup

The downloadable samples include walkthroughs for = setting up=20 and using both the table-based and the stored procedure based=20 providers. To make use of the sample site:

Copy the files in this sample to a virtual directory.=20
Edit the web.config file to change the connection string so = it=20 points at your database and server.=20
In the App_Data directory there is a sample SQL script that = you can=20 use with the walkthrough document. You will need to change the = database=20 name and security accounts in the database script to match your = database=20 environment.

Current Version: 1.0 (released 1/6/2006)

=C2=BB=20 Download Whitepaper
=C2=BB = Discuss in the=20 Web Parts and Personalization Forum

About the Author

Hao Kung is a Software Design Engineer = working in=20 the Microsoft ASP.NET team. He grew up in New Jersey, graduated = from=20 Cornell University in 2001, and joined Microsoft in 2003. He = enjoys=20 playing computer games, poker, and reading fantasy/sci-fi novels = during=20 his free time.