As related to the new database functionality in version 12, I am trying to retrieve a specific entity (row) or group of entities (multiple rows) between a date range in an MS SQL database. The database I am looking at has 4 columns, "SKUNumber"
, "Quantity"
, "Price"
, "SoldDate"
. How can I construct a query (EntityFuncton
?) to do that?
The equivalent SQL query would have the WHERE
clause be:
WHERE SKUNumber = '1111'
AND SoldDate > '2019-05-31 00:00:00.000'
AND SoldDate < '2019-09-01 00:00:00.000'
The quick guide can be found:
Thanks!