Pages

Feb 4, 2011

Problems with SPMetal in SharePoint 2010

  1. SP metal can run against BCS - external content types don't get created by SPMetal;
  2. Hidden fields are not available to the SPMetal created proxy i.e. created by. Parameters.xml can be changed to display these default hidden fields; and
  3. Some column types are not picked up by SPMetal namely "Managed Metadata columns", "Publishing Html" or "Publishing Image". Additionaly any custom created columns are not included by SPMetal.
  4. Anonymous LINQ needs a work around. Update 27/11/2010, August Cumulative Update (CU) for SharePoint 2010 apparently fixes the anaonymous Linq to SharePoint issue. Ensure you get the latest CU due to the rerelease issues.
  5. Update: 08 Oct 2010 - List attachments are not picked up by SPMetal. You will need to use the Server side object model or extend SPMetal using a partial class.
  6. Update: 14 Oct 2010 - Multiselect columns are not updateable with mulitiple values using LINQ to SharePoint. You can update with 1 value only.
  7. Update 18 Oct 2010 - SPMetal does not like spaces in the url to the site that it generates off. Error the web at 'http://demo.dev/sites/my site' could not be found.
  8. Update 27 Nov 2010 - Using Linq to SharePoint across site collections.

2 comments:

Paul Beck said...

You can show hidden fields by using a parameters.xml file when generate the proxy using SPMetal.exe as shown here
http://blog.sharepointsite.co.uk/2011/05/splinq-parameterxml-to-show-hidden.html

Praveen Kumar Raju. P said...

Thanks paul for the information.....