Re: Typed DataSets in VS2005

VSS 2005 support auto generating the dataaccess layer .. and in that case
you are free to change the code where it hardcode the connection string so
that it will read it from a config file (obviously you have to change the
code again if you have to create/ edit the dataset again.

In my view point the automatically generated code is very good if you are
heading toward a quick concept demo or a working prototype.. but if you are
looking to develop a real extensible large-scale system, then I rather
advice you to have your own data access layer, indeed you may have some
assistance from the Data access Applcation Blocks or enterprise library.
There you will get that chance of developing a flexible dataaccess layer.. I
am telling this with my experience and if you go with the auto geneated code
you will at times drive in to bottleneck of your code..

Nirosh.


"Peter Bradley" <pbradley@xxxxxxxxxx> wrote in message
news:eLioYLfcHHA.2404@xxxxxxxxxxxxxxxxxxxxxxx
Hi all,

This post is sort of tangentially related to my earlier posts on
configuration files for DLLs.

Does anyone know how to create typed DataSets using VS2005's new DataSet
designer, but with the ability to configure the connection string via a
config file? The designer seems to hard-code the connection string into
the dataset itself, which just can't be right.

The typed DataSets created by VS2005 comes with a dll.config file that
looks as though it's trying to do something like that, and which is put
with the executable at compile time, but altering the connection string in
there doesn't appear to have any effect. We've seen lots of people asking
this question, but haven't found anyone answering it yet.


Thanks in advance





Peter




.

Relevant Pages

  • Re: Typed DataSets in VS2005
    ... Or are you talking about another config file? ... I always taken the connection string via the ... SELECT mailbox, storage_group, server FROM atablename WHERE (mailbox = ... that chance of developing a flexible dataaccess layer.. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Typed DataSets in VS2005
    ... SqlConnection by reading the values from the config file and assign it to ... dataset/ database.. ... The table adapter created with the typed dataset has a Connection ... connection string via the config file and use it in the dataaccess ...
    (microsoft.public.dotnet.languages.csharp)
  • Another connection string problem
    ... connection string stored in a .config file. ... main app projects and each contain the connection string key. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: InvalidOperationException: GetConfig was called during configurati
    ... although my code didnt attempt to pull the connection ... string from the config file. ... the connection string of SqlConnection shomehow forces the reading/validating ... "kosta" wrote: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Typed DataSets in VS2005
    ... SELECT mailbox, storage_group, server FROM atablename WHERE (mailbox = ... Why it need to have a connection string hradcoded to create ... string so that it will read it from a config file (obviously you have ... Does anyone know how to create typed DataSets using VS2005's new ...
    (microsoft.public.dotnet.languages.csharp)