Export and Deploy BDC model as a feature in Sharepoint


In this article we will be seeing how to export the BDC model using SharePoint Designer and deploy the BDC model as a feature using Visual Studio 2010.

In this article we will be performing the following steps:

  1. Export the BDC model using SharePoint Designer 2010

  2. Deploy the BDC model as a feature using Visual Studio 2010


1. Export the BDC model using SharePoint Designer 2010:

To create an external content types using SharePoint Designer refer http://msdn.microsoft.com/en-us/library/ee557243.aspx.

In this section we will be seeing how to export the BDC model using SharePoint Designer.

  • Open SharePoint Designer 2010.

  • Click on Open Site.










  • Enter the site URL and click on Open.Go to Navigation => External Content Types.
















  • I have created an External content type named "ECT" as shown in the following


  • Right click on ECT and click on "Export BDC Model".






  • Enter the BDC Model Name and click on Ok.






  • You will be getting the following dialog box






  • Save the file.











2. Deploy the BDC model as a feature using Visual Studio 2010:

  • Open Visual Studio 2010.

  • Go to File => New => Project.

  • Select Business Data Connectivity Model from the installed templates.


  • Enter the Name and click on Ok.

  • Enter the site URL for debugging and click on Finish.












  • By default the solution would have created BDCModel1 as shown in the following














  • Right click on BDCModel1 and click on delete.

  • Right click on the solution, click on Add => Existing item => Add the BDC model that we have exported and saved it on the local machine.








  • "Add .Net assembly LobSystem" wizard will pop up, select No and click on Ok.








  • Entire solution looks like the following.








  • Ensure whether the scope of the feature is at Farm level.










  • Right click on the solution and click on Deploy.









  • Go to Central Administration => System Settings =>Farm Management =>Manage Farm Features.


  • Go to Central Administration => Application Management => Manage Service Applications => Business Connectivity Service Application> you could be able to see the external content type deployed.


Recent Posts

See All