This project has moved. For the latest updates, please go here.

Problem with select statements using the IIf function

Dec 30, 2015 at 9:40 PM
Edited Dec 30, 2015 at 9:41 PM
It would be nice to be able to configure what table to use to handle generated IIf select statements.

Lets say we have a entity Order and you build the following query:
var date = new DateTime(2015, 1, 1);
var hasOldOrders = db.Orders.Any(x => x.Date < date);
This would throw an exception for my databases because MSysRelationships is hidden in my databases for security reasons. This is something I cannot change in my organization.
Coordinator
Jan 3, 2016 at 4:06 PM
You'll find it in next release.
There will be a static property JetConection.DUAL where you can set what you need.
See documentation for constraints.