Outline ·
[ Standard ] ·
Linear+
Database Connection, in Visual Studio 2005...
|
TSPennywise
|
Feb 20 2006, 10:25 PM, updated 20y ago
|
|
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
|
Feb 20 2006, 11:19 PM
|
|
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
|
|
|
|
|