|
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.
In the Menu - Create
menu item for this table you can
rename table in Caption box.
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.
- Modify table and Delete
table buttons.
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.
Setting
master-detail relationship between tables
Master-Detail relationships are very common in applications. An
example of this type of relationship is an order with a header and
line items. In ASPRunner.NET
you can join, or link, two or more data sets that have at least one
common field. This topic
explains master-detail relationships in great details.
1.
To create master-detail relationship in ASPRunner.NET
check off both master and detail tables in the list of datasource tables.
2.
Highlight Details table in the list.
3.
Choose Master table from the dropdown box.
4.
Choose Master table Primary key
5.
Choose Details table Foreign key (field that matches Primary key in
the Master table)
6.
If you'd like to display Master record info on the Details page check
off corresponding checkbox.
One Master table can have multiple Details tables.
|
