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

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

Sharepoint Foundation - Validation for external content types

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :SharePoint

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.


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)

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.



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.

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.

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

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.

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)

Video: Programming with SharePoint 2010 Content Types

This video demonstrates how there are certain types of things you can do with Content Types programmatically that are not achievable with the UI. (Length: 5:33)

Best Practices for Content Types in SharePoint Server 2007 and Windows SharePoint Services 3.0

Learn best practices to develop, deploy, and manage custom content types, as well as scenarios for making updates to existing content types in lists.

Sharepoint 2010 Missing Content Types

Has anyone run into an issue where your system's base content types dissappear after deploying a new site definition.  We are doing a proof of concept using several CMS solutions and decided to see how sharepoint would fare in the process.  I worked on the POC for 6 weeks without any issues.  After selecting sharepoint as the solution I started refactoring my code into a more logical structure as many of the components were developed from sample code.  I created a couple of custom site definitions that were pretty simple.  Basically I copied the onenet.xml from the publishing site template that sharepoint uses and made a few simple modifications like associating my custom master page and a custom content type with the default page.  When I initially developed these I had no issues at all but yesterday I suddenly was not able to create sites using these site defs.  I figured there was some kind of conflict with my old templates so I deleted all site collections on the server and then tried to create a new site collection and then I couldn't even create a base publishing site.  I got an error indicating the base content type did not exist.  After spending hours going through logs it was clear that sharepoint was not able to build the content type hiearchy when creating new sites so I took a look at the UI and there were only abo
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