I am working on creating a mmc snap in in .NET 2.0 and wanted to use LLBLGen Pro 2.0 for some database access. The problem I have is this, this project generates a dll that is loaded by mmc.exe and therefor does not load a standard app.config for the connection string. Is there a way I can programatically tell the dll where to grab the connection string from?

Are you using Adapter or Selfservicing?

I am using self servicing.

tthompson4 wrote:

I am working on creating a mmc snap in in .NET 2.0 and wanted to use LLBLGen Pro 2.0 for some database access. The problem I have is this, this project generates a dll that is loaded by mmc.exe and therefor does not load a standard app.config for the connection string. Is there a way I can programatically tell the dll where to grab the connection string from?

If I'm not mistaken it's under <NameSpace>.HelperClasses.DBUtils.ActualConnectionString or something to that effect.

And you can use application settings (new feature in .net 2) to store the connection strings.

C4 had it right. See the documentation under "Generated code - DbUtils functionality - Connection Strings".

You could also switch to using the Adapter templates, which allows you to pass a connection string to use at runtime to the DataAccessAdapter constructor.

I've got it now I'm using Settings to store the ConnectionString and then I pass it to DbUtils.ActualConnectionString at run time. Seem to work perfectly. Thanks all.