AllExperts > VB.NET 
Search      
VB.NET
Volunteer
Answers to thousands of questions
 Home · More VB.NET Questions · Answer Library  · Encyclopedia ·
More VB.NET Answers
Question Library

Ask a question about VB.NET
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Syed Rizwan Muhammad Rizvi
Expertise
I can answers questions regarding web based and desktop based programming in VB.Net. Which can include SOAP, XML, Custom Controls, COM Interoperability etc.

Experience
Have been working in this specific area for last 2 years previously I was a VB 6 Developer with experties in other languages as well. Total 10 years of programming experience.

 
   

You are here:  Experts > Computing/Technology > Microsoft .NET > VB.NET > How to auto-generate dynamic connectionstring?

VB.NET - How to auto-generate dynamic connectionstring?


Expert: Syed Rizwan Muhammad Rizvi - 10/7/2009

Question
QUESTION: I follow online 3-tier sample application. One advice is to use app.config to keep connectionstring. He tells to click on the connection item in component class and find "Dynamic properties" section and find check box on "map a key to configuration file". However, I cannot find "Dynamic properties" section in properties window, so dynamic configuration cannot be set automatically in app.config. What's wrong?

ANSWER: Late reply, wasn't able to check my emails lately.

Would you please tell me what kind of application are you creating? is this a web application or windows form application. You will need to provide me with the exact template name that you are using. Also what are you trying to use as a data layer? can you also provide me the link to the website you are referring to.

Regards,
Riz

---------- FOLLOW-UP ----------

QUESTION: It is just a typical window form application for the moment. I need to separate data layer because I can be easier to switch testing and production environment. I follow the sample in http://www.15seconds.com/issue/051103.htm but I cannot follow in data access layer section because of the question I asked.

ANSWER: what version of Visual Studio are you using?

Regards,
Riz

---------- FOLLOW-UP ----------

QUESTION: visual studio 2008, database: either MS Access or SQL 2008 express, no luck.

Answer
Yeah thats why the steps described for 2k3 and 2k5 are not available on 2k8 the data layer technologies unforetunately changed in all the three versions.

Now in 2k8 when you create an Entity during the wizard, the connectionstring is automatically written to app.config, you can search for it in app.config by searching for your entity name.

Hope this answers your question.

Regards,
Riz

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.