-
I'm using the esDataSource for binding information to a GridView. I have a dynamic query which pulls from a base object and joins to additional tables, summing some of the information and calculating certain columns. Everything had been working fine until I began testing the sort on the grid. The columns...
-
I have a unique scenario where my application will be creating new tables during run-time. These tables will have the same schema, but will have unique names. What options do I have with entity spaces, to use and entity object for querying these types of tables. In this scenario, I would need to specifiy...
-
I'm in the process of upgrading our current ES objects to the latest ES2009 Q3 (2009.2.0928.0). I figured out that I now need to include the DynamicQuery.dll which fixed most issue. Now in my implementation I get the following error: Error 6 Operator '=' is not defined for types 'EntitySpaces.DynamicQuery...
-
Hi EntitySpace Gurus! I have a solution that has a number of entityspaces database connections to (mostly) SQL databases. When I update one of these connections, I have to re-start the application for all the connections to have correct information. Is there are way of updating the ConnectionString property...
-
When I first started using Entity Spaces, I only knew about the stored procedures (which are very easy and very cool). Now there is a lot of emphasis on Dynamic Queries. Which is better and why? Is there a time to use one and not the other? IMHO, dynamic queries require me to learn a new syntax and write...
-
I am using needing to write an Entityspaces .WHERE construct for this query. Code: select * from stocktransaction where stockitemid = 1263 AND location =1 and date > '2009-06-02 11:58:40.00' and not (audit=27 and pos=94) and i've got most the query sorted with the following but i'm stuck on how to...
-
I'm working on a query to compare a string to my varchar field in the database. I want to replace certain characters, such as a dash "-" (really remove the dash). My SQL looks something like this: Code: SELECT * FROM qual WHERE REPLACE (qual.QualNumber, '-' , '' ) = REPLACE (@Number, '-' , '' ) I can...
-
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, I'm sure this is not a new topic, but I would appreciate your advice on the best way (or products) to design reports that use dynamic queries as a datasource. Most report designers rely on the fact that you assign an existing schema object to the report before you can use their designer surfaces...
-
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...