DevForce Community Forum : OData Projection

OData Projection : I was upset when I read that you...

Wed, 11 Jan 2012 15:03:17 -700

Author: smi-mark
Subject: 3207
Posted: 11-Jan-2012 at 3:03pm

I was upset when I read that you can't use navigation properties on ComplexTypes with WCF.

http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/b9e14bc6-b248-48e1-b9e3-af7600537110

With DevForce I was able to get it to work.

My complex types look like this:

AccountProjection
      int AccountId
      IEnumerable Receivables

ReceivableProjection
     int ReceivableId

By default, this will not work, you will get this error:

The server encountered an error processing the request. The exception message is 'The property 'Receivables' on a complex type 'AccountProjection' is not a valid property. Navigation properties are not supported on complex types.'. See server logs for more details.

To get past this I have simply added this to my entity manager partial class:

    public EntityQuery<ReceivableProjection> ReceivableProjections    {        get { return null; }    }     public EntityQuery<AccountProjection> AccountProjections    {        get { return null; }    }

Then I added this to my web service in InitializeService:

            config.SetEntitySetAccessRule("ReceivableProjections", EntitySetRights.All);            config.SetEntitySetAccessRule("AccountProjections", EntitySetRights.All);

Now it works, as long as I make sure to use $expand=Receivables in my query :)

OData Projection : Very cool. Thanks for sharing...

Wed, 11 Jan 2012 10:23:59 -700

Author: kimj
Subject: 3207
Posted: 11-Jan-2012 at 10:23am

Very cool. Thanks for sharing this.

OData Projection : It's all working now :)I...

Tue, 10 Jan 2012 19:33:02 -700

Author: smi-mark
Subject: 3207
Posted: 10-Jan-2012 at 7:33pm

It's all working now :)

I created my projection class and marked it with the DataServiceKey. Then in my service I added this:

        [WebGet]        public IQueryable<AccountProjection> SearchAccounts(string searchText)        {            var accounts = this.CurrentDataSource.Accounts                .Where(a => a.TaxAccountNumber.Contains(searchText))                .Select(a => new AccountProjection                                 {                                     AccountId = a.AccountId,                                     TaxAccountNumber = a.TaxAccountNumber                                 }).ToList();

            //Use my procedure to get the info I need and update the projection
           return accounts.AsQueryable();        }

Then under InitializeService I added this line:
config.SetServiceOperationAccessRule("SearchAccounts",ServiceOperationRights.AllRead);
Now I can do whatever I want to get the data, and return the projection class.

Edited by smi-mark - 11-Jan-2012 at 7:45am

OData Projection : Sure. DevForce has supported...

Tue, 10 Jan 2012 18:42:29 -700

Author: kimj
Subject: 3207
Posted: 10-Jan-2012 at 6:42pm

Sure. DevForce has supported anonymous projections with OData since version 6.0.9. I guess it might depend on which Javascript library you're using, but you can check out our OData.js sample (http://drc.ideablade.com/xwiki/bin/view/Documentation/code-sample-odata-js) which uses jQuery and datajs. The sample isn't using anonymous projections, but just add a "$select=" clause to a query. For example, "Customers?$select=CustomerId, CompanyName".

I'm not so sure about a projection from a stored procedure though ....

OData Projection : Is there a way of using projections...

Tue, 10 Jan 2012 15:47:29 -700

Author: smi-mark
Subject: 3207
Posted: 10-Jan-2012 at 3:47pm

Is there a way of using projections with OData? I'm working on a sample HTML5 app and I'd like to build a projection from a few entities and a stored procedure, then return this to the client. I know you can use views and such, but haven't seen anything about projections yet.