bdc insert, delete and update
- I am new to sharepoint.
I have created a custom web part to retrieve the information. it shows the information that I need. If I want the user has the ablility to update or insert new data. Do I use bdc? The custom web part (.net code) is using the sql server on another data server. Any assistance will be appreciated.
Thanks
解答
- BDC is used for surfacing data from LOB systems to SharePoint, By using BDC combined with BDC webparts allows you to deploy no code solutions, in your case since you have gone custom webpart route there is really no need to use BDC unless you are doing some customized rendering in your webpart but want to leverage BDC so your custom code doesn't need to manage connections, provide Create, Retrieve, Update, Delete functionality etc. The other thing you probably should know is although write backs to LOB systems are supported its not quite straightforward, there are some tools out there that helps with creating BDC app def files, MS ships a free editor with SDK, you can also purchase BDC metaman which has lot more functionality than free tool offers.
- 已提議為解答Ram Gopinathan - MSFT 2009年6月25日 上午 05:11
- 已標示為解答kkmick 2009年6月29日 下午 01:20
所有回覆
- BDC is used for surfacing data from LOB systems to SharePoint, By using BDC combined with BDC webparts allows you to deploy no code solutions, in your case since you have gone custom webpart route there is really no need to use BDC unless you are doing some customized rendering in your webpart but want to leverage BDC so your custom code doesn't need to manage connections, provide Create, Retrieve, Update, Delete functionality etc. The other thing you probably should know is although write backs to LOB systems are supported its not quite straightforward, there are some tools out there that helps with creating BDC app def files, MS ships a free editor with SDK, you can also purchase BDC metaman which has lot more functionality than free tool offers.
- 已提議為解答Ram Gopinathan - MSFT 2009年6月25日 上午 05:11
- 已標示為解答kkmick 2009年6月29日 下午 01:20
Hi,
Understanding that you are new to SP. I would like to tell you what exactly BDC looks like in case if you do it through traditional .NET application.
I think you aware of dataReader's in case of ADO.NET which is pulls up data from underlying datasources and that too in readonly fashion even though its faster then dataset and datatable. so similar is BDC.
As for pulling information/data from underlying datasources you specify the connection string, sql query or sprc, return value of data, credentials and many more stuffs... so the same thing you need to do when you working with BDC.
As I compared BDC with the dataReader's hence needless to say that BDC is also READONLY/Foward Only. In case if you are looking for data updation also then you have to write that functionality which has nothing to do with BDC.
Manish Patil http://patilmanishrao.wordpress.com Posting is provided "AS IS" with no warranties, and confers no rights.- Thank you.
Thank you for your insight
