Translation from SQL to LinQ

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
Zero-G.
Posts: 398
Joined: Sat 09 Dec 2006 12:20

Translation from SQL to LinQ

Post by Zero-G. » Tue 17 Feb 2009 12:48

Hey
Can you please help me, to translate the following SQL to LinQ

Code: Select all

Select * From Type Where (CURDATE() Between IfNull(lieferbar_ab, CurDate()) And IfNull(lieferbar_bis, CurDate()))
Don't know how to use a "IfNull"

THX

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 24 Feb 2009 11:29

This method is not supported yet, but we are working on it. I will let you know as soon as it is available

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 25 Feb 2009 15:12

This method is supported in the upcoming build.

Post Reply