Prerequisites: Tutorial 2 - Adding Schema Items.
Working quickly, a developer maybe would have spent somewhere in the range of
3-5 minutes performing all the previous tasks. The only thing left to do at
this point is to generate your source code. Before you do, there are two
settings to check. The first is your run-time database settings. To do this,
select the Data Object node in the Project Explorer. In the Properties pane,
select Database Name and type in the name of the database you want your code to
connect to and run-time. The master database is the default value. Check all
the other settings here as well and make sure the values are what your system
wil need at run-time.
The other important setting before generating your code is your choice of
language: C# or VB.Net. This property is available at the project level.
To generate source code, select Build from the Build menu or hit F5.
You will now see the Build Progress window as TCDesigner reads your project and
generates thousands of lines of high-quality source code. Remember -
TCDesigner is putting all the generated code in the output directories you can
see on the screen cap above.
Before you can run your system, you will need to create the stored procedures
that you just generated. TCDesigner generates a lot of stored procedures. To
make it easy to execute the create statements, select Run Procedures
from the Tools menu.
SQL Runner, a utility program, will now start. Simply tell SQL Runner where the
stored procedures are and what file naming pattern to look for. Click
the Run button when ready.
Last steps: Tutorial 4 - Creating a Visual
Studio Project.
