Events
May 19, 6 PM - May 23, 12 AM
Calling all developers, creators, and AI innovators to join us in Seattle @Microsoft Build May 19-22.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
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.
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.
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.
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.
Events
May 19, 6 PM - May 23, 12 AM
Calling all developers, creators, and AI innovators to join us in Seattle @Microsoft Build May 19-22.
Register todayTraining
Module
Design data models for Dynamics 365 solutions - Training
A data model workshop is part of Success by Design. This module will provide a basic description of data modeling for Microsoft Dynamics 365 and insight into how you can conduct a data model workshop.
Certification
Microsoft Certified: Dynamics 365 Business Central Developer Associate - Certifications
Demonstrate you have the skills to design, develop, test, and maintain solutions based on Dynamics 365 Business Central.