DateAdd and DatePart Functions

Starting with version 1.1.0 of FluentSql DateAdd and DatePart Sql functions are available for usage in the Where clause. They are accessible through public static methods of the SqlFunctions class. These functions were designed to take entity types as parameters. The following are a list of the available functionality:

DateAdd Sql Functions

• AddYears
• AddQuarters
• AddMonths
• AddDayOfYear
• AddDays
• AddWeeks
• AddDayOfWeek
• AddHours
• AddMinutes
• AddSeconds
• AddMilliseconds

DatePart Sql Functions

• GetYear
• GetQuarter
• GetMonth
• GetDayOfYear
• GetDay
• GetWeek
• GetWeekDay
• GetHour
• GetMinute
• GetSecond
• GetMillisecond