add database prefix to generated sql is a problem in vs 2008

[Ryan Liu]

Hi,
I set a connection string in project settings, then in Setting.Design.cs:
[global::System.Configuration.DefaultSettingValueAttribute("server=localhost;user
id=sss;password=abc;persist security info=True;database=test")]

public string FpConStrFromSetting3 { get { return
((string)(this["FpConStrFromSetting3"])); } }



After I release the application, I modify APP.exe.config, change
FpConStrFromSetting3 to ;database=test2

But it still get data from database test!

I think FpConStrFromSetting3 does pick new value from config file, but
problem is with VS2008 auto generated select cmd, it add database prefix for
each table, e.g. select * from test.provinces;

Is this a bug with Data Design in VS 2008? Any suggestion to work around?



Thanks!