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 have gone through the procedure of creating n External Content Type and based on that i was able to see an External List. So the data which i was seeing in the sql table was shown in the External List.

So now we have the same data in two different location on in the External List and the other in the SQL Table.

Is it really possible not to create an External List and in a Webpart i can call the External Content Type Methods and display the data.

share|improve this question
What if one doesn't have Enterprise, just standard? Business Data web parts don't come in standard Sharepoint 2010. – Pedro Feb 23 '11 at 19:07
3rd party tools can possibly help with a data replication concept. Finally the data really lives in native SharePoint lists, not an external view on surface only. This opens up all native SharePoint list features, e.g. search, change notifications, workflows etc. For SharePoint 2007 / 2010 on-premise (100% in SharePoint as a feature):… For SharePoint 2013 / Online / Office 365 (without installation, runs outside SharePoint):… – user11338 Dec 4 '12 at 13:13

"same data in two different location" <-- actually you should think of the Sharepoint External List as a view on your data - it is not the same data in two locations.

You do not need the External List to make use of the External Content Type. You could write your own web part to make use of the content type's methods, or you can play around with built-in "Business Data" Webparts, in particular check out the Business Data Item webpart: alt text

share|improve this answer

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.