This builder automatically generates basic search, create, retrieve, update, and delete operations for a relational database.
To use this builder, you must first publish the project that contains the model to which this builder is to be added.
This builder is designed for simple tables with a single primary key. If a primary key is not found, you can use the Key Field
input to select a field to use as the primary key. Inputs are provided for basic filtering and specifying which columns are returned in the result set. Based on the filter inputs, the underlying SQL statements are automatically generated and cannot be altered.
If you require advanced SQL capabilities, for example, complex join operations or Set and Cast Methods, use a SQL Call builder or lower level SQL builders with Service Definition and Service Operation builders to design and implement the services.
Typically used in a service provider model, this high-level builder encapsulates the functionality of several low-level SQL builders (SQL Data Source, SQL Statement, and SQL Transform to XML). The builder also encapsulates Service Definition and Service Operation builders. You do not need to add these builder calls to your service provider model.
Typically, you feed the data from this builder into another builder, for example, the Data Services User Interface builder. The Data Services User Interface builder automatically generates pages, forms, actions, buttons and other user interface components for the operations that this builder creates.
Parent topic: Builder Reference: wpf7
About using the builder call editor: wpf7