EF4 code first create connection string programmaticaly

Question

I am successfully creating database (SQL Ce) using Entity Framework Code First approach (C#-WPF). I am trying to simulate creation of database per project. Meaning that user could open file dialog window, select / create desired folder for project and then access existent or create new database. Which leads me to a question how can i create / read database connection file per specific project.

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionStrings>
    <add name="NerdDinners"
         connectionString="Data Source=\Projects\NerdDinners.sdf"
         providerName="System.Data.SqlServerCe.4.0"/>
  </connectionStrings>
</configuration>

It is offtopic a bit, but i would recommend to use NHibernate instead of EF. I've tried to use EF at first, but then I found that NHibernate is much easy to configure for Code-First approach. If you want, I can provide you a link for a fast start Guide. — Seekeer
– Seekeer, Commented Nov 24, 2011 at 12:25
Actually EF with poco is quite easy for code first approach, but this seems to be more a matter of personal taste. I was going to use NHibernate with SQLite at the beginning but dropped the idea due to limited time to research. I am open for any other alternative approach though. Thanks — Jim
– Jim, Commented Nov 24, 2011 at 12:35

Wouter de Kort · Accepted Answer · 2011-11-23 22:20:44Z

1

Your connection string is stored in your app.config. When executing your WPF program you can only access the current app.config of the executing assembly. So there is no default way to open different app.config files for each project.

You could however use OpenExeConfiguration which lets you specify a path to a config file.

Or you could save multiple configration strings in the app.config of the executing application and give them different names. By using SqlConnectionStringBuilder you can manage the content of the string.

answered Nov 23, 2011 at 22:20

Wouter de Kort♦

40k13 gold badges88 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Jim Over a year ago

Actually I am not going to load default project when the application starts. The process is the following: Start app-> Create project (new folder, new connection file,new database and ) -> Load project (read connection file and load database)

Wouter de Kort Over a year ago

Then you could use the SqlConnectionStringBuilder to build a connection string that points to your project/database and pass that as to the constructor of your DbContext so it will use this connection string.

Jim Over a year ago

Thanks, for pointing to the right direction... Do you have by any chance any sample to reproduce the above connectionstring?

Wouter de Kort Over a year ago

Does this help? stackoverflow.com/questions/6003085/…

Jim Over a year ago

Hi, I've managed to do it using stackoverflow.com/questions/7458513/… and post about it webpixel.gr/blog/net-blog/…

Collectives™ on Stack Overflow

EF4 code first create connection string programmaticaly

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related