Getting error while implementing Code First modal in asp.net MVC application

I have created a sample MVC application from here:

CLICK HERE

I am using Visual Studio 2010 IDE. See the Setting the Connection String section.

Instead of SQL Server Compact Edition I want to directly work with SQL Server 2008 that is installed on my system so when I put following connection string in web.config i got an error message:

<add name="SchoolContext" connectionString="server=(local);database=School;user id=sa;password=1234;" providerName="System.Data.SqlClient" />

How to resolve this error?

Answers


Does the School database already exist? If so, delete it and let Code First recreate it.


Need Your Help

Django Rest Framework: Disable field update after object is created

django rest django-rest-framework

I'm trying to make my User model RESTful via Django Rest Framework API calls, so that I can create users as well as update their profiles.

How add html and text files to Sphinx index?

html search indexing search-engine sphinx

From Sphinx reference manual: «The data to be indexed can generally come from very different sources: SQL databases, plain text files, HTML files, mailboxes, and so on»