SQL Table Profile Provider Sample
The good 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.
I converted their SQLTableProfileProvider class 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's the SQLStoredProcedureProfileProvider class converted from C# to VB as well:
SqlStoredProcedureProfileProvider.zip.
For documentation, please see the whitepaper provided with the
original code.
(Feb 2012 Update: The location of the original code no longer exists at http://www.asp.net/sandbox/samp_profiles.aspx?tabindex=0&tabid=1,
however, you can download a cached copy of the page here.)
(If you notice a link is no longer working, could you please let me know? ...Thanks!)