Designer

Labels
AJAX(112) App Studio(9) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(178) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(184) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(3) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Designer
Monday, July 9, 2012PrintSubscribe
Overview of Commands

A command provides a developer-friendly dictionary of SQL expressions that correspond to the individual fields and also define the base table and joined tables. The application framework uses the command text elements to compose Select, Update, Insert, and Delete statements at run-time.

Command Properties:

Property Description
Controller Specifies the controller that the command belongs to.
Event Specifies which event that causes the command to execute.
Id Specifies the unique identifier for the command.
Table Name Specifies the table name to be used in automatically constructed Insert, Update, and Delete operations.
Text Specifies the text of the command.
Type Specifies the type of the command.

Learn how to work with commands in the Project Designer.

Learn to drag and drop commands in the Project Explorer.

Monday, July 9, 2012PrintSubscribe
Working with Commands in Designer

Commands are used by the controller to select data.

Commands can be accessed by selecting a controller and switching to the Commands tab.

List of commands in the Project Browser.

The context menu option List on the Commands node in the Project Explorer will also navigate to the list of commands.

List context menu option on Commands node in the Project Explorer.

A command can be located by entering the command Id and controller Name in the configuration navigator.

A command located in the project configuration navigator.

Clicking on the Id or using the context menu option View in the list of commands will navigate to the properties page of the command.

View context menu option in the Project Browser.      Properties page for a command in the Project Browser.

The Sync context menu option will select the relevant project configuration node in the Project Explorer.

Sync context menu option in the Project Browser.     Command1 node selected in the Project Explorer.

The command Id can be changed using the Rename context menu option in the Project Explorer.

Rename context menu option in the Project Explorer.

The Controller of the command can be changed by dragging the command node.

Dropping command1 on Commands node of Order Details.     Command dropped and renamed under OrderDetails controller.

Commands are recreated by the web application generator every time the baseline is refreshed. If the developer modifies the command, automatic recreation will no longer occur, and the developer must update the command by hand.

The “Reset to Baseline” context menu option will restore the command to baseline state.

Context menu option Reset to Baseline in the Project Explorer.

Sunday, July 8, 2012PrintSubscribe
Overview of Controllers

Controllers define metadata used by the application framework to retrieve data, present it to the users, and respond to actions in live applications.

Controller Properties:

Property Description
Allow Annotations Specifies if notes and files can be attached to individual data rows by users. Requires ASP.NET Authentication.
Conflict Detection Specifies a conflict detection strategy.
Connection String Name Specifies an alternative connection string name that is defined in the web.config file.
Controller Name Specifies the name of the controller. If the controller is derived from a table, the table name will be used.
Handler Specifies the name of a business rules class that can be extended to respond to controller actions. If the handler does not exist, it will be created when the application is generated.
Status Bar Specifies a status map that will be displayed to the end user.

Learn how to work with controllers in the Project Designer.

Learn to drag and drop controllers in the Project Explorer.

Common Tasks:

Task Description
Data Controller Virtualization Learn how to dynamically change the data controller elements at runtime.
Read-Only Data Access Learn how to control data editing capabilities by role.
Configuring Workflow Status Learn how to configure an automatic status bar reflecting the internal state of data objects