Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 Database Connection, in Visual Studio 2005...

views
     
TSPennywise
post Feb 20 2006, 10:25 PM, updated 20y ago

Look at all my stars!!
*******
Senior Member
5,796 posts

Joined: Jan 2003
Ok, I made my database connection.

I went to Server Explorer tab in my Visual Studio 2005's project, I right-clicked the 'Data Connections' and select 'Create New SQL Server Database...' blah blah blah... Made my connections to Employees.mdf.

When I click on the [+] and it expands, it break downs to:
Database Diagram
Tables
Views
Stored Procedures
Functions
Synonyms
Types
Assemblies


Anywhere I can get more help regarding these list of... functions? You know, nice explainations, not like those in MSDN, a little bit too complex for me to understand at my stage. Please help.
bobtiang
post Feb 20 2006, 11:19 PM

I live in a 6 STARS Hotel
******
Senior Member
1,788 posts

Joined: Jan 2003
From: 冰城

for connection string, you can visit www.connectionstring.com.
for the list of the item you mentioned, let me briefly go through it as per my understanding

DB Diagram
- to design the system logical diagram
Tables
- to creat tables in DB to hold data
Views
- something like a table which you predefined for better serach performance
Stored Procedures
- consists of compiled T-SQL for better performance, security implementation etc.
Funcsionts
- user defined functions
Synonyms
- <no idea>
Types
- user can always define own types other than system defined types
Assemblies
- self defined component which is compiled and ready to be used

pls correct me for anything thats wrong

 

Change to:
| Lo-Fi Version
0.0137sec    1.02    5 queries    GZIP Disabled
Time is now: 23rd December 2025 - 09:15 PM