Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Using the BDC API how to catch the returned code when executing a stored procedure?

  Asked By: Jacques    Date: Jan 11    Category: Sharepoint    Views: 1259

using BDC API, how can i catch the return code a stored procedure returns?

I tried Entity.Execute to execute a generic method. However, it returns an empty Entity table.

I know you can do it by setting up an output variable. I prefer returning an integer for tracking errors.



1 Answer Found

Answer #1    Answered By: Dhanraj Saxsena     Answered On: Jan 11

I could not find a way to catch  an integer returned  by a stored  procedure using bdc  API.

I ended up defining the return  parameter as IDataReader as other methods and modifying my sp to return a table  (Select ...).

Entity.Execute will return a DbEntityInstanceEnumerator.

Probably if we define the return parameter as other types, you may not go through this route. I did not try this.