Get additional rich data views in the native ADO.NET datasets. ComponentOne ADO.NET DataExtender™ simplifies working with ADO.NET, automating reading the schema and data from the database, exposing database tables and views as regular ADO.NET objects, and providing an ability to set up customized data views.

Features

  • Simplified Data Binding

    Just one C1DataViewSet component serves as the binding agent for all tables and relations – without DataExtender, two components (a BindingSource and a DataAdapter) are required to represent each table or relation.

  • Data Source Representation

    The C1DataViewSet component can represent data from the Typed ADO.NET DataSet, Untyped ADO.NET DataSet, and Connection String data source types.

  • Automated Smart Update

    The C1DataViewSet.Update method automatically determines the sometimes crucial correct order in which rows should be committed to the server, taking into account master-detail relationships between tables. It also refreshes client row columns with new values generated on the server, including cases of server-generated auto-increment columns.

  • Composite Views

    Expose multiple related tables as a single row set by defining a composite view, either visually or using an SQL-like statement. As updates occur at the view or table level, DataExtender automatically synchronizes the affected row sets.

  • DataSet Object Mediation

    Although DataExtender works with ADO.NET, you don't have to deal with the DataSet object at all. At minimum, you can specify a connection string and DataExtender will automatically read the schema and data from the database, exposing database tables and views as regular ADO.NET objects and providing the ability to set up customized data views.

  • Typed View Set Definitions

    With DataExtender you can create strongly typed view set definitions that are global for your project. These typed DataViewSet, which have full IntelliSense support, reside as project level items and can be reused in multiple forms of your application.

  • Consistent Client and Server-side Filtering

    When its definition statement contains the WHERE clause, C1DataView performs server-side filtering which also operates as a client side filter.

  • Rich Customization

    The C1DataViewSet component represents a rich set of events for custom processing of row navigation and changing occurrences. For your convenience, all C1DataView events are propagated by the owning C1DataViewSet component and C1DataViewSet event data determines in which C1DataView an event has occurred.

  • Calculated Columns

    Specify read-only calculated columns in the C1ViewSetDesignerForm using any .NET-compatible language, or as part of the SQL-like statement that defines the view. The column expressions are evaluated at run time as navigation and updates occur through interaction with any bound control.

  • Constraint Expressions

    DataExtender supports column and row level data validation expressions using the syntax of any .NET-compatible language, allowing developers to define constraints of unlimited complexity. The visual designer also provides expression builders that handle many common data validation scenarios.

  • Ability to Attach Presentation Attributes to Data Columns

    Attach presentation attributes to data columns, including data entry masks, display formats, and value-translation maps with DataExtender. For example, show customer names instead IDs in an Orders table.

  • Surpasses View Level Limitations

    DataExtender goes beyond the view level boundaries. For example, it can fetch data from the server on demand and update the data back to the server, as well as, define additional constraints on the data.