Share via


BDC Custom Properties

Applies to: SharePoint Server 2010

Table 1 contains the Business Data Connectivity (BDC) service custom properties and their descriptions.

BDC Custom Properties Descriptions

Table 1. BDC custom property descriptions

Element

Property Name

Type Name

Description

Required/Optional

Default Value

Limits / Accepted Values

ActionParameter

IdOrdinal

System.Int32

Specifies that the action parameter represents an identifier instead of a field.

Optional

None

An integer greater than or equal to zero.

Association

HideOnProfilePage

System.Boolean

Specifies whether a particular associated entity should be added to the profile page of the master entity.

Optional

false

true, false

Entity

DefaultAction

System.String

Specifies the name of the default action defined for the entity.

Optional

None

One of the action names.

Entity

Title

System.String

Specifies the name of a field defined on the entity as a title.

Optional

None

A field name.

Entity

DisplaySearchResultRightsMask

System.Int64

Defines the response from the CheckAccess stereotype that shows that an item can be displayed in the search results page for the currently logged in user.

For more information about this property, see the note later in this topic.

Optional

1

A long integer that represents a bitmask.

Entity

MaxAccessChecksPerSession

System.Int32

This is a parameter to the Search Windows PowerShell commandlet that registers a custom security trimmer. It specifies the number of Document IDs that are sent to the external system in one call, to check whether the current user has access to those documents.

Optional

100

An integer value.

Entity

__BdcLastModifiedTimestamp

System.String

Specifies the name of the field that contains the time stamp of the entity instance. The value of this field is used for timestamp- based incremental crawling and also to display in the search results page.

Optional

None

Should be the name of a field whose type is System.DateTime. If the name of a non-existent field is specified, or if the name of a field whose type is not System.DateTime is specified, an InvalidOperationException is thrown.

Entity

ExcludeFromOfflineClientForList

System.String

Specifies whether the entity can be taken offline in Microsoft Groove or Microsoft Outlook applications.

Optional

false

true, false

Entity

Discovery

System.String

Indicates whether the metadata object is used for data source discovery purposes inside SharePoint Designer, instead of for end-user consumption.

Optional.

None

The values of this property are ignored.

Entity

OfficeItemType

System.String

Identifies the item type that the entity can map to.

Optional

None

Appointment, Task, Post, Contact

FilterDescriptor

CaseSensitive

System.Boolean

Specifies a UI hint that indicates whether a filter string is evaluated in a case-sensitive manner or in a case-insensitive manner.

Optional

false

true, false

FilterDescriptor

IsDefault

System.Boolean

Specifies a UI hint that indicates whether to use this filter by default. This property is used by an external item picker control.

Optional

false

true, false

FilterDescriptor

Comparator

String or ComparisonFilter.Comparator enum

Specifies the comparison operator for a comparison filter.

Optional

=

Equals, NotEquals, GreaterThan, LessThan, GreaterThanEquals, LessThanEquals, =, ==, !=, <>, <, >, >=, <=

FilterDescriptor

MaximumValue

System.Int32

Specifies a UI hint that can be used for validation in forms.

Optional

None

FilterDescriptor

UsedForDisambiguation

System.Boolean

Specifies whether the picker should use this filter to populate the match list.

Optional

false

true, false

FilterDescriptor

UseValueAsDontCare

System.Boolean

Indicates whether the DontCareValue property should be used or ignored for this filter. This is used only in the SharePoint Designer filter editor for Microsoft SQL Server tables and views.

Optional

false

true, false

FilterDescriptor

DontCareValue

System.String

Specifies the value to be ignored at run time when this filter is executed. This property is used only inside the filter editor in SharePoint Designer for tables and views.

Optional

Null if not specified.

Any string

FilterDescriptor

PageSize

System.Int32

Specifies the page size for the page filter. This property is used only inside the filter editor for SQL Server tables and views in SharePoint Designer.

Optional

0

A 32-bit integer value.

FilterDescriptor

SortType

System.String

Specifies how to order the results for a BDC method. This property applies to Limit filters and Page filters. This property is used only inside the filter editor for SQL Server tables and views in SharePoint Designer.

Optional

Ascending

Ascending, Descending

LobSystem

WildcardCharacter

System.String

Specifies the wildcard character used in Wildcard Filters defined for methods on Entities under this LobSystem.

Optional

"*"

Any string except the empty string.

LobSystem

WildcardCharacterEscapeFormat

System.String

Specifies the escape string for wildcard characters for cases where the wildcard character is part of the actual search string. For example, "\{0}".

Optional

"\{0}"

Any string with exactly one parameter.

LobSystem

DbAuthenticationMode

System.String

Specifies the authentication mode to access a database.

If authentication mode is not specified in the BDC model, then by default, PassThrough authentication mode is used.

For more information about the authentication modes that BDC supports, see Business Data Connectivity Service Authentication.

Required

RevertToSelf, PassThrough, WindowsCredentials, RdbCredentials

LobSystem

WebServiceAuthenticationMode

System.String

Specifies the authentication mode to access a Web service.

If authentication mode is not specified in the BDC model, then by default, PassThrough authentication mode is used.

For more information about the authentication modes that BDC supports, see Business Data Connectivity Service Authentication.

Required

RevertToSelf, PassThrough, WindowsCredentials, Credentials

LobSystem

WsdlFetchUrl

System.String

Specifies the location of the WSDL file for a Web service connection.

Required

A URL.

LobSystem

WsdlFetchAuthenticationMode

System.String

Specifies the authentication mode used to retrieve the WSDL file from the WsdlFetchUrl.

If authentication mode is not specified in the BDC model, then by default, PassThrough authentication mode is used.

For more information about the authentication modes that BDC supports, see Business Data Connectivity Service Authentication.

Required

RevertToSelf, PassThrough, WindowsCredentials, Credentials

LobSystem

WsdlFetchSsoProviderImplementation

System.String

Specifies the assembly-qualified name for the implementation of the custom secure store provider that is used for authenticating WSDL retrieval.

Required only if the SSO application ID exists.

An assembly-qualified name.

LobSystem

WsdlFetchSsoApplicationId

System.String

Specifies the SSO application ID for retrieving the WSDL file.

Optional

None

SSO application ID.

LobSystem

WebServiceProxyNamespace

System.String

Specifies the namespace in which the Web service proxy is to be generated.

Required

None

A string that contains the namespace.

LobSystem

WebServiceProxyProtocol

System.String

SOAP protocol version.

SOAP11, SOAP12

LobSystem

SystemUtilityType

System.String

Specifies the assembly information for the custom connector.

Required only if the type is a custom type.

None

An assembly-qualified name.

LobSystem

Discovery

System.String

Indicates whether the metadata object is used for data source discovery purposes inside SharePoint Designer, instead of for end-user consumption.

Optional

None

The values of this property are ignored.

LobSystem

DiscoveryVersion

System.Int32

Indicates the discovery version of the discovery LobSystem in SharePoint Designer.

Optional

None

Acceptable value range is from 0 to Int32. MaxValue.

LobSystem

DotNetAssemblyLobSystemName

System.String

Specifies the name of the lob system that this discovery LobSystem requires the .NET assembly from in SharePoint Designer.

Optional

None

Any string less than or equal to 255 characters.

LobSystem

DotNetAssemblyTypeName

System.String

Specifies the assembly-qualified name of the class that this discovery LobSystem stands for in SharePoint Designer.

Optional

None

An assembly-qualified name.

LobSystemInstance

WebProxyServerConfiguration

System.String

Specifies the proxy server name, if not using the default proxy server.

Optional

None

A string.

LobSystemInstance

NumberOfConnections

System.Int32

Specifies the number of concurrent connections allowed to one endpoint.

Optional

LobSystemInstance

DatabaseAccessProvider

System.String

Specifies the type of database access.

Required

None

SqlServer, OleDB, Oracle, Odbc

LobSystemInstance

AuthenticationMode

System.String

Specifies the authentication mode used to access a database.

For more information about the authentication modes that BDC supports, see Business Data Connectivity Service Authentication.

Required

None

RevertToSelf, PassThrough, WindowsCredentials, RdbCredentials

LobSystemInstance

WebServiceAuthenticationMode

System.String

Specifies the authentication mode to access a Web service.

For more information about the authentication modes that BDC supports, see Business Data Connectivity Service Authentication.

Required

None

RevertToSelf, PassThrough, WindowsCredentials, Credentials

LobSystemInstance

WebServiceUrlOverride

System.String

Specifies the location of the Web service, if different from WSDLFetchUrl.

Optional

HNone

A URL.

LobSystemInstance

SsoProviderImplementation

System.String

Specifies the assembly-qualified name for the implementation of the secure store provider that is used to access the external system.

Required only if the SSP application ID exists.

None

An assembly-qualified name.

LobSystemInstance

WebServiceSsoApplicationId

System.String

Specifies the Secure Store Application ID for accessing a Web service.

Optional

None

An SSO application ID.

LobSystemInstance

SsoApplicationId

System.String

Specifies the Secure Store Application ID.

Optional

None

An SSO application ID.

LobSystemInstance

SecondarySsoApplicationId

System.String

Specifies the secondary Secure Store Application ID.

Optional

None

An SSO application ID.

LobSystemInstance

Discovery

System.String

Indicates whether the metadata object is used for data source discovery purposes inside SharePoint Designer, instead of for end-user consumption.

Optional

None

The values of this property are ignored.

LobSystemInstance

WebServiceProxyTimeOut

System.Int32

Specifies the timeout for Web service methods in milliseconds.

Optional

LobSystemInstance

__Upgraded

System.Boolean

Specifies whether this LobSystem instance was upgraded from Microsoft Office 2007.

Optional

false

true, false

LobSystemInstance

RdbConnection Data Source

RdbConnection Initial Catalog

RdbConnection Integrated Security

RdbConnection Pooling

System.String

Properties prefixed with RdbConnection become database connection properties. For example, the RdbConnection Data Source property becomes the Data Source property on the database connection.

If using PassThrough, RevertToSelf, or WindowsCredentials authentication modes, you must set the RdbConnection Integrated Security property to SSPI, yes, or true. We recommend that you set this value to SSPI for SQL Server databases.

For more information about the authentication modes that BDC supports, see Business Data Connectivity Service Authentication.

Optional

None

Method

RdbCommandType

System.Data.CommandType

Specifies how the command string is executed.

Required only for a database.

None

Text, StoredProcedure, TableDirect

Method

RdbCommandText

System.String

Specifies the command string to be executed on a database.

Required only for a database.

None

A string that contains the command text.

Method

Schema

System.String

Specifies the SQL Server schema of the SQL Server object that the method is created from in SharePoint Designer.

Optional. Required to edit a method in SharePoint Designer.

None

A SQL Server schema.

Method

BackEndObject

System.String

Specifies the SQL Server object that the method is created from in SharePoint Designer.

Optional. Required to edit a method in SharePoint Designer.

None

MethodInstance

DisableReadBeforeUpdate

System.Boolean

Indicates whether the Specific Finder call should be disabled before calling updater and deleter. Used only in offline synchronization.

true, false

MethodInstance

IsLongRunningTransaction

System.Boolean

Indicates whether this operation is long-running. If this is set to true, the ID can be populated in a two-step process rather than retrieved in a single synchronous call.

true, false

MethodInstance

FileNameField

System.String

Specifies the field in the entity that contains the name of the "file" that should be shown to the user in the SharePoint Server user interface. (The user clicks the file name, if available, to access the stream content.)

Optional

None

A field name.

MethodInstance

FileName

System.String

Specifies the hard-coded file name that should be used for all StreamAccessor methods on this entity and shown in the SharePoint Server user interface. (The user clicks the file name, if available, to access the stream content.)

Optional

None

A field name.

MethodInstance

MIMETypeField

System.String

Specifies the name of the field that returns the dynamic MIME type of the stream per entity instance. For example, the MIME type for the resume for candidate1 is "docx" and "pdf" for candidate2.

Optional

None

A field name.

MethodInstance

MIMEType

System.String

Specifies the static and hard-coded MIME type for the stream.

Optional

None

A field name.

MethodInstance

LastDesignedOfficeItemType

System.String

Specifies the office item type that the method instance was last designed with inside SharePoint Designer.

Optional

None

None, Appointment, Task, Post, Contact.

Model

Discovery

System.String

Indicates whether the metadata object is used for data source discovery purposes inside SharePoint Designer, instead of for end-user consumption.

Optional

None

The values of this property are ignored.

TypeDescriptor

ComplexFormatting

System.Boolean

Indicates whether the complex structure must be converted to a single string based on FormatString.

Optional

false

true, false

TypeDescriptor

FormatString

System.String

Specifies the .NET format string where individual format specifiers, for example, {0} {1}, correspond to type descriptors in the order that they appear.

Optional

None

A .NET format string with enough parameters for the type descriptor leaves; that is, for the type descriptors that have no child type descriptors.

TypeDescriptor

RendererDefinition

System.String

Specifies the assembly-qualified name of the class that implements the formatting logic.

Optional

None

An assembly-qualified name.

TypeDescriptor

SuppressCrawl

existential

Specifies that the value of the TypeDescriptor and any nested fields will not be indexed.

Optional

None

The value of this property is ignored. If this property is present, the value of the TypeDescriptor is not indexed.

TypeDescriptor

ShowInPicker

System.Boolean

Specifies whether this TypeDescriptor must be included as a column in the picker control.

Optional

false

true, false

TypeDescriptor

HideInListWebPartByDefault

System.Boolean

Indicates whether the field is hidden by default in the list Web part, in the initial configuration of the list Web part.

Optional

false

true, false

TypeDescriptor

HideInItemWebPartByDefault

System.Boolean

Indicates whether the field is hidden by default in the item Web part, in the initial configuration of the item Web part.

Optional

false

true, false

TypeDescriptor

DisplayByDefault

System.Boolean

true, false

TypeDescriptor

LogicalOperatorWithPrevious

System.String

Specifies the logical operator between this and the previous type descriptor inside the filter editor for SQL Server tables and views, inside SharePoint Designer.

Optional

Or

And, Or

TypeDescriptor

Order

System.Int32

Indicates the order of the type descriptor among all type descriptors with logically relatable filters on. This property is used only inside the filter editor for SQL Server tables and views in SharePoint Designer.

Optional

-1

A 32-bit integer value.

TypeDescriptor

Size

System.Int32

Specifies the maximum size of the string used as a hint. The cache creates columns with this length, if possible.

Optional

None

An integer greater or equal to 1.

TypeDescriptor

NullEquivalentValueInForms

Object

Specifies a value used to convert null values to null. Values in the cache are converted to the value specified by this property before being propagated to the MAPI store. Conversely, the converted null-equivalent values in the MAPI store are converted back to null before being propagated back to the cache.

Optional

TypeDescriptor

DecimalDigits

System.Int32

Specifies the number of digits after the decimal point.

If this property is not specified for a decimal field in the BDC model, the cache by default assumes the value 4. If there are more than four digits after the decimal point, BDC rounds up the values in the cache, which can lead to potential data loss. Set this property in the BDC model if your model contains decimal fields.

Optional

4

An integer between the values of 1 and 28.

TypeDescriptor

RequiredInForms

System.Boolean

Specifies a UI hint that indicates whether the form submission should be prevented if a value is not provided.

Optional

true

true, false

TypeDescriptor

SPCustomFieldType

System.String

Specifies the name of a SharePoint custom field type to be used for this TypeDescriptor in an external list.

Add this property to a TypeDescriptor in the return parameter of a SpecificFinder method when using a custom field type. This property has no effect on methods other than the SpecificFinder. For more information about custom field types, see Custom Field Types.

Optional

None

The name of any installed SharePoint custom field type.

Note

The CheckAccess stereotype returns an array of type long integer, and each of those values are bitwise ANDed with the value specified in the DisplaySearchResultRightsMask property. If the result of the bitwise AND operation is the same as the value of the DisplaySearchResultRightsMask property, that item can be displayed. The idea is that any of the bits in the vector that are returned by CheckAccess could signal a ‘yes, it’s safe to show,’ and thus which bit we use should be configurable.