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.D efaultSettingVa lueAttribute("s erver=localhost ;user
id=sss;password =abc;persist security info=True;datab ase=test")]

public string FpConStrFromSet ting3 { get { return
((string)(this["FpConStrFromSe tting3"])); } }



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

But it still get data from database test!

I think FpConStrFromSet ting3 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!