Entity Framework 6 not creating database

Question

Good day guys, I am using Entity framework 6 Code First to create a database from my model when my program first runs. To do this I initialize my model context in "Global.asax.cs" But when ever I run the program I get this error:

Format of the initialization string does not conform to specification starting at index 0.

Please help me guys. It is true that there tons of post on stack overflow concerning this error, but of all the posts that I have read they all need an existing connection string in web.config file. But in my case I don't have a database created already and trying to connect to it. What I do have is a model existing and expecting EF 6 to create a and initialize the database when the program first run.

I have tried this in web.config, but no result.

<entityFramework> <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework"> <parameters> <parameter value="mssqllocaldb"/> </parameters> </defaultConnectionFactory> <providers> <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" /> </providers> </entityFramework>

Here is my Global.asax file:

 public class MvcApplication : System.Web.HttpApplication { protected void Application_Start() { AreaRegistration.RegisterAllAreas(); GlobalConfiguration.Configure(WebApiConfig.Register); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); using (var context = new MultiTenantContext()) { var tenants = new List<Tenant>() { new Tenant() { Id = 1, Name = "COG", DomainName = "www.ChurchOfGod.com", Default = true }, new Tenant() { Id = 1, Name = "DIV", DomainName = "www.developers.com", Default = false }, new Tenant() { Id = 3, Name = "CW", DomainName = "www.carwash.com", Default = false }, }; context.Tenants.AddRange(tenants); context.SaveChanges(); } } }

Here is my model context and model class:

 public class MultiTenantContext : DbContext { public DbSet<Tenant> Tenants { get; set; } } public class Tenant { public int Id { get; set; } public string Name { get; set; } public string DomainName { get; set; } public bool Default { get; set; } }

Here is my controller:

 public class TenantController : Controller { public ActionResult Index() { using (var context = new MultiTenantContext()) { var tenants = context.Tenants.ToList(); return View(tenants); } } }

You still need a connection string in your config so that EF knows where to create the database. — Corporalis
– Corporalis, Commented Oct 28, 2016 at 11:54

Kenneth Bo Christensen · Accepted Answer · 2016-10-28 12:17:33Z

4

Edit your model to:

namespace WebApp.Models { public class MultiTenantContext : DbContext { public MultiTenantContext() : base("DB") { } public DbSet<Tenant> Tenants { get; set; } } }

Add this to web.config > configuration:

<connectionStrings> <add name="DB" connectionString="data source=.\sqlExpress;initial catalog=XXX;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" /> </connectionStrings>

answered Oct 28, 2016 at 12:17

Kenneth Bo Christensen

2,2962 gold badges20 silver badges23 bronze badges

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

4 Comments

Nathan Siafa Over a year ago

Thanks, but will this create the database in localdb?

user47589 Over a year ago

Do you see localdb in the connection string? It will create it in SQL Server Express.

Nathan Siafa Over a year ago

Thanks @Kenneth. I actually wanted the database to be created in localdb so, all I had to do was to alter the data source to localdb's and it work. One more thing I didn't alter my model, but I got it working. Can you tell me why I need to alter my model the way you did?

user47589 Over a year ago

@NathanSiafa by default a dbcontext will look for a connection string with a name that matches the name of the context (in your case, MultiTenantContext). In order to change the connection string to anything else, you'll need to override that behavior. This is what the base("DB") bit does. "DB" being the name of the connection string.

Collectives™ on Stack Overflow

Entity Framework 6 not creating database

1 Answer 1

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Related