How To

• Retrieve data from table
• Retrieve data using BETWEEN operator [web]
• Retrieve single row using unique foreign key [web]
• Retrieve single column value [web]
• Read through large table [web]
• Use paging
• Insert data into table
• Insert record with DEFAULT values [web]
• Insert multiple Data Transfer Objects (records) [web]
• 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 [web]
• Generate code for JOINs
• Modify generated WinForm UI code
• Modify generated WebForm UI code
• Rename DataGrid column headers [web]
• Bind multiple data columns to single UI control [web]
• Open RowEditor in dialog form [web]
• Add support for many-to-many relationships(Template example)[web]
• Display FK display values instead of PK IDs[web]
• Add generated stored procedures to database
• Automatically add generated stored procedures to MS SQL Server (Template example)[web]
• Generate stored procedures that supports NEWID() [web]
• Call stored procedure with OUTPUT parameters [web]
• Use wrapped stored procedures [web]
• Generate code that supports Oracle TIMESTAMP fields [web]