XML Snippet: Modeling a Deleter Method

  • Article

Applies to: SharePoint Server 2010

The following is an example of a Deleter method in a BDC model. Notice that this is a simple example and does not account for any foreign key constraints in the database.

Example

<Method Name="Delete" DefaultDisplayName="SalesReason Delete">
  <Properties>
    <Property Name="BackEndObject" Type="System.String">
      SalesReason</Property>
    <Property Name="BackEndObjectType" Type="System.String">
      SqlServerTable</Property>
    <Property Name="RdbCommandText" Type="System.String">
      DELETE FROM [Sales].[SalesReason] 
      WHERE [SalesReasonID] = @SalesReasonID</Property>
    <Property Name="RdbCommandType" Type="System.Data.CommandType, 
              System.Data, Version=2.0.0.0, Culture=neutral, 
              PublicKeyToken=b77a5c561934e089">Text</Property>
    <Property Name="Schema" Type="System.String">Sales</Property>
  </Properties>
  <Parameters>
    <Parameter Direction="In" Name="@SalesReasonID">
      <TypeDescriptor TypeName="System.Int32" 
                      IdentifierName="SalesReasonID" 
                      Name="SalesReasonID" />
    </Parameter>
  </Parameters>
  <MethodInstances>
    <MethodInstance Type="Deleter" 
                    Name="Delete" 
                    DefaultDisplayName="SalesReason Delete" />
  </MethodInstances>
</Method>

For a complete BDC model sample that includes a Deleter, do the following:

  1. Download the Microsoft SharePoint 2010 SDK.

  2. Extract "bcs sample kit.zip" from "%ProgramFiles%\Microsoft SDKs\SharePoint 2010\Samples\Business Connectivity Services" to a local folder.

  3. In the folder where you extracted the files, locate the "BDC Models for XML Snippets" folder. This folder contains BDC model samples.