Imports System
Imports System.IO
Imports System.Collections
Imports System.Collections.Generic
Imports System.Runtime.Serialization
Imports ServiceStack
Imports ServiceStack.DataAnnotations
Imports Test.ServiceModel
Imports Test.ServiceModel.Types
Namespace Global
Namespace ServiceStack
<DataContract>
Public Partial Class AuditBase
<DataMember(Order:=1)>
Public Overridable Property CreatedDate As Date
<DataMember(Order:=2)>
<Required>
Public Overridable Property CreatedBy As String
<DataMember(Order:=3)>
Public Overridable Property ModifiedDate As Date
<DataMember(Order:=4)>
<Required>
Public Overridable Property ModifiedBy As String
<DataMember(Order:=5)>
Public Overridable Property DeletedDate As Date?
<DataMember(Order:=6)>
Public Overridable Property DeletedBy As String
End Class
<DataContract>
Public Partial Class QueryBase
<DataMember(Order:=1)>
Public Overridable Property Skip As Integer?
<DataMember(Order:=2)>
Public Overridable Property Take As Integer?
<DataMember(Order:=3)>
Public Overridable Property OrderBy As String
<DataMember(Order:=4)>
Public Overridable Property OrderByDesc As String
<DataMember(Order:=5)>
Public Overridable Property Include As String
<DataMember(Order:=6)>
Public Overridable Property Fields As String
<DataMember(Order:=7)>
Public Overridable Property Meta As Dictionary(Of String, String)
End Class
Public Partial Class QueryDb(Of From, Into)
Inherits QueryBase
End Class
<DataContract>
Public Partial Class QueryResponse(Of T)
<DataMember(Order:=1)>
Public Overridable Property Offset As Integer
<DataMember(Order:=2)>
Public Overridable Property Total As Integer
<DataMember(Order:=3)>
Public Overridable Property Results As List(Of Poco)
<DataMember(Order:=4)>
Public Overridable Property Meta As Dictionary(Of String, String)
<DataMember(Order:=5)>
Public Overridable Property ResponseStatus As ResponseStatus
End Class
End Namespace
Namespace Test.ServiceModel
Public Enum LivingStatus
Alive
Dead
End Enum
Public Partial Class QueryDbTenant(Of From, Into)
Inherits QueryDb(Of From, Into)
End Class
Public Partial Class QueryRockstarAudit
Inherits QueryDbTenant(Of RockstarAuditTenant, RockstarAuto)
Public Overridable Property Id As Integer?
End Class
Public Partial Class RockstarAuditTenant
Inherits AuditBase
Public Overridable Property TenantId As Integer
Public Overridable Property Id As Integer
Public Overridable Property FirstName As String
Public Overridable Property LastName As String
Public Overridable Property Age As Integer?
Public Overridable Property DateOfBirth As Date
Public Overridable Property DateDied As Date?
Public Overridable Property LivingStatus As LivingStatus
End Class
Public Partial Class RockstarAuto
Inherits RockstarBase
Public Overridable Property Id As Integer
End Class
Public Partial Class RockstarBase
Public Overridable Property FirstName As String
Public Overridable Property LastName As String
Public Overridable Property Age As Integer?
Public Overridable Property DateOfBirth As Date
Public Overridable Property DateDied As Date?
Public Overridable Property LivingStatus As LivingStatus
End Class
End Namespace
Namespace Test.ServiceModel.Types
Public Partial Class Poco
Public Overridable Property Name As String
End Class
End Namespace
End Namespace
VB.NET QueryRockstarAudit DTOs
To override the Content-type in your clients, use the HTTP Accept Header, append the .csv suffix or ?format=csv
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /csv/reply/QueryRockstarAudit HTTP/1.1
Host: test.servicestack.net
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"id":0,"skip":0,"take":0,"orderBy":"String","orderByDesc":"String","include":"String","fields":"String","meta":{"String":"String"}}
HTTP/1.1 200 OK Content-Type: text/csv Content-Length: length {"offset":0,"total":0,"results":[{"id":0,"firstName":"String","lastName":"String","age":0,"dateOfBirth":"\/Date(-62135596800000-0000)\/","dateDied":"\/Date(-62135596800000-0000)\/","livingStatus":"Alive"}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}