Replace stored procedure name with script of stored procedure in BDC Instance XML File

Question

Hi All,

I am using stored procedure name in my BDC xml file. So it is possible to replace the stored procedure name with the script of the stored procedure and generate a BDC file?
Can anyone help me on this.

Regards,
Kishore

---

Kishore

Answer 1

Hi Kishore,

Sometimes it can be done for simple stored procedures like this:

CREATE PROCEDURE [dbo].[GetAllCustomers]
AS
BEGIN
	SELECT * from CustomerTable
END

That won't be possible if your procedure is complicated and it calls any other stored procedures. Why do you need to do it? It's not the good practice. You should use only name of stored procedure in your Application Definition file. This approach allows you to encapsulate all business logic to stored procedure on the Database side and you will be able to change stored procedure in the Database without any changes on SharePoint side.

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts

Answer 2

Hi,

I implement the stored procedure script in the xml file itself. it is working. But make sure that the size of the stored procedure should be small.

Regards,
Kishore

---

Kishore