Developer Studio Step 1
Create a dGraph
To create a dGraph, click on the "File" then "New" menu. You will be prompted with a screen to enter database information. A dGraph imports your database schema and allows you to structure the schema in such a way that pulls back results in a way that meets your business requirements.
The first thing to do is define a name for the dGraph. This can be anything you wish and is a unique identifier so multiple dGraphs can exist in a single SQL Server database. You will use this key to query a specific dGraph at runtime. The other parameter is what version of SQL to use. Currently SQL Server 2000 and 2005 are supported.
Next we setup the database information we wish to use to pull the database schema. Just enter your server, database name, and connection information. Upon pressing the next button the schema will be pulled as a base for this dGraph.
The final screen is to choose your primary table. This the table on which all other data is related. The primary table is a one-to-one mapping of the desired records to your database. For example, if you building an automobile listing site then the listings are autos. Your primary table would be the table in which you save rows of automobiles. As another example, if your site is listing jobs, then your primary table would be the "JOB" table (or whatever table holds jobs). All information queried must be related to the primary table by a database relationship.
The new dGraph wizard prompts you for the graph name and the connection information to the source database. It will then import all data schema information from the source database. When the import is complete you will be prompted for the primary table. This is the table around which all data rotates. The primary table holds your search objects in a one-to-one mapping. After you accept these settings the wizard will disappear and the normal dGraph editor will be loaded with this new dGraph.
