Wednesday, March 21, 2012 4:41 AM
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.
Wednesday, March 21, 2012 8:28 AM
Sometimes it can be done for simple stored procedures like this:
CREATE PROCEDURE [dbo].[GetAllCustomers] AS BEGIN SELECT * from CustomerTable ENDThat 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.
DmitryLightning Tools Check out our SharePoint tools and web parts
Tuesday, March 27, 2012 7:16 AM
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.
- Marked As Answer by Kishorekv Tuesday, March 27, 2012 7:16 AM