When you generate a new entity framework project in C#, it generates an Application context object, which is very insistent on reading it’s connection from the connection strings settings of the web.config:<\/p>\n
\npublic class ApplicationDbContext : IdentityDbContext\n{\n public ApplicationDbContext()\n : base(\"DefaultConnection\", throwIfV1Schema: false)\n {\n }\n\n public static ApplicationDbContext Create()\n {\n return new ApplicationDbContext();\n }\n}\n<\/pre>\nIdeally you don’t want to check in the connection string. If you’re using AppHarbor, their UI helpfully lets you add AppSettings, but it takes some juggling to get these into the app context.<\/p>\n
You still need to have a connection string, but you can leave it blank:<\/p>\n
\n\n For testing purposes, you should also add your own AppSetting by adding this to the web.config:<\/p>\n
\n\n \"\/>\n<\/appSettings>\n<\/pre>\nThen, modify the Application_Start to read the appSetting and hack it into the connection string:<\/p>\n
\nprotected void Application_Start()\n{\n var connections =\n ConfigurationManager.ConnectionStrings;\n\n ConnectionStringSettings \n defaultConnection = null;\n\n foreach (ConnectionStringSettings c in connections) \n {\n if (\"DefaultConnection\".Equals(c.Name))\n {\n defaultConnection = c;\n }\n }\n\n var fi = \n typeof(ConfigurationElement)\n .GetField(\"_bReadOnly\", \n BindingFlags.Instance | \n BindingFlags.NonPublic);\n\n fi.SetValue(defaultConnection, false);\n\n defaultConnection.ConnectionString = \n ConfigurationManager.AppSettings[\"db_connection_string\"];\n}\n<\/pre>\n