Hi David, Thanks for the link. I'll try and search harder next time. I thought the problem was with the where parts rather than the inner joins. I'm sure I picked up the joined up syntax from the developer docs although I can't find the exact location now. Perhaps you could add a note about this change to the docs too? Thanks, Dan  

I am attempting to perform a simple query to get the number of redemptions during a specified period of time using the DatePart function of Sql Server.  Everything was going great until I need to Group By the datepart functions since I am using the count() function in the select clause. Originally I put in the following code thinking it ...

For a query that returns virtual columns (as samples below show for simple count & subquery ) - is there a way to enum the virtual column names returned? Code:OrdersQuery ordersQuery = new OrdersQuery(''ordersQuery''); ordersQuery.es.CountAll = true; ordersQuery.es.CountAllAlias = ''Count''; OrdersCollection oc = new ...

Hi,  We are using NVarchar and NText datatype in our database. How can I compare the value of a neutral field? In noraml MS SQL query we have to place ''N'' before criteria. How to do unicode comparision while using Entity Spaces? Ex: Select * from tblCountry Where CountryName = N'बूबह' Please provide your expert comments Thanks,Mahesh

Hi Mike, Thanks for you replay. I have tried out your code, it throws following error. Currently I am using ES 2007.1.1210.0. 'EntitySpaces.Interfaces.esColumnItem' does not contain a definition for 'Query' on below line of code. itemData.Column.Query = q; I want to add default Where clause in each of the query executed, so I have override the ...

Hi Scott, We have same requirement as dipple, We want to add default criteria in where clause of every query. To achieve this I have override the load method of QueryBase class. Code is given below. But when I execute any query it throws error ''No overload for method 'esWhereItem' takes '3' arguments'' on following line.  this.Where(new ...

Hi, esWhereItem function has been changed in lates version of Entity spaces. When I write below give line in my code it throws error that there is no over loaded method with three parameters while it's working perfectly in previous version. So how I should write below given line in latest verion of Entity spaces. this.Where(new ...

Hello Mike, I am new to ES and I have diligently searched for a clue to help me with this task, without success.  Table ''Service'' contains its own PK  ''SreviceOrder'' and table ''Notes'' contains FK ''ServiceOrder'' - pointing to the obvious (it also has a PK - auto-gen --for uniqueness) . Table ''Notes'' contains from 0 to N ...

Hi,    I am having issues trying to query an SQL database using dates as the input value, the records exist in the database fro that date but Entityspaces is returning no values.   I am querying to determine if the record exisits and if it does then load the record and update it, otherwise add a new record. Unfortunately using ...

I'd like to capture and log all generated SQL.  I know about the es.LastQuery property, but I'd like to do this site-wide and not after every call to Load().  I'd love to be able to do this through configuration (hint-hint), but I sure wouldn't mind being able to subscribe to an event.  Any ideas?

Hi there I have a problem that the following source code is producing invalid SQL when it runs against my Access database.  The InnerJoin is missing a bracket and so I get a syntax error in FROM clause back from Access. Code: Dim jobItemQ As New JobItemsQuery(''j'') Dim payItemQ As New PayItemsQuery(''p'') ...

I'm able to use the Dynamic Query API to build a SELECT statement with a GROUP BY.  But, is there a way to extend that query to add a HAVING clause? For example, using Northwind, I would like to use the Dynamic Query API to generate a SQL query that looks like the following SELECT statement:Code:SELECT c.CustomerID FROM Customers c LEFT ...

Is it possible to write ''dirty read'' queries against SQL Server with EntitySpaces DynamicQuery API that would issue the NOLOCK or READUNCOMMITTED Table Locking Hint? MS Table Hint Doc  

I’m tiring to allow the user to populate the select clause from as saved list or list box.  I’m hoping to be able to pass a list into the Select or Where clause as needed.   Myview coll = new myview(); List<object> myList = new List<object>   //logic to add column names ...

Finally figured it out, and yes these are not valid uniqueidentifiers in my example Code:// I know the following doesn't work in SQL user_id in (@userList) // so I thought the following was generated user_id in (@user_id1, @user_id2, @user_id3) // instead, the following happens if passed in as a Guid or Object user_id in (111-11-1111, ...