Knowledge Base

Articles:
• Creating RapTier Templates

Reviews:
• By Brian Noyes at asp.netPRO.
• By Mike Gunderloy at ADTmag.com.
• By Ted Ogrean, Pharmed Corporation

How To:
• Retrieve data from table
• Retrieve data using BETWEEN operator
• Retrieve single row using unique foreign key
• Retrieve single column value
• Read through large table
• Use paging
• Insert data into table
• Insert record with DEFAULT values
• Insert multiple value objects/records
• Update data in table
• Delete data from table
• Use transactions
• Switch to non-OleDb data provider
• Storing connection string in web.config
• Pass connection string to DB-tier code
• Generate GetBy method for each column
• Generate code for JOINs
• Rename DataGrid column headers
• Bind multiple data columns to single UI control
• Open RowEditor in dialog form
• Add support for many-to-many relationships(Template example)
• Display FK display values instead of PK IDs
• Call stored procedure with OUTPUT parameters
• Use wrapped stored procedures
• Generate stored procedures that support NEWID()
• Add generated stored procedures to database
• Automatically add generated stored procedures to MS SQL Server (Template example)
• Generate code that supports Oracle TIMESTAMP fields