How do I get access to all the oData commands?

[sitefinitysteve]

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

[sitefinitysteve]

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

[sitefinitysteve]

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>

[sitefinitysteve]

Works fine with EF

[Petko_I]

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

[G.]

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. 

[Thomas]

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

[G.]

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.

[Thomas]

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