What is the difference between adding connection from the database explorer and adding new item->sql server database file in the solution explorer? both are connecting to database. In the former im getting the
<myhost name>\sqlexpress.<my database name>.dbo in database explorer, but in the later im getting the
<databasename>.mdf file containing table,stored procedures etc in the solution explorer
When you add a database connection in the server explorer, you do not create a new database. You just create a connection to an existing database which can be on any accessible server.
Where as when you add a new sql server database, it will create a new .mdf database file and at the same time will how the structure of it which is initially empty.
Please Mark As Answer if it helped.
MCPD ASP.NET 4.0 and 3.5, MCTS WSS, MOSS, SharePoint 2010, MCT
Microsoft Community Contributor Award 2011
rafemuhammed
Member
302 Points
97 Posts
sql connection
Nov 27, 2010 07:54 AM|LINK
What is the difference between adding connection from the database explorer and adding new item->sql server database file in the solution explorer? both are connecting to database. In the former im getting the <myhost name>\sqlexpress.<my database name>.dbo in database explorer, but in the later im getting the <databasename>.mdf file containing table,stored procedures etc in the solution explorer
rafes.net
adeelehsan
All-Star
18221 Points
2724 Posts
Re: sql connection
Nov 27, 2010 12:35 PM|LINK
Hi
When you add a database connection in the server explorer, you do not create a new database. You just create a connection to an existing database which can be on any accessible server.
Where as when you add a new sql server database, it will create a new .mdf database file and at the same time will how the structure of it which is initially empty.
MCPD ASP.NET 4.0 and 3.5, MCTS WSS, MOSS, SharePoint 2010, MCT
Microsoft Community Contributor Award 2011