RE: web parts and a database

Hello igotyourdotnet,

Thanks for your reply.

Yes, if you're using the webpart through the default SQL
provider(AspNetSqlPersonalizationProvider class), you do have to provide a
sqlserver instance or SQLEXPRESS engine.

However, as I said, the ASP.NET 2.0's application servies are all designed
as provider based, it's flexible to create custom provider and use custom
provider to replace the default ones. I've found some web articles that
mentioned creating custom provider (file based for example) to avoid using
database:

#Webparts without SqlExpress or SqlServer
Categories
http://www.kowitz.net/2006/5/2/Webparts+without+SqlExpress+or+SqlServer.aspx

You can get more information about the provider model in ASP.NET 2.0 and
developing custom provider in the MSDN dev center:

#Provider Toolkit
http://msdn.microsoft.com/asp.net/downloads/providers/default.aspx

Hope this helps.


Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • Custom membership provider in partial trust mode
    ... I also created a simple Website using Visual Studio 2005 and configured the Web.config to use this custom provider that I have written. ... I could use the ASP.NET configuration tool and use the custom provider to add users and view user details. ... I want to run this provider in the partial trust environment since MOSS 2007 runs in Minimal trust mode. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Forms Authentication
    ... commerceserver profile provider for authentication. ... custom provider takes email and password to authenticate and adding ... I have a custom aspx page with registration control that registers a ...
    (microsoft.public.sharepoint.portalserver)
  • Re: WSS deployment over Internet
    ... creating custom provider for combining both FBA and AD. ... implement a custom MemberShip provider which delegates the real work to the two standard ASP.NET providers. ... their AD credintials only from Internet as well. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Why do I get "name LocalSqlServer was not found" when my app uses MySQL?
    ... you can clear the connection strings: ... clear the default provider and specify a custom provider: ... for sample access code to MySql using ASP.NET 2.0. ... If you're using MySQL as your database platform as a custom Provider, ...
    (microsoft.public.dotnet.framework.aspnet)