Unable to retrieve BDC entities to SharePoint site

Question

Hi All,

I have used 'Microsoft.Office.Server.ApplicationRegistry.MetadataModel.ApplicationRegistry' in my code for Loading the BDC applications to a dropdown in MOSS 2007 site. It worked fine and BDC applications and entities were loaded to the dropdowns.

Now I have migrated the site to SharePoint 2010 and it gives the following warning :

'Microsoft.Office.Server.ApplicationRegistry.MetadataModel.ApplicationRegistry' is obselete: 'O12 Application Registry API is deprecated. Please Use BusinessData.'

However I am able to build the code in VS. But the BDC applications are not loaded to the dropdown.

Can someone suggest me on what I have to do?

Thanks in advance :)

Answer 1

You need a reference to Microsoft.SharePoint.dll and Microsoft.BusinessData.dll then the foloowing code

BdcServiceApplicationProxy p =

      (BdcServiceApplicationProxy)SPServiceContext.Current.GetDefaultProxy(

      typeof(BdcServiceApplicationProxy));           

DatabaseBackedMetadataCatalog catalog = sap.GetDatabaseBackedMetadataCatalog();

IEntity ect = catalog.GetEntity("MyEntityNamespace", "MyEntityName");

ILobSystem lob = ect.GetLobSystem();

ILobSystemInstance lobi = lob.GetLobSystemInstances()["MyLOBSystemInstanceName"];

IFilterCollection filter = ect.GetDefaultFinderFilters();

IEntityInstanceEnumerator ects = ect.FindFiltered(filter, lobi);

while (ects.MoveNext())

{

    Console.WriteLine(ects.Current["MyEntityFieldName"].ToString());

}