publishing Db after creating using EF Code first

Question

I have created a project in MVC 3 using code first and nugget , And I would like to clear a few thing before publishing to my shared hosting: In my project I have a class name: IchudShulContext (IchudShul is my project name) In my sql server express it has created a DB name: IchudShul.Models.IchudShulContext.dbo Does it make a different what name I give my shared hosting DB ? Or should it match one of the following : IchudShul / IchudShulContext My local connectionStrings look like this :

connectionString="Data Source=MyPc-MAINPC\SQLEXPRESS;Initial Catalog=IchudShul.Models.IchudShulContext;Integrated Security=True"
     providerName="System.Data.SqlClient" />

Thanks

Kamyar · Accepted Answer · 2011-10-02 08:42:29Z

1

Based on Code-First convention, Your ConnectionString name in your web.config should have the same name as your context. Database name is not important. in your scenario, in your web.config:

<connectionStrings>
  <add name="IchudShulContext" providerName="System.Data.SqlClient" 
    connectionString="Data Source=MyPc-MAINPC\SQLEXPRESS;Initial Catalog=WHATEVER_YOUR_DB_NAME_IS;Integrated Security=True" />
</connectionStrings>

If you want to use conventions, make sure the name attribute is: IchudShulContext. That's all. Fill in WHATEVER_YOUR_DB_NAME_IS with whatever you db name is.

edited Oct 2, 2011 at 8:42

answered Oct 2, 2011 at 7:54

Kamyar

18.8k9 gold badges101 silver badges174 bronze badges

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

Comments

Daryl Teo · Accepted Answer · 2011-10-02 07:53:50Z

0

Your shared hosting DB can be named anything.

Your ConnectionString should be updated needs to be updated to point to your database. What that is, you will need to know from your shared hosting provider.

answered Oct 2, 2011 at 7:53

Daryl Teo

5,5251 gold badge34 silver badges42 bronze badges

Comments

Abdul Qadir Memon · Accepted Answer · 2011-10-02 11:51:09Z

0

you can name you DB anything, as long as it is valid with respect to your DBMS. the only this that should be matched with your datacontext name is connection name in connection strings section of your web.config file.

answered Oct 2, 2011 at 11:51

Abdul Qadir Memon

1,0591 gold badge15 silver badges30 bronze badges

Collectives™ on Stack Overflow

publishing Db after creating using EF Code first

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related