问题原因是OData默认不支持毫秒级别的日期排序和筛选，需要手动配置。 在启用OData的服务中，我们需要为DateTime类型设置序列化格式。此外，还需要配置OData选项以使用自定义函数来处理毫秒级日期筛选。以下是代码示例：

1. 在Startup.cs文件中更新配置：

using Microsoft.AspNet.OData.Formatter; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.OData.Extensions; using Microsoft.Extensions.DependencyInjection;

public void ConfigureServices(IServiceCollection services) { services.AddOData(); services.AddMvc(options => { foreach (var formatter in options.OutputFormatters.OfType() .Where(it => !it.SupportedMediaTypes.Any(m => m.MediaType == "text/event-stream"))) { formatter.SupportedMediaTypes.Add(new MediaTypeHeaderValue("application/prs.odatatestxx-odata")); foreach (var mediaType in formatter.SupportedMediaTypes.Where(t => t.MediaType.StartsWith("application/xml"))) { mediaType.MediaType = $"application/xml;odata.metadata=full;q={mediaType.Quality ?? 0.5:F1}"; }

       foreach (var mediaType in formatter.SupportedMediaTypes.Where(t => t.MediaType.StartsWith("application/json")))
       {
           mediaType.MediaType = $"application/json;odata.metadata=full;q={mediaType.Quality ?? 0.5:F1}";
       }

} }

public void Configure(IApplicationBuilder app, IHostingEnvironment env) { app.UseMvc(routeBuilder => { //Enable query options for OData. routeBuilder.EnableQueryOptions();

    routeBuilder.MapODataServiceRoute("odata", "odata", GetEdmModel(), new DefaultODataBatchHandler());

}); }

2. 创建一个自定义函数以处理毫秒级日期筛选：

[HttpGet] public async Task> QueryPeople( [FromODataUri] DateTime startTime, [FromODataUri] DateTime endTime) { var filter = Builders.Filter .Gte(entity => entity.Timestamp, startTime.ToUniversalTime()) .And(Builders.Filter.Lte(entity => entity.Timestamp, endTime.ToUniversalTime())); var result = await