-
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...
-
Hi All, I'm attempting my first lot of dynamic joins (in he past I've used views and never needed to use dynamic joins), and I've run into a problem accessing the join fields. Below is the code I'm using to join two tables, return all records, and then loop through the collection. The primary table fields...
-
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 ...
-
My first attempt which seemed to work was to add one column to the select clause which contained the .Count operator, and then iterate over the collection (there should only be one entity) to retrieve the value of the column. This is a bit daft. My second attempt uses this code - Code: public static...