How to connect a Code First Model Database to a GoDaddy remote Database?

Hey Guys.

The title pretty much says it all.

I have created a Database in MVC 3 with the Code First Entity Framework and I am almost ready to deploy but i have no clue on how to Deploy the database?

I do not need the data inside of it since it was just dummy data but i do not know how to edit the webconfig file to point to the database.

any help vwould be awesome !

Re: How to connect a Code First Model Database to a GoDaddy remote Database?

You can add an entry under <connectionStrings> in the .config, as with any other DB code, but with code-first the name just has to match the name of your DbContext-derived class. Also as another approach, you can pass a name into the DbContext ctor in the form "name=Foo" where "Foo" is the name you set in the <connectionStrings> section.

Re: How to connect a Code First Model Database to a GoDaddy remote Database?

Could i maybe get a example i think thats the problem i am having i know i have to pass that dbcontext to the connection string in webconfig i just dont know how to set that up...

Here is part of my model.

public class CareersConsoleDBContext : DbContext
    {
        public DbSet<CareersConsole> CareersConsole { get; set; }
    }

thats where the model tells it to connect it to a db

here is part of my webconfig.

<connectionStrings>
    <add name="CareersConsoleDB" connectionString="Data Source=|DataDirectory|CareersConsole.sdf" providerName="System.Data.SqlServerCe.4.0"/>
    <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
  </connectionStrings>

I tried to rename it accordingly but im not even sure its reading the file?..is there a way to make the connection between the two?

Re: How to connect a Code First Model Database to a GoDaddy remote Database?

For this DbContext:

public class PetsDB : DbContext {...}

I would need this in my .config:

  <connectionStrings>
    <add name="PetsDB"
         connectionString="server=..."
         providerName="..." />

And the other approach I said, you can do this:

    public class PetsDB : DbContext
    {
        public PetsDB(string name)
            : base(name)
        {
        }

        ...
    }
    
    var db = new PetsDB("name=Foo");

And then in the .config you could have:

  <connectionStrings>
    <add name="Foo"
         connectionString="server=..."
         providerName="..." />

Re: How to connect a Code First Model Database to a GoDaddy remote Database?

I still cant get the stupid thing to work.

I created a MS SQL database and got the provider name and the connectionstring from godaddy to input into my webconfig.

then i did what you said to do with the controller (basically name it the same as my db context into my webconfig file)

is there anything else that could be making the problem?..Like i said i ran this already on my localhost with Code First and it ran perfectly b ut trying to get this into production its not working everytime it saysing that it has encountered a error.

But i did notice something different..the timeout was alot faster this time around rather then when i had nothing so im thinknig its created and connected but im not sure if I actually have to build the database first or if the code first still builds it

Re: How to connect a Code First Model Database to a GoDaddy remote Database?

So the above connection string works with a local DB but not one hosted elsewhere? If that's the case, check for firewall issues or if their DB is even listening (Sql Server is on port 1433 by default). Not much else I can suggest or think of if it's environmental.

Re: How to connect a Code First Model Database to a GoDaddy remote Database?

You can see a sample connection string that works on Go Daddy shared hosting here.