3
Vote

Using SqlFunctions

description

I find in a test using effort that uses a query using SqlFunctions, I get an exception. I can see why this would be - SqlFunctions being SQL specific and Effort looking to remain database agnostic. But wonder if anyone has any suggestions to get around this?

Thanks

Andy

file attachments

comments

tamasflamich wrote Jun 9, 2014 at 8:26 PM

Hello,

Thank you for reporting this issue.

Which SqlFunctions do you need support for?

abutland wrote Jun 9, 2014 at 9:15 PM

Hi Tamas - specifically it was SqlFunctions.DatePart I was looking to use.

Cheers

Andy

RiazThara wrote Nov 24, 2015 at 6:52 PM

How could we do setup on init or write test, when some of the repository code that we intend to test using effort makes call to SQL functions or user defined functions that exist in actual DB but not in nmemory, is there a standard practice to create alternate deterministic function equivalents in DB during init?