ModalPopup: Misunderstanding ConnectionStrings?

I have a web project whose web.config has a ConnectionString setup. I have
a second assembly with my Typed DataSets. The designer has created an App.config
file with a connection string in it for the designer to use. The web project
referecnes the data assembly with the TDS's in it. When I deploy this project,
my Typed DataSets are still using the data in the app.config, and not the
one in the web.config. Any idea on how to tell it to get the ConnectionString
data from web.config and ignore the app.config?

Shawn Wildermuth
C# MVP, Author and Speaker
http://adoguy.comAs I undestand, your TDS's are in a dll project? Just a thought - you can try
to remove dllname.config file from the bin folder - I think then ASP.Net will
use web.config...

"Shawn Wildermuth" wrote:

> I have a web project whose web.config has a ConnectionString setup. I have
> a second assembly with my Typed DataSets. The designer has created an App.config
> file with a connection string in it for the designer to use. The web project
> referecnes the data assembly with the TDS's in it. When I deploy this project,
> my Typed DataSets are still using the data in the app.config, and not the
> one in the web.config. Any idea on how to tell it to get the ConnectionString
> data from web.config and ignore the app.config?
> Shawn Wildermuth
> C# MVP, Author and Speaker
> http://adoguy.com
>
Thanks for Sergey's inputs.

Hi Shawn,

As Sergey has mentioned, when we create the TableAdapter(dataset) in a
class library project, the connection string setting is retrieved from the
Application Settings collection defined there. And actually the application
settings collection is persisted in app.config file... So when we use the
class library assembly in a end client application (winform or asp.net), we
can override those settings in teh application's config file (app.config or
web.config...). If we don't override, they use those default values defined
in class library...

Hope helps. Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

-------
| Thread-Topic: Misunderstanding ConnectionStrings?
| thread-index: AcYVe1HDeeq1cHElRLq4Owmrb9gwfA==
| X-WBNR-Posting-Host: 202.7.176.134
| From: "=?Utf-8?B?U2VyZ2V5IFBvYmVyZXpvdnNraXk=?="
<SergeyPoberezovskiy@.discussions.microsoft.com>
| References: <fc24ddbd448e8c7e351421e9280@.msnews.microsoft.com>
| Subject: RE: Misunderstanding ConnectionStrings?
| Date: Mon, 9 Jan 2006 16:18:02 -0800
| Lines: 20
| Message-ID: <2977146D-C7CF-4A3A-A690-D37F3A59F476@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:369653
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| As I undestand, your TDS's are in a dll project? Just a thought - you can
try
| to remove dllname.config file from the bin folder - I think then ASP.Net
will
| use web.config...
|
| "Shawn Wildermuth" wrote:
|
| > I have a web project whose web.config has a ConnectionString setup. I
have
| > a second assembly with my Typed DataSets. The designer has created an
App.config
| > file with a connection string in it for the designer to use. The web
project
| > referecnes the data assembly with the TDS's in it. When I deploy this
project,
| > my Typed DataSets are still using the data in the app.config, and not
the
| > one in the web.config. Any idea on how to tell it to get the
ConnectionString
| > data from web.config and ignore the app.config?
| >
| > Shawn Wildermuth
| > C# MVP, Author and Speaker
| > http://adoguy.com
| >
| >
| >
|
Hello Sergey,

No app.config in the bin folder...what it was is that they are pre-pending
the project name to the connection string, e.g. MyCOmpany.MyAssembly.Settings.SomeOtherStuff.Conne ctionStringName.
NO way I can tell to have the dll not create all that namespace clutter
so I had to create a second conneciton string in my web.config:

<connectionString name="myConnString" ... />
<connectionString name="MyCompany.MyAssembly.Settings.SomeOtherStuff.myCon nString"
... /
To make it work. I don't like this solution so if someone knows how to specify
a realisticly named Connection String in the Table Adapter, I'd appreciate
it.

Shawn Wildermuth
C# MVP, Author and Speaker
http://adoguy.com

> As I undestand, your TDS's are in a dll project? Just a thought - you
> can try to remove dllname.config file from the bin folder - I think
> then ASP.Net will use web.config...
> "Shawn Wildermuth" wrote:
>> I have a web project whose web.config has a ConnectionString setup.
>> I have a second assembly with my Typed DataSets. The designer has
>> created an App.config file with a connection string in it for the
>> designer to use. The web project referecnes the data assembly with
>> the TDS's in it. When I deploy this project, my Typed DataSets are
>> still using the data in the app.config, and not the one in the
>> web.config. Any idea on how to tell it to get the ConnectionString
>> data from web.config and ignore the app.config?
>>
>> Shawn Wildermuth
>> C# MVP, Author and Speaker
>> http://adoguy.com
Hello Steven Cheng[MSFT],

Please see my reply to Sergey. Is there a way to tell the app to use a shorter
connection string name? We only have one so naming it with the entire setting
container is a waste of space and mindshare.

Shawn Wildermuth
C# MVP, Author and Speaker
http://adoguy.com

> Thanks for Sergey's inputs.
> Hi Shawn,
> As Sergey has mentioned, when we create the TableAdapter(dataset) in a
> class library project, the connection string setting is retrieved from
> the Application Settings collection defined there. And actually the
> application settings collection is persisted in app.config file... So
> when we use the class library assembly in a end client application
> (winform or asp.net), we can override those settings in teh
> application's config file (app.config or web.config...). If we don't
> override, they use those default values defined in class library...
> Hope helps. Thanks,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
> -------
> | Thread-Topic: Misunderstanding ConnectionStrings?
> | thread-index: AcYVe1HDeeq1cHElRLq4Owmrb9gwfA==
> | X-WBNR-Posting-Host: 202.7.176.134
> | From: "=?Utf-8?B?U2VyZ2V5IFBvYmVyZXpvdnNraXk=?="
> <SergeyPoberezovskiy@.discussions.microsoft.com>
> | References: <fc24ddbd448e8c7e351421e9280@.msnews.microsoft.com>
> | Subject: RE: Misunderstanding ConnectionStrings?
> | Date: Mon, 9 Jan 2006 16:18:02 -0800
> | Lines: 20
> | Message-ID: <2977146D-C7CF-4A3A-A690-D37F3A59F476@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.dotnet.framework.aspnet
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path:
> TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.dotnet.framework.aspnet:369653
> | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
> |
> | As I undestand, your TDS's are in a dll project? Just a thought -
> you can
> try
> | to remove dllname.config file from the bin folder - I think then
> ASP.Net
> will
> | use web.config...
> |
> | "Shawn Wildermuth" wrote:
> |
> | > I have a web project whose web.config has a ConnectionString
> setup. I
> have
> | > a second assembly with my Typed DataSets. The designer has
> created an
> App.config
> | > file with a connection string in it for the designer to use. The
> web
> project
> | > referecnes the data assembly with the TDS's in it. When I deploy
> this
> project,
> | > my Typed DataSets are still using the data in the app.config, and
> not
> the
> | > one in the web.config. Any idea on how to tell it to get the
> ConnectionString
> | > data from web.config and ignore the app.config?
> | >
> | > Shawn Wildermuth
> | > C# MVP, Author and Speaker
> | > http://adoguy.com
> | >
> | >
> | >
> |
Shawn,

We used the following code to read from the web.config from inside a dll:

string abc_setting = ConfigurationSettings.AppSettings["abc_setting"];

and it works as long as abc_setting is defined in web.config as follows:

<configuration>
..
<appSettings>
...
<add key="abc_setting" value="abc"/>
</appSettings>
...
</configuration
"Shawn Wildermuth" wrote:

> Hello Sergey,
> No app.config in the bin folder...what it was is that they are pre-pending
> the project name to the connection string, e.g. MyCOmpany.MyAssembly.Settings.SomeOtherStuff.Conne ctionStringName.
> NO way I can tell to have the dll not create all that namespace clutter
> so I had to create a second conneciton string in my web.config:
> <connectionString name="myConnString" ... />
> <connectionString name="MyCompany.MyAssembly.Settings.SomeOtherStuff.myCon nString"
> ... />
> To make it work. I don't like this solution so if someone knows how to specify
> a realisticly named Connection String in the Table Adapter, I'd appreciate
> it.
> Shawn Wildermuth
> C# MVP, Author and Speaker
> http://adoguy.com
> > As I undestand, your TDS's are in a dll project? Just a thought - you
> > can try to remove dllname.config file from the bin folder - I think
> > then ASP.Net will use web.config...
> > "Shawn Wildermuth" wrote:
> >> I have a web project whose web.config has a ConnectionString setup.
> >> I have a second assembly with my Typed DataSets. The designer has
> >> created an App.config file with a connection string in it for the
> >> designer to use. The web project referecnes the data assembly with
> >> the TDS's in it. When I deploy this project, my Typed DataSets are
> >> still using the data in the app.config, and not the one in the
> >> web.config. Any idea on how to tell it to get the ConnectionString
> >> data from web.config and ignore the app.config?
> >>
> >> Shawn Wildermuth
> >> C# MVP, Author and Speaker
> >> http://adoguy.com
>
>
Thanks for your response Shawn,

As for the connectionstring name it is generated by the AppSettingBase
class's naming convention so as to avoid name clash when deploying to
target application(since the client app could use many other components
....). Also, if you do want to change the TableAdatper to use a customized
connection string , you can find the underlying code about the connection
intilization of the TableAdapter in the DataSet.Desiger.cs file which is
genernated by IDE, but we do not recommend this since IDE manage these code
and our customization could be override by IDE when performing some changes
through DESIGN TIME view...

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

|
|

Thursday, March 29, 2012

Misunderstanding ConnectionStrings?

0 comments:

Post a Comment

ModalPopup

Blog Archive

About Me