anil babu

anil babu

  • NA
  • 111
  • 63.3k

Display data from multiple tables using wcf service

Jul 7 2014 11:14 AM
This is my data model
Load  
  Order Number
  Book Date
  Booked By
  Status
  Invoice Status
  PaperWork Status
  Bill To
  Start Date
  Completion Date
  Total Miles
  Trailer
  Priority
  Freight (0..n)
  Load Requirement (0..n)
  Stop (1..n)

Using this one create wcf service,
What is the meaning of the above? 

I want this type of output
<OrderNumber>1</OrderNumber> <BookDate>2014-07-21T00:00:00</BookDate> <BookedBy>Sampath</BookedBy> <CompletionDate>2014-04-23T00:00:00</CompletionDate> <Freight> <Commodity>...</Commodity> <Count>...</Count> <CountUnit>...</CountUnit> ... </Freight> <InvoiceStatus>p</InvoiceStatus> <LoadRequirement>sam</LoadRequirement> <Note>varify</Note> <PaperWorkStatus>Wait</PaperWorkStatus>

Once see my code

Attachment: loadrestservice.zip