SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to return related data via External Content Types. I was wondering which is better to use, CAML queries or LINQ to SharePoint? I'm fine with writing CAML queries besides the relating part but haven't used LINQ to SharePoint that much.

Are there any good examples that anyone is aware of for returning data via new CAML queries that support relation data along with LINQ to SharePoint examples? Any help would be really appreciated, thanks!

share|improve this question

Too bad, but external content types and Linq to SharePoint does not work together. It may be possible with some extensive hacking into the code, but the SPMETAL does not OOTB support this.

share|improve this answer
Are there any good examples of retrieving related data via External Lists, or External Content Types, or sp lists in general? Didn't know if there were any sites that anyone recommends since I could spend hours digging through google/bing search returns. Thanks. – Patrick Jul 27 '11 at 20:32
I would recommend the book Professional Business Connectivity Services by Scot Hillier (…). Another good start is, of course MSDN. Channel 9 also provides a lot of information on BCS, external lists and external ct. Please not that ECT is not the solution for everything. Writing data back can get complicated. Some MVP's even recommend not to write back relational data – Bas Lijten Jul 27 '11 at 20:41

Your Answer


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.