CODEWITHSUNDEEP
entity-frameworkentity-relationshipwcf-data-services
nvcnvn
nvcnvn

Reputation: 5175

Can WCF OData Service load related data with a single request?

I have a table that has an "Self referencing relationship" - One Wall comment maybe a child of other. This is my Data Model: 

public class UserWall
{
    [Key]
    public int WId { get; set; }

    public Guid UserId { get; set; }

    public string WContent { get; set; }

    public Guid? WriterId { get; set; }

    [DataType(DataType.DateTime)]
    public DateTime WTime { get; set; }

    public int? ParentWId { get; set; }

    public virtual UserWall Parent { get; set; }

    public virtual ICollection<UserWall> Children { get; set; }
}

And so, with this URI /MyService.svc/UserWalls(1)/ I got:

<?xml version="1.0" encoding="utf-8"?>
<entry xml:base="http://localhost:1636/CoreService.svc/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml">
  <id>http://localhost:1636/CoreService.svc/UserWalls(1)</id>
  <category term="ESN.Models.UserWall" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
  <link rel="edit" title="UserWall" href="UserWalls(1)" />
  <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Parent" type="application/atom+xml;type=entry" title="Parent" href="UserWalls(1)/Parent" />
  <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Children" type="application/atom+xml;type=feed" title="Children" href="UserWalls(1)/Children" />
  <title />
  <updated>2012-02-15T04:07:39Z</updated>
  <author>
    <name />
  </author>
  <content type="application/xml">
    <m:properties>
      <d:WId m:type="Edm.Int32">1</d:WId>
      <d:UserId m:type="Edm.Guid">e735311a-55fd-48cb-bac0-3441ae99ebea</d:UserId>
      <d:WContent>cức</d:WContent>
      <d:WriterId m:type="Edm.Guid">e735311a-55fd-48cb-bac0-3441ae99ebea</d:WriterId>
      <d:WTime m:type="Edm.DateTime">2012-02-15T01:01:00</d:WTime>
      <d:ParentWId m:type="Edm.Int32" m:null="true" />
    </m:properties>
  </content>
</entry>

And with the URI /MyService.svc/UserWalls(1)/Children I can get their children.

But is there anyway that I can load the children data without the extra request?

Upvotes: 0

Views: 488

Answers (1)

John Cornell
John Cornell

Reputation: 1087

Yes, you should be able to use the $expand keyword. Ex: /MyService.svc/UserWalls(1)?$expand=Children

Upvotes: 2

Related Questions