Any way to make BE allowing XML or SQL as an Option?

Topics: Business Logic Layer
Aug 1, 2011 at 4:42 PM

Is there an option in BE now to have a choice of either using XML or SQL as the database?  I like both options but don't know how to implement that yet.

Thank you

Aug 1, 2011 at 6:22 PM

Here is how to switch from XML to database provider. You might also do the same for membership and role providers if you want go all DB, although it is not required. Currently you have to modify web.config, no immediate plans to change it.

Aug 1, 2011 at 7:44 PM


You're awesome!  Thank you for the link.  How do I do the same for membership and role providers? I'm new to BE and the project is so large.  I've been trying to play around with it and figure it out but I'm not that advanced yet.  Can you help me see where and how BE scripts things to set up the database automatically like that?

Thank you

Aug 1, 2011 at 9:07 PM

In the same web.config change from:

<membership defaultProvider="XmlMembershipProvider"> to 
membership defaultProvider="DBMembershipProvider">


roleManager defaultProvider="XmlRoleProvider" enabled="true" cacheRolesInCookie="false"> to
<roleManager defaultProvider="DbRoleProvider" enabled="true" cacheRolesInCookie="false">