How to: Delete an Entity

SharePoint 2007

Deleting metadata with the Administration object model is straightforward. Every metadata object has a Delete method that deletes the object and its children. For example, if you delete an entity, all the methods under it are also deleted. Deleting an LobSystem object deletes the entire application from the Business Data Catalog.

This code example shows how to delete an existing entity from the Business Data Catalog.

Example

This code example shows you how to delete the ProductModel entity from the Business Data Catalog.

Prerequisites

Project References

Add the following Project References in your console application code project before running this sample:

  • Microsoft.SharePoint

  • Microsoft.SharePoint.Portal

  • Microsoft.Office.Server

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.Office.Server.ApplicationRegistry.Administration;
using Microsoft.Office.Server.ApplicationRegistry.Infrastructure;
using WSSAdmin = Microsoft.SharePoint.Administration;
using OSSAdmin = Microsoft.Office.Server.Administration;

namespace Microsoft.SDK.SharePointServer.Samples
{
    class GetStartedAndCreateSystem
    {
        const string yourSSPName = "SharedServices1";

        static void Main(string[] args)
        {
            SetupBDC();
            DeleteEntity();
            Console.WriteLine("Press any key to exit...");
            Console.Read();
        }
        static void SetupBDC()
        {
            SqlSessionProvider.Instance().SetSharedResourceProviderToUse(yourSSPName);
        }
        public static void DeleteEntity()
        {
            LobSystemInstance mySysInstance = null;
            LobSystemInstanceCollection sysInsCollection = ApplicationRegistry.Instance.GetLobSystemInstancesLikeName("AdventureWorksSampleFromCode");
            foreach (LobSystemInstance sysInstance in sysInsCollection)
            {
                if (sysInstance.Name == "AdventureWorksSampleFromCode")
                {
                    mySysInstance = sysInstance;
                    break;
                }
            }
            IList<Entity> entityCollection = new List<Entity>(mySysInstance.LobSystem.Entities);
            Entity e = Entity.GetById(entityCollection[0].Id);
            e.Delete();
            Console.WriteLine("Done");
        }
    }
}

See Also

Community Additions

ADD
Show: