Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I need to create a list such that the values on the list can be stored in SQL table as well.

I need to attach workflows to the list item as well. Its a simple workflow with two approval process involved.

Can we achieve this without using codes at all.

Is BCS a good approach so that any decision made based on Workflow will be stored back to the SQL table?

I have used BCS to read from table but I will need to update as well as delete data that will mostly be handled from SharePoint Side.

Thanks.

share|improve this question

1 Answer 1

Business Connectivity Services is what you are looking for! BDC was in SharePoint 2007 which was evolved to BCS in SharePoint 2010

There are few limitations when you work with External Lists, External Content Types and Business Connectivity Services... One of the most important is that you cannot associate workflows with them!, a complete list can be found here:
Business Connectivity Services Limitations

But when you are working with BCS, that means you have SharePoint Enterprise, and alternate can be to use InfoPath based forms with custom Web Service!

InfoPath form will handle different views for approvers and so on, and on click will call WCF Web Service which will handle notification and data updates to SQL Server directly... As you must know that either you update/add data to SQL Server or External List, both are automatically sync!

I hope this helps...

share|improve this answer
    
Thanks for the prompt reply. Again, InfoPath forms saves all the data in XML to send the data to SQL table right? –  Thisisme.. Dec 5 '12 at 20:56
    
Yes InfoPath saves data in XML but if you will write your own WCF Web service to listen to InfoPath requests, you will have more control... I have used this structure in one of my project, it works great! –  Arsalan Adam Khatri Dec 5 '12 at 20:57
    
Rather than adding/updating data directly from InfoPath to SQL Server, write a WCF based Web Service as a middle tier/application tier! –  Arsalan Adam Khatri Dec 5 '12 at 20:58
    
Is there any good article that I can see to achieve this? If there are any blogs that you may have created. I have Visual Studio 2005 and .Net Framework 2.0 with VB.NET. Is there basic requirement to create WCF based web service? –  Thisisme.. Dec 5 '12 at 21:00
    
Get Visual Studio 2010 with .Net Framework 4.0! Your life will be easy, WCF was introduced in 3.5 Framework... Also in .Net Framework 4 you can use Entity Framework 4 to work with SQL Server... And VS2010 also has project templates for SP 2010 Development... –  Arsalan Adam Khatri Dec 5 '12 at 21:07

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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