.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

SharePoint Designer External Content Types with WCF

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

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

View Complete Post

More Related Resource Links

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.

Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

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)

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.



Sharepoint Designer crashing when trying to add new External Content Type


When I try to create a new External Content Type, the Sharepoint Designer crashes

I've installed the WFC fix before installing Sharepoint 2010 beta, that got rid of the initial problem I had with the message "The Business Data Connectivity Metadata Store is currently unavailable."

I've tried recreating the BDC (delete and create unter Manage Service Applications, but that didn't help.

Any suggestions?




Stopped working

Problem signature:

Problem Event Name: CLR20r3

Problem Signature 01: spdesign.exe

Problem Signature 02: 14.0.4514.1004

Problem Signature 03: 4abf183b

Problem Signature 04: mscorlib

Problem Signature 05:

Problem Signature 06: 4a27471d

Problem Signature 07: 4212

Problem Signature 08: a9

Problem Signature 09: System.TypeInitialization

OS Version: 6.1.7600.

Locale ID: 2055


Error Creating External Content Type using Sharepoint Designer 2010

I am trying to create an external content type using Sharepoint Designer 2010. I ran SD on my local machine and connected to a site on some other machine running Sharepoint Server 2010. The Db on which I want to create my ECT resides on my local machine. When I try to use User Identity to connect to my local Db server, it gives me the error that login failed for user <my domain username>. I have both sql server and windows authentication mode login enabled on my sql server. Any help in this regard is appreciated.

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.

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.

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

Learn how to use SharePoint Designer 2010 to define external content types and to set up a SharePoint Server search crawl that includes that external data.

when i tried to create new external content type in sharepoint designer in ribbon it show error like

when i tried to create new external content type in sharepoint designer in ribbon it show error like  "  The server was unable to process the request due to an internal error, for more information about the error, either turn on includeexceptiondetailsinfaults (tither from servcebehaviorattribute or from the <servicedebug> configuration behavior) on the server in order to send the exception infromation back to the client, or turn on tracing as per the microsoft .net framework 3.0 sdk documentation and inspect the server trace losgs.  "

SharePoint Tutorial - Content Types

SharePoint content types provide users with a way to manage and organize content in a more meaningful way. It's a reusable of settings you want to apply to a particular type of document in a library or item in a list.

Office Apps: Integrate VSTO with SharePoint Content Types


See how to build a document-level Visual Studio Tools for Office customization and integrate it with a content type in SharePoint.

Steve Fox

MSDN Magazine May 2008

Quick Note: Create Custom Content Types in SharePoint 2010

Learn how to create a custom content type. Then you add two fields to the content type: a new text field and a field that already exists in web site.

Quick Note: Create Lists with Custom Content Types in SharePoint 2010

Learn how to create a list in SharePoint Server 2010 and associate it with a new content type. Next, you disassociate the list from the content type and then delete the list.

Video: What are SharePoint 2010 Content Types?

This video provides an overview of working with Content Types programmatically. (Length: 2:59)
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