		JB WebTech, LLC

SQL Table Profile Provider Sample

The great people over at asp.net has provided the developer community with ASP.NET 2.0 Table Profile Provider Samples which gives developers an excellent base to building their own profile providers for storing information "in the clear" in SQL Server, rather than the default blob field.

Here is the SQLTableProfileProvider class converted from C# to VB, with a modification on it to hanlde Null parameters (SqlTableProfileProvider.zip). This modification requires an additional value in the customProviderData attribute of the profile properties defined in the web.config. This third value is true or false and specifies if the column will AllowNulls.
customProviderData="FirstName;nvarchar;false"

Here is the SQLStoredProcedureProfileProvider class converted from C# to VB (SqlStoredProcedureProfileProvider.zip).

For documentation, please see the whitepaper provided with the original code.