BDC model design tools overview

Applies to: yesVisual Studio noVisual Studio for Mac

Note

This article applies to Visual Studio 2017. If you're looking for the latest Visual Studio documentation, see Visual Studio documentation. We recommend upgrading to the latest version of Visual Studio. Download it here

You can design a Business Data Connectivity (BDC) model by using the BDC Designer, the BDC Method Details window, and the BDC Explorer.

The BDC Explorer enables you to browse the model, search the model, and define type descriptors.

BDC Designer

The BDC Designer enables you to define the entities in your model and to visually arrange their relationships with one another. Use the BDC Designer to accomplish the following tasks:

  • Add entities to the model.

  • Remove entities from the model.

  • Define relationships between entities.

    To open the BDC Designer, double-click the model file in your project, or open the shortcut menu for the model file and then choose Open. Add an entity to the model by dragging or copying an Entity from the Toolbox onto the designer. To create an association between two entities, choose the Association control in the Toolbox, choose the first entity, and then choose the second entity.

BDC Method Details window

Use the BDC Method Details window to define the parameters, instances, and filter descriptors of a method.

You can quickly generate Finder, Specific Finder, Creator, Updater, and Deleter methods in the BDC Method Details window. When you generate these methods, Visual Studio adds metadata, such as parameters, instances, and type descriptors, to the method. You can modify this metadata to satisfy your specific scenario.

To open the BDC Method Details window, on the menu bar, choose View > Other Windows > BDC Method Details.

To view methods in the BDC Method Details window, choose the entity in the BDC Designer. The methods of the selected entity appear in the BDC Method Details window. If you do not choose an entity in the BDC Designer, the BDC Method Details window displays no information.

Expand or collapse nodes in the BDC Method Details window to define parameters, instances, and filter descriptors. Use the BDC Explorer to define type descriptors.

BDC Explorer

The BDC Explorer displays the elements that make up the model. To open the BDC Explorer, on the menu bar, choose View > Other Windows > BDC Explorer. To browse the model, expand nodes in the BDC Explorer. Each node represents an element in the XML of the model file.

As you choose nodes in the BDC Explorer, the properties of each node that you choose appear in the Properties window. Many of these properties correspond to attributes in the model file. You can search the model by using the search box at the top of the BDC Explorer.

Note

The BDC Explorer does not display identifiers, custom properties, localized strings, association groups, actions, filter descriptors, action control lists, and the default parameter values.

Define type descriptors

Use the BDC Explorer to define type descriptors. The BDC Explorer enables you to define a type descriptor one time and then reuse that type descriptor elsewhere in your model. To accomplish this, copy a type descriptor and paste it onto any other parameter or type descriptor.

Note

Changes to an original type descriptor do not affect the copies of that type descriptor.

For more information, see How to: Define the type descriptor of a parameter.

See also