StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POConnect MVC 3 application to sql server 2008
primarykey
Id
12067343
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-08-22T06:22:12.413
FavoriteCount
0
LastActivityDate
2012-12-17T18:47:28.547
LastEditDate
2012-08-22T06:45:49.837
LastEditorUserId
1182982
OwnerUserId
1452811
ParentId
0
PostTypeId
1
Score
0
ViewCount
3089
LastEditorDisplayName
text
Body
I am newbie and confused how to do it. I have built MVC 3 application in Visual Studio 2010 and published to the localhost and it's working fine. Here, What I actually want is to use the Sql Server 2008 installed in my computer rather than database under the folder APP_DATA that I have created using visual studio. I am new to the MVC and don't know about the database connection detailly. Following is the connection string of the web.config file: <pre><code> <connectionStrings> <add name="IVRControlPanelEntities" connectionString="metadata=res://*/Models.IVRControlPanelModel.csdl|res://*/Models.IVRControlPanelModel.ssdl|res://*/Models.IVRControlPanelModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=.\SQLEXPRESS;attachdbfilename=|DataDirectory|\IVRControlPanelDB.mdf;integrated security=True;user instance=True;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" /> </connectionStrings> </code></pre> This is the connectionstring automatically added by the visual studio while adding the data entity model. After published to localhost the database used by mvc 3 is under the APP_DATA folder of wwwroot folder. What I need to change to connect to the Sql Server 2008 installed in my computer rather than database created on the Visual Studio. One more thing, I could not import the database created by visual studio to the sql server 2008 which is in the form IVRControlPanelDB.mdf
Tags
<asp.net-mvc-3><sql-server-2008><entity-framework-4><connection-string>
Title
Connect MVC 3 application to sql server 2008
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USYasser
UserOwnerUserId
1. USCodeManiac
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
2. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
3. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POConnect MVC 3 application to sql server 2008
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTApproveEditSuggestion
CommentsPostId
1. COYou can't import mdf files directly. You can create a database and attach a mdf file then.
 singulars
 PostPostId
 POConnect MVC 3 application to sql server 2008
 UserUserId
 USYvesR

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.