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 am working with SharePoint 2013 and I have a requirement where I have to perform CRUD operations on multiple external tables (SQL Server) with SharePoint in one List and vice versa. I am able to perform the CRUD operation with one table and one list mapping.

I have performed below operations to achieve this:

  1. Created a view for multiple tables and display the data into a list using External Content Type but unable to perform update, insert and delete operations on it.

  2. Created various stored procedure for CRUD operation and binding them manually to External Content Type and performing the operation.

The 2nd options is working find for me. But it has some limitations and I am looking for OOB solution if any. Could someone suggest me any OOB option for this requirement.

Thanks in advance.

share|improve this question

2 Answers 2

When it comes to BCS, nothing is Out of the Box. You're working with XML here and that's custom. Anyways, you should be able to configure the External Content Type by specifying stored procedures. Personally, I don't like to do updates via SharePoint. What I would do is as follow:

  1. Use SharePoint external lists for displaying data nicely in SharePoint views
  2. Use custom code to write back to the SQL database (or whatever source). I prefer using LinQ to SQL.
  3. When someone updates something , just call a refresh on the External List.
share|improve this answer
    
or use Microsoft Entity Framework, instead of LINQ to SQL (as it is not supported anymore) –  Arsalan Adam Khatri Sep 10 '13 at 8:11
    
It's definitely still supported in 4.5 (msdn.microsoft.com/en-us/library/bb386976.aspx) - (stackoverflow.com/questions/3041011/is-linq-to-sql-deprecated) I prefer Linq as EF is bloated and slow. –  Fox Sep 10 '13 at 8:24
    
Thanks for the information @Fox. I was wondering if there is no option available for OOB. :( –  Ankit Sep 10 '13 at 8:37
    
@Fox, thanks for the info ! –  Arsalan Adam Khatri Sep 10 '13 at 9:51

The best way to do this, I think, is to set up a stored proc on the DB end and tell SharePoint that that is your "table".

share|improve this answer

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.