Alex Rivera | Logout

How to send DateTime parameters to WCF DataService

Asked 2011-04-03T07:34:57.677
11

I have simple function on the DataService that get DateTime parameter

[WebGet]
public IQueryable<Job> LoadJobsByDate(DateTime startDate, DateTime endDate)
{
    var context = this.CurrentDataSource;

    var jobs = from j in context.Jobs
               where j.CreatedDate >= startDate && j.CreatedDate <= endDate
               select j;

    return jobs;
}

What ever syntax I'm try to send I get error.

I tried

var query1 = newContext.CreateQuery<Job>("LoadJobsByDate")
             .AddQueryOption("startDate", 
                 string.Format ("'{0:yyyy-MM-ddTHH:mm:ss}'", DateTime.Now));  

or:

var query1 = newContext.CreateQuery<Job>("LoadJobsByDate")
             .AddQueryOption("startDate", 
                 string.Format ("'datetime{0:yyyy-MM-ddTHH:mm:ss}'", DateTime.Now));  

Please advice

wcf
Edit
Report

1 Answer

24

You can submit a DateTime object to the service through a HTTP request using the ISO 8601 timestamp format, which expresses time as yyyy-mm-ddThh:mm:ss (example: 2011-06-02T12:24:34).

answered 2011-06-02T17:24:34.460

Your Answer