|
Choosing datasource
tables and views to build ASP.NET code
After you successfully connected to
database, check off all datasource tables you'd like to build
ASP.NET code for. After that highlight one of selected tables and
step through other screens in ASPRunner.NET adjusting settings for
selected table. You can always see name of currently selected table
in the middle of blue info pane.
 NOTE: ASPRunner.NET use
SubSonic as a Data Access Layer framework. You can find more about
SubSonic at http://www.subsonicproject.com.
DAL limitations: Every database table needs to have one primary
key. Compound primary keys not supported.
To switch between selected tables
use Table list button on the
left.
 
If you'd like to keep default settings for
the rest of tables jump to Output
directory tab and build ASP.NET
code.
Using
Add new table window you can add a new table to
existing database.
For each field type
name, type, size, scale (applies to DECIMAL datatype in SQL Server,
Oracle and MySQL only). Set the Primary key field. Databases
created with ASPRunner.NET
will be saved into
C:\Program Files\ASPRunner.NET\database.mdb (database1.mdb, database2.mdb
etc.)
NOTE: Don't
change table settings after you've built the
project and added data
records. All data will be lost after table
modification.
To edit or delete tables right click on the table name in the
list.
Add
table view
This
feature creates an additional view of the same table. This feature
is useful when you like to present several views of the same
data.
Example:
Table
Cars shows all cars in the database. SQL query: Select * from
Cars.
View Active listings displays active listings
only. SQL Query: Select * from Cars
where status='active'
View Closed listings displays closed
listings
only. SQL Query:
Select *
from Cars where status='closed'
SQL
query can be modified later on SQL query tab in ASPRunner.NET.
|
