ASP.net MVC 4, Connection string

Question

I am learning MVC4 from http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-models-data-from-a-controller (edit: Fixed URL)

Everything is working perfectly but my database isn't getting updated but when I run the project the records are coming from somewhere and I couldn't find that database in my MSSQL.

My connection string in web.config is

<connectionStrings>
    <add name="PurchaseInfosDbContext" 
         connectionString="server=lakpa-pc;Integrated Security=SSPI; User ID=sa; Password=xxxxx; database=MessInfo" providerName="System.Data.SqlClient" />
</connectionStrings>

but in the Visual studio when I debug I get the connection string as

"Data Source=.\\SQLEXPRESS;Initial Catalog=Mvc4Projects.Models.ItemsDetailsDbContext;Integrated Security=True;MultipleActiveResultSets=True"

Isn't it supposed to read the connection string from web.config. I haven't modified any connection string on any pages.

a. Is it necessary to include SDF file as shown in that tutorial? Can't I directly update it to mdf file?

My tutorial uses LocalDB. <connectionStrings> <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-MvcApplication1-20120816100809;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-MvcApplication1-20120816100809.mdf" providerName="System.Data.SqlClient" /> </connectionStrings> — RickAndMSFT
– RickAndMSFT, Commented Aug 16, 2012 at 17:09

Lakpa Sherpa · Accepted Answer · 2012-08-16 04:59:02Z

My problem was that the name of the class that was inheriting DbContext was different so MVC was taking default connection to SQLExpress even though I didn't specify it.

Well I changed the Class Name similar to Connection String name and now its pointing to correction location.

May be it will be helpful to someone. Problem faced and resolved

a. The Class that inherits DbContext must be used as a name for connection string.

b. The SQL Query that Entity framework add has plural table name so use the attribute [Table("PurchaseInfo")] to make it singular.

c. When using POCO method you will encounter a key problem if you don't follow its naming convention like in my example its Key must be "PurchaseInfoID" but I used ItemId . So use the attribute [Key] to solve this problem.

public  class PurchaseInfoDbContext : DbContext
    {
        public DbSet<PurchaseInfo> ItemsDetails { get; set; }
    }

    [DisplayName("Items Details")]
    [Table("PurchaseInfo")]
    public class PurchaseInfo
    {
        [HiddenInput]
        [Key]
        public int ItemId { get; set; }
}

Rami Ebeid · Accepted Answer · 2012-12-14 19:40:30Z

2

I have the same problem, if you already have App_Data Folder delete it and then add a new one from Project-> Add ASP.Net folder -> App_Data

answered Dec 14, 2012 at 19:40

Rami Ebeid

214 bronze badges

1 Comment

Rutix Over a year ago

Sorry but how would that fix the problem specified here? Can you elaborate your answer?

Pieter Germishuys · Accepted Answer · 2012-08-15 05:11:09Z

0

When you start a new MVC 4 project with the "Internet Application" it adds a default connection string that points to a sql express database. Are you sure that you don't have that connection string in your web.config still?

answered Aug 15, 2012 at 5:11

Pieter Germishuys

4,8861 gold badge28 silver badges34 bronze badges

1 Comment

Lakpa Sherpa Over a year ago

There is only one connection string in web.config. I search for all SQLExpress in whole project but I couldn't find it. But when I debug I see that SQLExpress connection string. When I open my MSSQL as SQLExpress, I see that it has created different database. That wasn't the one I was expecting.

Beena · Accepted Answer · 2014-02-12 14:08:03Z

0

I found this article - http://blogs.msdn.com/b/sqlexpress/archive/2011/12/09/using-localdb-with-full-iis-part-1-user-profile.aspx which resolves the issue. However this applies if user is running the App through IIS

answered Feb 12, 2014 at 14:08

Beena

1

Collectives™ on Stack Overflow

ASP.net MVC 4, Connection string

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related