Entity Framework 5.0 and Code First not creating sql database.

Posted on 2012-08-29
Last Modified: 2012-08-29
Im really confused because in the past Ive created these and they just work right out of the gate.  But all of a sudden with visual studio 2012 and EF 5.0 I create a simple mvc 4 Intranet application and I ran into a couple major issues.  One with IIS 7.5 express on my local machine not authorizing me.  But I just switched my project to run on localhost and that took care of that.  But the issue Im asking about here is why its not creating my sql server db based on my model into sql server express.  I have added nothing to my web.config in terms of connection strings.  Also I have not enabled migrations in the Package Manager Console.  When I try to do that it says it cant find a context.  But I thought I had that taken care of in my model folder.  

With earlier versions of EF codefirst Ive not had this issue.  If someone could help me figure this out I would appreciate it.  I havent been able to find anything online to help.
Question by:rochestermn

    Author Comment

    Here is the web.config

    <?xml version="1.0"?>
      For more information on how to configure your ASP.NET application, please visit
        <!-- For more information on Entity Framework configuration, visit -->
        <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>
       <add name="Benchmark_DBConnectionString"
          connectionString="Data Source=CITY-23078\SQLEXPRESS;Initial Catalog=BenchmarksDB;Integrated Security=True"
          providerName="System.Data.SqlClient" />
        <add key="webpages:Version" value=""/>
        <add key="webpages:Enabled" value="false"/>
        <add key="PreserveLoginUrl" value="true"/>
        <add key="ClientValidationEnabled" value="true"/>
        <add key="UnobtrusiveJavaScriptEnabled" value="true"/>
        <compilation debug="true" targetFramework="4.0"/>
        <authentication mode="Windows"/>
          <deny users="?"/>
        <pages controlRenderingCompatibilityVersion="4.0">
            <add namespace="System.Web.Helpers"/>
            <add namespace="System.Web.Mvc"/>
            <add namespace="System.Web.Mvc.Ajax"/>
            <add namespace="System.Web.Mvc.Html"/>
            <add namespace="System.Web.Optimization"/>
            <add namespace="System.Web.Routing"/>
            <add namespace="System.Web.WebPages"/>
        <validation validateIntegratedModeConfiguration="false"/>
          <remove name="ExtensionlessUrlHandler-ISAPI-4.0_32bit"/>
          <remove name="ExtensionlessUrlHandler-ISAPI-4.0_64bit"/>
          <remove name="ExtensionlessUrlHandler-Integrated-4.0"/>
          <add name="ExtensionlessUrlHandler-ISAPI-4.0_32bit" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0"/>
          <add name="ExtensionlessUrlHandler-ISAPI-4.0_64bit" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0"/>
          <add name="ExtensionlessUrlHandler-Integrated-4.0" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" type="System.Web.Handlers.TransferRequestHandler" preCondition="integratedMode,runtimeVersionv4.0"/>
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
            <assemblyIdentity name="System.Web.Helpers" publicKeyToken="31bf3856ad364e35"/>
            <bindingRedirect oldVersion="" newVersion=""/>
            <assemblyIdentity name="System.Web.Mvc" publicKeyToken="31bf3856ad364e35"/>
            <bindingRedirect oldVersion="" newVersion=""/>
            <assemblyIdentity name="System.Web.WebPages" publicKeyToken="31bf3856ad364e35"/>
            <bindingRedirect oldVersion="" newVersion=""/>
        <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework"/>

    Open in new window


    Author Comment

    Solution/properties window.  I manually created the folder migrations.  But I have not created a configuration class.  I wasnt sure if that gets automatically created when I run enable-migrations from PM.  

    solution window

    Author Comment



    Author Comment

    The model via code first.


    Author Comment

    the context class

    the context

    Author Comment

    I think I need to add something like this to my config.

    context section

    Accepted Solution

    Ive found a solution for this.  I deleted my existing context and let vs create a new one from scratch.  Then added a new controller based on the model and the context and it scaffolded out my views and created the db.  You may close this ticket.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Windows phone Development 11 15
    Pick image, show data 4 25
    c# string 6 28
    How to compare two table schema using c#? 6 0
    Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
    Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now