The EntitySpaces Community

Share and learn about the EntitySpaces Architecture.
Welcome to The EntitySpaces Community Sign in | Join | Help
in
Home Forums Photos

dynamic connection strings

Last post 08-11-2008, 3:43 PM by joseluisrod. 2 replies.
Sort Posts: Previous Next
  •  08-11-2008, 1:24 PM 10690

    dynamic connection strings

    Hi, I am using Entity Spaces 2008 trial with my generation  1.3.0.3. the database is SQL 2005. Here is my situation. I have 10 databases. each database represents a US state. The users can pick which database they need to work on. We have a web service that returns the appropriate connection string based on the state you pass on. I have the connection set in an app.config file (winforms). I have read that once it is set in the app.config the connection string cannot be changed. What could be the work around? I don't want to put the 10 connections in the app.config and change the connection name. Do I need to move to configless execution? please confirm. Thanks in advance

     

    Jose Rodriguez

  •  08-11-2008, 2:00 PM 10692 in reply to 10690

    Re: dynamic connection strings

    Yes, if you do not wish to store your connections in your config file, then you should use configless. Just be aware that the two methodologies are mutually exclusive do the .net configuration class implementation.

    Regards,

    Scott Schecter
    EntitySpaces | My Site
  •  08-11-2008, 3:43 PM 10694 in reply to 10692

    Re: dynamic connection strings

    excellent. Thanks.
View as RSS news feed in XML