.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

BCS Handling external content types programmatically

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :SharePoint


1. How do I programmatically get the names and info on all the LOB external content types that I created on a SP server with SPD?

2. Can I programmatically copy an external content types to another server (which also have BCS installed)?

Thanks in advance


View Complete Post

More Related Resource Links

Video: External Content Types and Business Connectivity Services for SharePoint 2010

This video discusses the concept of external content types for Business Connectivity Services. (Length: 1:34)

"BDC Metadata Store is Currently Unavailable" when navigating to the External Content Types object i

After installing SharePoint 2010 Beta and Sharepoint Designer 2010, opening Designer and navigating to the External Content Types object results in the following error:"The Business Data Connectivity Metadata Store is currently unavailable."Anyone else having this experience?ThanksMark

BCS : How to assign permissions on external content types so that it has the same permissions as the

  Environment : sharepoint 2010 Active directory authentication guys, I been assigned a new role of administrating sharepoint and been juggling with the best way to manage permissions in BCS. here is an overview I gave certain users edit\ execute\ selectable in clients\ set permissions on the BCS MetaData catalog. These users created the external System and external content types and created lists from these content types, all nice and good. But the problem i am facing now is the BCS list is inherirting permissions from the site ( which is how i want it) but whe these users try to access the BCS List they get the error message "Accces denied by BCS", i can fix this issue by assigning Active directory users\groups Execute\ selectable in client permissions on the extenal content type in BCS but i dont want to do it becasue i cannot select the same sharepoint groups that have permission for the BCS list from here, all i can select from here is AD users and groups. In short what i want to do is assign all those sharepoint groups which has access to the BCS list( which inherits it's permissions from the site) access to the external content type and i want to do this without duplicating the same permissions on external content type and the list. What would be the best way to do it. Sounds complicated but i guess this will be a frequent configuration. thanks samee

external content types DB2

Hello, how can i connect over external content types in SharePoint Designer 2010 to a DB2 database? Thanks for your answer.

SharePoint Designer External Content Types with WCF


I've created a basic WCF service using an edmx model and service class that only contains the code below (takes 10mins to set up). I followed this link as instructions http://msdn.microsoft.com/en-us/data/cc745957.aspx

public class GRef_Service : DataService<MasterDataDirectoryEntities>
  // This method is called only once to initialize service-wide policies.
  public static void InitializeService(IDataServiceConfiguration config)
    // TODO: set rules to indicate which entity sets and service operations are visible, updatable, etc.
    // Examples:
    config.SetEntitySetAccessRule("*" , EntitySetRights.AllRead);
    // config.SetServiceOperationAccessRule("MyServiceOperation", ServiceOperationRights.All);
    //config.SetServiceOperationAccessRule("GRef_Building", ServiceOperationRights.AllRead);


When I view it in my site

External content types are not working in SharePoint 2010 Web Front End in DMZ


I have discovered that my Web Front End server will try to connect directly to the SQL server I have listed in my external content type.  I am able to render the contenct properly on my SharePoint 2010 App server, but when I try to render the list on the DMZ server I receive Cannot connect to the LobSystem (External System).   Is there a way around this?  I would like my Web Front End to connect only to my SharePoint 2010 App tier which has access to all of the databases in my infrastructure.  The Web Front End only has access to the App tier.



BCS: Best practice of Toggling external content types between staging and production databases



Environment :
Sharepoint 2010
using BCS to point to external database
create two Secure Store Application ids , one with production credentails and another with staging credentails

I have several external content types (ECT) using an external system(ES) pointing to staging databases.
Now i want to change only one of my ECT to point to production DB but suprisingly the only way i could achieve this was by modifying the ES that all the other ECT are using, this is not practicaly because this makes all the ECTs point to production and not just the one that i want.

Question is how can i have different ES and how can i make only one ECT out of all the ones to point to production, i tried using the "Switch connected systems" but did not like it and below are the details:

Created a new ECT pointing to production which would show the ES being used in BCD services and then i  used the "Switch Connected Ssytems" option under designer to switch the staging ECT to the production ES. Dos the job but the problem is that if there are no ECT pointing to staging ES then it does not appear under BCS services which mean neither can i switch my ECT back to it nor would it be available when i am creating new ECT whch need to point to staging.

Hope i was clear, please suggest how to handle this sit

SharePoint Designer 2010 External Content Types Data Source Already Exists in Business Data Connecti


I used the Secure Store to create connection in SharePoint 2010 Designer External Content Types Data Source Explorer.  Later I changed some column names in the table.  I deleted the connection from Data Source Explorer and recreated it. I right clicked on the table and selected Create All Operations. When I clicked the Finish button, I got "The system definition with the same name as this data source already exists in the Business Data Connectivity Metadata Store and it refers to a different data source.  Cannot complete operation generation.  Add a connection to this data source with a different name and try again." 

I re-created the Secure Store using a different name in SharePoint 2010 Central Administration.  I didn't find the option to choose the connection name in SharePoint 2010 Designer. After I clicked Add Connection, I entered the Database Server and the Database Name, selected Connect with Impersonated Window Identity, entered Secure Store name, and clicked OK. The connection created with the database name as before.

Authentication Issue with "External Content Types"


I am attempting to add a new External Content Type (a SQL Server DB) (using Sharepoint Designer).  I click "Add Connection" and select SQL Server as the type.  I then enter the Database Server, DB name, and tick "Connect with User's Identity."  When I click OK, I get an error from Designer saying "Cannot Establish Connection to the Data Source. An unexpected internal error occurred in the Business Data Connectivity Shared Service:  The specified user or domain group was not found." 

1.  What username/password is being used for this and where is it configured?  (ie what user or domain group has not been found?)

2.  Is there a way to simply use SQL Server authentication for this?

I am logged on to the machine as a domain administrator, who has sysadmin, etc rights to the SQL Server, and who has rights as Administrator in Sharepoint (in other words should have rights to do just about anything).  The Authentication Type for the site is set to Windows using Integration Windows Authentication using NTLM.

INTERESTINGLY, I CAN access the database using "Data Sources" using SQL Server authentication.



External Content Types + Search Service: Cannot crawl my external content type



I created an external content type by creating a new Visual Studio sharepoint project, and creating a content type (The default Entity1 content type). I created a profile page for it and everything, and when I drilled into the content type in central admin - BCS, I saw it wasn't marked as crawlable.

I saw this similar post: http://social.msdn.microsoft.com/forums/en-us/sharepoint2010general/thread/281BCEFD-59EC-41CC-B948-458A4BDA9E49

So I then created an external content type through SPD, leveraging the same code, and creating an external list and profile page. This time, when I drilled into the external content type in the BCS administration, it showed "Crawlable: Yes".

I figured at that point I was good to go, but when I went to my search service application -> Content Sources -> New Content Source and selected Line of Business Data, and selected BDC, it still says "No external data sources to choose from."

I verified also that the account for crawling has permissions for the external content type.

Are there any other things I should be looking for? From everything I read this should "just work" now :)



Sharepoint Foundation - Validation for external content types


I've been trying to add validation for my external lists which link to a BDC model.  I've added an EventReceiver and implemented the ItemAdding and ItemUpdating methods so i can add my own validation, but the events do not fire.  I've added the same event receiver to the Tasks list and the events fire correctly there - but after the error screen is closed the original add/edit form is no longer visible, so the user has to start again.

Is there a way I can validate my External List data , return an error mesage to the user and allow them to continue adding/editing an item without having to start again.  Ideally i would like the validation at the list level and not on the individual forms as the end users of the system will be creating/editing their own forms for the lists at some point in the future.


WCF: Consuming Claims-Enabled WCF Web Services as SharePoint 2010 External Content Types, Part 4

Learn how to use SharePoint Designer 2010 to consume a claims-enabled web service.

How do I Filter on fields and not Record Limits for External Content Types


I have created an External Content Type that connects to an SQL server/table.  I would like to set a filter on CompanyType so that my external list only shows records where CompanyType = Owner.  The only examples of Filter examples that I have found are dealing with record counts.


Leland Usher SharePoint Developer/Administrator

External Content Types and Workflows


Hello Community,

I am trying to figure out if there is there a way to create a workflow for an External Content Type List?  Has anyone done this?  Is this possible?



Tom Molskow - SharePoint Architect - Linked-In - SharePoint Gypsy

Input parameter to a Stored Procedure External Content Types and External lists



I am displaing data in form of a External list that gets it data from an External Content Type that gets its data from a stored procedure. This works fine but what I really would like to do is to be able to send an inparameter with the user name down to the store proceder so it only return the rows marked with the users loginname.

Is this possible (out of the box)?

Migrating Business Connectivity Services External Content Types in SharePoint 2010

Learn to migrate BCS external content types from a development environment to testing environments and production environments in SharePoint 2010.

Configuring SharePoint Server 2010 Search for External Content Types, Part 2

Learn how defining external content types reduces crawl times for large amounts of data by using incremental crawls.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend