Quick Objects Data Source for ASP.NET is a data source control that leverages the Business Logic Framework and simplifies the data binding process even further. The data source control gives you all the flexibility and control along with a unmatched and simplified design time experience. The data source controls support features like paging, search criteria, insert, update, delete and out of the box concurrency management. All this is can be used and your centralized business logic and validation rules will still apply. The data source control can be used in offline or online mode as well. In offline mode all the changes will be retained, and can by synchronized at a later stage.
Data Source Properties:
Common Select Properties:
- All Fields Visible - This property can be used to toggle visibility of all the fields. This has the same affect as using the UseAllFieldsForDisplay method in code.
- Case Conversion - This property can be used to control whether the business object will convert the case of the string fields to upper or lower.
- Translate Time Zones - This property can be used to enable automatic time zone translations. Please note: This property requires the installation of SQLTimeZones component and it is only available when used with SQL Server 2005.
Find Method Specific Properties:
- Match Any - This property can be used to set if all or any of the parameters will be matched for search criteria. Setting it to Yes will use OR clause between each parameter. You can override this setting at each parameter level as well.
- Partial Match - This property can be used to enable Partial Text Matching on string fields. You can override this setting at each field level.
- Distinct - Causes the business object to only return records with distinct values.
- Maximum Records - This can be used to set a limit on number of records returned by the Find method.
Insert/Update/Delete Methods:
These methods must be enabled by checking on the check box on each corresponding Tab. Enabling the method automatically adds the necessary parameters, and you can modify the parameters or remove them as necessary.
Parameters:
Common Properties and their applicability:
- UseInSearch - it is only applicable when Find method is being used for the Select command, and is completely ignored in all other scenarios.
- UseInSave - it is only used in Insert or Update command. If you do not set the UseInSave to Yes or No, and a value is supplied for the parameter, the Data Source automatically switches the underlying field's UseInSave to True. However, if the value will not be supplied at runtime and you would like to use the DefaultValue you must set the UseInSave property of the parameter to Yes.
- PartialTextMatch - only applicable during Find method. Use the PartialTextMatch property of the Data Source for global setting, or use the PartialTextMatch at parameter level to control the field level setting.
- SearchMode - Two SearchModes are supported, i.e. Value or ValueOrNull.
- SearchCondition - Two possible values AND/OR.
- Operator - For a possible list of values please take a look here.
- SortType - SortType is only applicable to Find method, and it directly maps to the field object's Sort property.
- SortPosition - SortPosition is only applicable when Find method is used and a SortType is specified. SortPosition is used as the position of the field in the sort order.
- Visible - is only applicable to Select method (both Find and Load). This property maps directly to the field object's Visible property, and will dictate if the business object should include this field in the result set.