-
I have a dynamic query with a hierarchical object model where we want to order records by the parent sort if it is a parent record, otherwise use a child sort. The query I have is this: Code: SELECT eme.[EMEntityID] , eme.[EMEntityCode] , eme.[EMEntityName] , eme.[Active] , ens.[EMEntityParentID] , eme...
-
Hello, on your documentation page http://www.developer.entityspaces.net/documentation/DynamicQuery/Join/Join.aspx I found for joined queries the following content: CustomerQuery cust = new CustomerQuery ( "c" ); OrderQuery order = new OrderQuery ( "o" ); OrderItemQuery item = new OrderItemQuery ( "oi...
-
I'm new to EntitySpaces but I'm verey familiar with it's ancestor (dOOdads) I'm trying to recreate the following SQL Statement (which is currently a stored procedure) with EntitySpaces: SELECT COUNT(*) FROM CloakData WHERE RecordType = 'UA' AND [Value] = @UAValue AND (@SpiderName = '' OR SpiderName ...