DateTime and BETWEEN

Use the BETWEEN operation on DateTime values.

For example:

Parameters param = db.CreateParameters();

param["dt1"] = new DateTime(2009, 05, 02);

param["dt2"] = new DateTime(2009, 05, 04);

var res = db.ExecuteQuery("SELECT BasicUser WHERE BirthDate BETWEEN @dt1 AND @dt2", param);