Generate the smallest/bigest COMB for a date in C#

[Michael-Anderlin]

Hello,

I'm are using Entity Framework to select data from DB. The PK of the table is a COMB GUID.
I would like to get the list of records for a date using the COMB PK for efficiency.
Following your doc, I'm able to generate the COMB "boundaries" of the day in SQL Server side but not in C#.
e.g. >= 2023-10-11 00:00:00.000 to <= 2023-10-11 23:59:59.999 or better < 2023-10-12 00:00:00
=>

'00000000-0000-0000-0000-018B1C087C00' to <= FFFFFFFF-FFFF-FFFF-FFFF-018B212ED800 or < 00000000-0000-0000-0000-018B212ED800

I could do it by splitting/concatating string but is there another way?

Tx.

Michael