The database does not appear in Visual Studio (2010) either under the models or AppData folders. Do I have the option to access / manipulate the data through VS or can I only do this using the MSSQLExpress interface?
The database does not appear in Visual Studio (2010) either under the models or AppData folders. Do I have the option to access / manipulate the data through VS or can I only do this using the MSSQLExpress interface?
My apologies...I may be confusing terms...I'm running application that is called 'Visual Web Developer 2010 Express' displayed at top of running application which is from a folder that is called 'Microsoft Visual Studio 2010 Express.' I've never been clear
as to the distinction, if any, between the two, if any.
In this 'Visual Web Developer 2010 Express' there is no 'Data' folder from which to choose the 'Data Sources' window. What I do have in 'Visual Web Developer 2010 Express' is a 'Database Explorer' pane at right with a 'Data Connections' icon, appearing as
the only item within it, which does not display the data source that I am successfully connected to (successful connection based on being able to create new and log on as existing users). The 'Data Connections' icon allows me to try to connect to my database
but it gives an error stating that I am already connected to it.
So...the questions then are...
1. What is the difference between 'Microsoft Visual Studio 2010 Express' and 'Microsoft Visual Developer 2010 Express?'
2. Why does the 'Microsoft Visual Developer 2010 Express' 'Data Connections' window not allow me to see and work with the database that it says I am connected to?
3v3rhart
Member
159 Points
317 Posts
MSSQLExpress database access / manipulation through Visual Studio
Nov 29, 2012 05:57 PM|LINK
Using the 'internet application' template to create a project in a brand new MVC 4 / VS 2010 project data is created at the following path in the OS:
C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\
Question:
The database does not appear in Visual Studio (2010) either under the models or AppData folders. Do I have the option to access / manipulate the data through VS or can I only do this using the MSSQLExpress interface?
CPrakash82
All-Star
18286 Points
2842 Posts
Re: MSSQLExpress database access / manipulation through Visual Studio
Nov 29, 2012 10:31 PM|LINK
You can do it through Visual studio.
http://msdn.microsoft.com/en-us/library/fxk9yw1t.aspx
3v3rhart
Member
159 Points
317 Posts
Re: MSSQLExpress database access / manipulation through Visual Studio
Nov 30, 2012 01:21 PM|LINK
Thank you for the reply CPrakash82.
My apologies...I may be confusing terms...I'm running application that is called 'Visual Web Developer 2010 Express' displayed at top of running application which is from a folder that is called 'Microsoft Visual Studio 2010 Express.' I've never been clear as to the distinction, if any, between the two, if any.
In this 'Visual Web Developer 2010 Express' there is no 'Data' folder from which to choose the 'Data Sources' window. What I do have in 'Visual Web Developer 2010 Express' is a 'Database Explorer' pane at right with a 'Data Connections' icon, appearing as the only item within it, which does not display the data source that I am successfully connected to (successful connection based on being able to create new and log on as existing users). The 'Data Connections' icon allows me to try to connect to my database but it gives an error stating that I am already connected to it.
So...the questions then are...
1. What is the difference between 'Microsoft Visual Studio 2010 Express' and 'Microsoft Visual Developer 2010 Express?'
2. Why does the 'Microsoft Visual Developer 2010 Express' 'Data Connections' window not allow me to see and work with the database that it says I am connected to?
Thanks again for your help.