I am in the early stages of writing an ASP.Net 2.0 site using MS SQL 2000. The site will have 2 areas, an unsecured main area and a sub-folder with a second web.config which has Forms authentication enabled.

My question is, will LLBLGEN 2 use the local connection strings in the 2 web.config files?

(I am using the self service templates).

I intend for the unsecured main folder's web.config to use a connection string which uses a read only database user. The secured sub folder's web.config will use a connection string with a database user that has more permissions.

Any help greatly appreciated before I spend too much time implementing this.

Neil.

I assume you mean by a sub-folder, a sub virtual folder. Each web application's DAL assembleis will use the corresponding web.config.

Also you might set it manually in code by setting the "DbUtils.ActualConnectionString".

(This is still Neil but from the forum user I have at work)

I mean a sub folder within the same virtual directory

You should make that a new virtual directory. That makes it a new application, so you can place a new web.config in there.