search

sqlkata / querybuilder

SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
https://sqlkata.com
MIT License
3.06k stars 499 forks source link

db access where day error No value given for one or more required parameters. #696

Closed KarimQaderi closed 8 months ago

KarimQaderi commented 8 months ago

Hello

I use Access database

When I want to use the following code

new Query("Posts").WhereDatePart("day", "CreatedAt", 1)

When I use it, I get the following error

System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'