Bulk Update Using BDC Services.

Question

Hi,

My solution structure consists of a BDC service, that uses stored procedures to fetch data from sql server and later i use this data to perform some operations. Till this part (fetching) all is fine. The issue is that I have a datatable with close to 5000 records which i want to dump into my database in one transaction. For this purpose I have written a stored procedure which takes tabletype user defined parameter as input and using that performs the insertion row by row. I am not able to use this stored procedure using BDC, as this has user defined input parameter.

The create method performs insertion one record at a time which will be a performance hit in my case. I have read that BDC supports bulk updates. Can you please elaborate on how bulk update works in case of BDC. I would be very helpful if this can be elaborated using an example.

Thanks,

Ankit

Answer 1

Hi Ankit,

It's not possible to update a bulk of records in one time because Updater MethodInstance can be called to update an EntityInstance identified by a specified EntityInstanceId. An Updater method instance enables you to update an existing entity instance in an external system. For example, given a business object named Customer, this stereotype can be used to update the address of a customer “John” in the external system. If you do not define an Updater method, items cannot be updated by using the Business Connectivity Services features for the entity. For example, you cannot click the Edit Item button on the ribbon of an external list that is based on that external content type, to edit an item in the list.

• Stereotyped Operations Supported by BDC
• Implementing an Updater

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog

Answer 2

Thanks for the reply. We have changed our design now because of this limitation.

Thanks,

Ankit