0
Reply

Display data from multiple tables using wcf service

anil babu

anil babu

Jul 7 2014 11:14 AM
722
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