0

In Sharepoint site, I have a list, it will display data from the table in SQL database.

When user insert, update or delete item in this list, the SQL database will be changed too. The change is one way: from SharePoint to SQL.

I tried the Event Receiver and also tried the External Content type, but each of them have many cons.

So, do we have any other suggestion to automatically update data from SharePoint list into the SQL database when having change in SharePoint list item ?

0

BCS external content types and lists are the only OOTB way of surfacing the external data as per SharePoint guidelines. But you can always build your own solution in .Net on top of SharePoint.

  • Yes, I try this, but as I said, the BCS has some cons with not match my requirement. So I want to implement this project by another way. Do you have any suggestion to build the solution to connect them ? I also try the Event Receiver to CRUD data in SP list, but I'd like to find the best way. – trantab May 28 '15 at 4:20
  • i totally agree that BCS has its own limitations w.r.to SharePoint. But you haven't stated your requirements in the question so i can not suggest the best approach. pls try to elaborate your requirement then i am sure you can get a very specific answer. if your schema or relationships are so complex then you should try creating own .net class library and you can still use via BCS to leverage that. – kesava May 28 '15 at 5:08
  • Hi. I've just updated my question. My question is "do we have other way to update data from SP list into SQL database without using ER and External list ?" – trantab May 29 '15 at 9:49
0

Create external content type(s) using BCS and create list using that external content type. The complete SQL table schema and data will be fetched to list. And you can create CRUD operations on them using SharePoint.

For more, refer to : http://www.codeproject.com/Articles/683749/Implementing-Business-Data-Connectivity-in-SharePo

  • Do we have the other solution for my project ? – trantab May 28 '15 at 4:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.