Home / Community & Support / Developer Productivity Tools Forums / OpenAccess ORM > Telerik Data Services Wizard > How do I get access to all the oData commands?

• Steve MVP

  Posted on Nov 2, 2010 (permalink)

  I have the Astoria V2 service running, and all works well if I just use the Navigation Links specified in the resulting Atom feed...
  
  But any attempt to use $format, or $select seems to bomb with a 400 (or other error).  Im following this oData document
  
  Is there something I need to enable or do that the DSW isn't creating to get me some JSON or XML?
  
  
  **EDIT**
  Oh wait, is it because of this?
  
  Im getting a 500 on a $select

  Reply

• Steve MVP

  Posted on Nov 3, 2010 (permalink)

  Should I just scrap it and do it from scratch with Entity Framework instead?
  (I would very much rather not have to use EF)

  Reply

• Steve MVP

  Posted on Nov 3, 2010 (permalink)

  Verbose errors throwing this on a select
  
  

    <?xml version="1.0" encoding="utf-8" standalone="yes" ?>

  - <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">

    <code />

    <message xml:lang="en-US">An error occurred while processing this request.</message>

  - <innererror>

    <message>An exception occured during the execution of ' Extent<ShopService.Category>.Select(p => IIF((p == null), null, new ProjectedWrapper2() {ResourceTypeName = "ShopService.Category", PropertyNameList = "ParentID,ID", ProjectedProperty0 = Convert((p As Category).ParentID), ProjectedProperty1 = Convert(Convert((p As Category).ID))}))'. See InnerException for more details.</message>

    <type>System.InvalidOperationException</type>

    <stacktrace>at Telerik.OpenAccess.Query.ExpressionCompiler.PerformDatabaseQuery(Type type, Int32 elementAt, Object[] groupResolutionParamValues, Boolean single) at Telerik.OpenAccess.Query.ExpressionExecution.PerformDatabaseQuery[T](Piece`1 piece, Object[] grpVals) at Telerik.OpenAccess.Query.Piece`1.System.Collections.IEnumerable.GetEnumerator() at System.Data.Services.Internal.ProjectedWrapper.EnumerableWrapper.GetEnumerator() at System.Data.Services.WebUtil.GetRequestEnumerator(IEnumerable enumerable) at System.Data.Services.DataService`1.SerializeResponseBody(RequestDescription description, IDataService dataService) at System.Data.Services.DataService`1.HandleRequest()</stacktrace>

  - <internalexception>

    <message>Unable to cast object of type 'System.Object[]' to type 'OpenAccessRuntime.DataObjects.query.Node'.</message>

    <type>System.InvalidCastException</type>

    <stacktrace>at Telerik.OpenAccess.Query.ExpressionCompiler.PerformDatabaseQueryImpl(Type type, Int32 elementAt, Object[] groupResolutionParamValues, Boolean single) at Telerik.OpenAccess.Query.ExpressionCompiler.PerformDatabaseQuery(Type type, Int32 elementAt, Object[] groupResolutionParamValues, Boolean single)</stacktrace>

    </internalexception>

    </innererror>

    </error>

  Reply

• Steve MVP

  Posted on Nov 3, 2010 (permalink)

  Works fine with EF

  Reply

• Petko_I Petko_I

  Posted on Nov 8, 2010 (permalink)

  Hello Steve,
  
  Firstly, we would like to apologize for the inconvenience caused. The error you are receiving is one that we are aware of and we are addressing this issue. We are currently redesigning our provider for the Data Services with which we will extend our supported features in the area. Unfortunately the changes will not make it into the Q3 official release but we will provide a resolution as soon as possible. In your first post you have correctly identified another related topic which essentially addresses the same issue. There will be further improvements in the Data Services Wizard which will come together with the extended support for the Data Services.
  
  All the best,
  Petko_I
  the Telerik team

  Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

  Reply

• G.

  Posted on May 10, 2011 (permalink)

  Petko - I am using 2001 Q1 Release and it appears that you have the $filter issue fixed, but I still cannot use $select against the OData service I created on top of a Model generated by OA. Any plans on addressing this soon? I also posted a description here. 

  Reply

• Thomas Thomas

  Posted on May 11, 2011 (permalink)

  Hello G.,

  I just fixed this issue ($select puts a protective conditional into the LINQ that is not handled correctly.)
  The next version will have the needed changes; no release date has been set yet. 

  Greetings,
  Thomas
  the Telerik team

  Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.

  Reply

• G.

  Posted on May 11, 2011 (permalink)

  Thanks, Thomas. It is great to see a company that takes support as seriously as you guys do. Please post here when you decide if the fix will be a prat of a hotfix, realease or otherwise available. Thanks again for you help. G.

  Reply

• Thomas Thomas

  Posted on Jun 20, 2011 (permalink)

  Hello G.,
  
  this issue was fixed, we improved our projeciton handling greatly. The upcoming Q2 2011 release will contain the needed bits.
  
  Best wishes,
  Thomas
  the Telerik team

  Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.

  Reply

Back to Top

Home / Community & Support / Developer Productivity Tools Forums / OpenAccess ORM > Telerik Data Services Wizard > How do I get access to all the oData commands?