Please consider altering or providing configuration for how DateTime values are formatted in filter expressions generated by ToDataSourceRequest(). Currently, the format includes full precision (e.g., 2025-04-04T00:00:00.0000000), which causes issues when passed to Entity Framework Core with SQL Server, as SQL Server expects precision up to milliseconds (.fff), not ticks (.fffffff).
Why This Is a Problem
- When passing filter expressions from ToDataSourceRequest() directly into a LINQ-to-EF query, the resulting SQL query fails if the DateTime string has 0000000 (7 digits of precision).
- SQL Server’s datetime and datetime2 types don’t support nanosecond-level precision.
- EF Core attempts to translate it, but fails with SQL conversion errors
Hi Kenneth,
The filter expressions generated by ToDataSourceRequest() are in a List of IFilterDescriptor. The IFilterDescriptor contains the dates as DataTime objects and not as strings in the format that you listed. Having that in mind, it is currently not clear how you are getting this format and hitting an issue with it. Can you provide more details and an isolated runnable sample showing your exact configuration?
In addition, can you please test the code without using the ToDataSourceRequest() and let me know if it still fails? We generally recommend using the ToDataSourceResult(request) method so it manages the operations for you when using OnRead which is different than ToDataSourceRequest(). Can you please share what are you using the ToDataSourceRequest() for?
Last but not least, based on the information I found here, datetime2 types support nanosecond-level precision. Can you please share why are you left with the impression that they don't?
Regards,
Nadezhda Tacheva
Progress Telerik
Enjoyed our products? Share your experience on G2 and receive a $25 Amazon gift card for a limited time!
- All
- Completed (1239)
- Declined (331)
- Duplicated (388)
- In Development (3)
- Need More Info (20)
- Pending Review (2)
- Planned (11)
- Under Review (1)
- Unplanned (1057)
- Won't Fix (19)
- All
- UI for Blazor
- AIPrompt
- AnimationContainer
- AppBar
- ArcGauge
- AutoComplete
- Avatar
- Badge
- Barcode
- Breadcrumb
- Button
- ButtonGroup
- Calendar
- Card
- Carousel
- Charts
- Checkbox
- Chip
- ChipList
- ChunkProgressBar
- CircularGauge
- ColorGradient
- ColorPalette
- ColorPicker
- ComboBox
- ContextMenu
- DateInput
- DatePicker
- DateRangePicker
- DateTimePicker
- Dialog
- DockManager
- Drawer
- DropDownButton
- DropDownList
- DropZone
- Editor
- FileManager
- FileSelect
- Filter
- FlatColorPicker
- FloatingActionButton
- FloatingLabel
- Form
- Gantt
- Grid
- GridLayout
- Installer and VS Extensions
- LinearGauge
- ListBox
- ListView
- Loader
- LoaderContainer
- Map
- MaskedTextBox
- MediaQuery
- Menu
- MultiColumnComboBox
- MultiSelect
- Notification
- NumericTextBox
- Page Templates / Building Blocks
- Pager
- PanelBar
- PDFViewer
- PivotGrid
- Popover
- Popup
- ProgressBar
- QRCode
- RadialGauge
- RadioGroup
- RangeSlider
- Rating
- Scheduler
- Signature
- Skeleton
- Slider
- SplitButton
- Splitter
- Spreadsheet
- StackLayout
- Stepper
- StockChart
- Switch
- TabStrip
- TextArea
- TextBox
- TileLayout
- TimePicker
- ToggleButton
- ToolBar
- Tooltip
- TreeList
- TreeView
- Upload
- ValidationMessage
- ValidationSummary
- ValidationTooltip
- VS Code Extension
- Window
- Wizard