Custom where clause with string?

Question

I am returning a dataset using SubSonic.SqlQuery of two related objects, but I cannot figure out how to execute this where clause:

Month(SubmittedOn)=Month(GETDATE()) AND Year(SubmittedOn)=Year(GETDATE())

I tried to do it like this, but I didn't like the .IsEqualTo (line):

.Where("Month(SubmittedOn)").IsEqualTo("Month(getdate()")

0

Scott May 20 '09 at 15:26

2 answers

It looks like you are missing a parenthesis. Try:

.Where("Month(SubmittedOn)").IsEqualTo("Month(getdate())")

0

RedFilter May 20 '09 at 15:28

Adam cooper · Accepted Answer · 2009-05-21T16:24:34+0000

You can only pass the value to the constraint method (IsEqualTo) in SubSonic so that the following will get all strings presented in March:

.Where("Month(SubmittedOn)").IsEqualTo(3)

Listed below are all lines featured in the current month:

.Where("Month(SubmittedOn)").IsEqualTo(DateTime.Now.Month)