.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

Regarding Insert in External Content Type

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#


I have created web service which supports CRUD operation. 

1. I have created external list using SPD with all the operations in one go. This time all the operations are working fine when i try to work on them using a form generated via SPD.

2. I have created external list with only 3 operations say Read Item, Read List and Insert. Now when i try to insert from the form its working fine. Now i have added rest of the two operations say Update and Delete and have updated the form by clicking on "Create Lists and Forms" tab in the ribbon. Now when i try to insert, its not able to refresh the page automatically. The record gets added but i manually have to refresh the page. It gives warning saying that the id which i am passing to a method of Read Item is null. But if it is the case then why it was working in Case 1?. As what i know, sharepoint calls Read Item after every Insert call so it should be able to pass the generated id from the Insert method by itself.


I am working with SharePoint  2010.

View Complete Post

More Related Resource Links

Insert Image column in External content type

Hi,   I've created an external content type. It pulls in data from SQL Server Database. I need to have the first column as an image based on the value of one of the columns. Could anyone please suggest how to add a column so represent an image in external list.   Regards, Zia

BCS Updater Method in External Content type


HI, I have a List (External Content type ) with CRUD methods written.for example. Employee with fields






If want to update only Remarks field and want to display the other fields.(other field should not be editable). How can i do it throught VS2010. If I made those fields readOnly and preupdaterField true. those fields not displays while editing. I want to show those fields but not to edit. any suggestions????

2)while displaying (ReadList )if I want to display only EmpName and EmpID.How can i do it?


or please try to give some links about all the properties for a Type Decriptor and how they are related with CRUD methods.



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.

BCS : How to set permissions to an external content type's method

guys, Environment: sp 2010, BCS using SPD I have created an external content type from a LOB sql server 2008 DB, created list and form pages, created read, update, delete, edit methods( all the default operations that SPD shows), from the list page i am able to read and write data back the LOB DB also successfully. Also i know there are permissinos that i can set on the external content type but the problem that i am facing is that i dont see any place\ option where i can assign\ restrict permissions of the content type's method to a certain SP group from neither CA nor SPD i.e if i want a certain group to have only execute permissions only on READ method. Would be great if anyone can tell me if at all this is possible. thanks sameer

BCS Method Security / External Content Type Permissions / Custom List Security Provider / Security T


I have an external list setup with the usual CRUD methods.  The external SQL table is also being populated by another source.  I want to enable/disable deleting depending on whether the record was created from SharePoint.  I would also like the normal list permissions to work.  So if a user has permissions to delete on the list, they can only delete items created for SharePoint. 

Where should this logic be incorporated?  On the BCS Delete method, somewhere in the External Content Type or on the list instance?  Most examples I find relate to security trimming for search.  I'm only concerned about the delete method.

I'm sure there are multiple ways to accomplish this.  Which is the best?


Custom Action for specific External Content Type List


I have an External Content Type list instance feature in Visual Studio. Deploying the instance works fine. However, I can't create a custom action using RegistrationId="{$ListId:Lists/yourlistname;}" RegistrationType="List"

Even if I specify the list Id as follows RegistrationId="{8F595340-5D08-4287-8BF6-30D50989D2F4}" or RegistrationId="8F595340-5D08-4287-8BF6-30D50989D2F4" I get nothing.

However, RegistrationId="600" works fine, but for all External Content Type lists.

I added the custom action with SharePoint Designer and it works as expected. When I generate a site template and import it into Visual Studio, the custom action uses RegistrationId="{$ListId:Lists/yourlistname;}" RegistrationType="List"

Creating a new site based on the site template creates the custom action correctly. However, deploying just the custom action does not work (feature deploys, but no custom action appears). I also tried RegistrationId="0x0100D67E541CC4BB6A4A9D62D22657ECFF68" RegistrationType="ContentType" with no luck. The content type id was pulled from the list instance using the object model.

I have to tie the custom action to a specific list instance. Because the li

Edit form List for External content type



I've made a list based on an extenal content type and create an InfoPath form just for viewing details on list items (read only)

My problem is that  the page(displayifs.aspx) displaying this form doesn't have a title (it's blank) and I don't know how to change it.



Sorin Sandu

External Content Type - Read List Operation - "Cannot find a collection element of a supported type.


I'm trying to define External Content Type Operations for an External Content Type. I can add a Connection, Type "WCF Service" no problem. And I can define a "New Read Item Operation" using that connection.

But I can't define a "Read List Operation". I get the following error message, in the Return Parameter Configuration: "Cannot find a collection element of a supported type..." it goes on to say - see the help documentation for supported types. I can't find any help documentation on this.

I've tried returning different types in the provider web service but keep getting the same error. What are the supported types the web service can return?

The reading I've done suggests that you can connect to a non-MS web service using a connection type of "WCF Service". Is this correct? If it is what's the best soap format the web service provider should use - Doc/Literal?



Error When Creating on External Content Type



- I have a  SharePoint site . Then I Open my Site by SharePoint designer .

- When I press on "ExternalContentType" to create a new one  , but the following Error appeared :

     "There is no Business data connectivity service associated with the current web context" .

     How Can I solve this problem ?






Infopath External Content Type Pickers


Greetings ,

i have two external content types (manager, worker) defined in sharepoint 2010. On my infopath 2010 form i have 2 external content type pickers. Now each of these pickers works fine on its down and returns me the full list of all managers or workers, but what i want to do is connect the two. So when the end user attempts to select an employee it would only show employees who have a manager_id equal to what was put in the previous external content type picker(manager).

Could this be achieved by using a combo of Association and filters?







hikin, bikin, coding machine

Create View in an External List that Gets a Field from Another External Content Type via Foreign Key


I currently have two tables in a SQL Server 2k8 database: Locations and Customers

The fields in the Locations table are:

  • LocationName
  • StreetAddress
  • City
  • State
  • ZIP
  • CusotmerID (foreign key joined to Customers table)

The fields in the Customers table are:

  • ID (primary key)
  • CustomerName
  • CurrentBalance

Through SharePoint Designer, I have both tables set up as External Content Types of the same names as the tables and have created External Lists for each External Content Type. All CRUD operations are working perfectly. I added the proper Assocaiation and I've set CustomerName to be the Title of the Customers External Content Type. I can currently use a picker for CustomerID in the Locations List and CustomerName is displayed properly. Also, the default DispForm also correctly displays the CustomerName for any single Location record.

However, I would like to modify the default ReadList so the foreign key (CustomerID) will show the Title field of Customers (CustomerName). However, I am running into trouble finding out how to do this.

Any help with this issue would be greatly appreciated!!


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.

Error during creating External Content Type



I am having Sharepoint 2010 Enterprise RTM Trial on Windows Server 2008 SP2 with SQL server 2008 enterprise installed. I have another machine (mac2) on the domain having another Database  on SQL Server 2005. I want to use business connectivity services for External Content types for making a connection with mac2 database  . I have followed the following article:


In step 3 of the above mentioned article, i have failed to connect with User Identity selected....

Can anybody help me out with this ?

SharePoint 2010 External Content Type and InfoPath 2010 - Numeric data type fields missing in InfoPa


Connected SQL data table to SP 2010 ECT from SQL table.  The SQL table has several fields that have a type of "numeric(3,0)".  The SP 2010 list shows all fields form SQL.  When we open up InfoPath Designer and reference the SP List data (from SQL) all of our numer fields are missing from the available fields list.

I amd going to try another data type but that hardly feels like a solution.  If anyone has any ideas please let me know!

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 :)



External Data Fields in a Word Template saved as a content type in a document library with multiple


I have created a Word Template for a Document Library that has an External Data Column in it of Client Name which also adds Client Address1, Client Address2, Client City, Client State, & Client Zip.  Now this works fine for a Document library with that template as the Template.dotx file. 

I want to be able to make a bunch of Templates and have them all as Content Types in one Library.  When I do this I cannot get the External Data Quick Parts to work.

Anyone have any ideas?

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