TopRange does not generate correct query for SQL Client

Hi, I having an issue when using TopRange method for sql client. Following lines generates non-valid sql query. DBSelectQuery sel = DBQuery.Select() .Field("ProductKey") ...

Id #35602 | Release: None | Updated: Oct 8, 2014 at 3:09 PM by osmantelli | Created: Oct 8, 2014 at 3:03 PM by osmantelli

Create table with composite Pirmary Key fail

The code: DBCreateTableQuery createTable = DBCreateTableQuery.Create.Table("Test"); createTable.Add("c1", DbType.String, 100, DBColumnFlags.PrimaryKey); createTable.Add("c2", DbType.String, 100, DB...

Id #35562 | Release: None | Updated: Sep 23, 2014 at 7:21 PM by nlips | Created: Sep 23, 2014 at 12:03 PM by nlips

Decimal constant not correctly translated into SQL

For example, if the CurrentCulture of the thread is French, the value "1.23" will be translated to "1,23". The conversion from double to string must use CultureInfo.InvariantCulture.

Id #35550 | Release: None | Updated: Sep 17, 2014 at 11:46 AM by nlips | Created: Sep 17, 2014 at 11:46 AM by nlips

Error loading xml

An error is thrown when using DBSelectQuery.ReadXml, from a previously generated xml. Error occurs when xml that is loading has aggregated operations, like multile where clauses with bool-op. Thi...

Id #34672 | Release: None | Updated: Nov 22, 2013 at 11:41 AM by Portugalio | Created: Nov 22, 2013 at 11:41 AM by Portugalio

Syntax error at Sql Server Paginating

hello i'm trying to apply paginating on ms sql server "SqlClient" this is the generated sql string SELECT [Persons].[ID], [Persons].[PersonName], [Persons].[PersonAge] FROM ( SELECT ROW_NUMBER...

Id #34318 | Release: None | Updated: Jul 28, 2013 at 12:55 PM by YousifJamri | Created: Jul 28, 2013 at 12:55 PM by YousifJamri

InvalidCastException - Issue with Double column type.

When creating a table with a double column (targeting MS Sql Express 2012) DBCreateTableQuery createTableQuery = DBQuery.Create.Table("dbo", "mytablename"); createTableQuery = createTableQuery....

Id #33940 | Release: None | Updated: Apr 6, 2013 at 4:36 PM by DarrellTunnell | Created: Apr 6, 2013 at 4:36 PM by DarrellTunnell

Encounter a problem of subquery alias in Oracle

When I construct a query which involves subquery alias, I find that an AS keyword is appended between the subquery and the alias name. However it is correct when the AS function is used on normal t...

Id #33809 | Release: DynaSQL Source | Updated: Feb 22, 2013 at 10:48 AM by perceiveit | Created: Feb 22, 2013 at 10:48 AM by perceiveit

Create Database

Great Library. For my specific scenario, it would be very useful to determine if a database exists, and if not have the ability to create it. There are allready methods in the library to allow cr...

Id #33777 | Release: None | Updated: Jul 29, 2013 at 4:24 PM by YousifJamri | Created: Feb 14, 2013 at 4:33 PM by DarrellTunnell

bug with 12-hours time saving

Library generates string representation of DateTime columns using 12-hours format of time. It should use 24-hours format, because at the moment - it saves 05 am and 05 pm as the same value in some...

Id #33301 | Release: None | Updated: Jun 14, 2013 at 8:12 AM by perceiveit | Created: Oct 30, 2012 at 8:19 PM by sebcyg

Multiple Databases

Hi to everyone, i'm trying Dynamic SQL Generator and it seems to work pretty well. Unfortunately i've a particular need that force me to launch query which access to multiple databases simultaneous...

Id #32590 | Release: None | Updated: Jun 14, 2013 at 8:12 AM by perceiveit | Created: Apr 18, 2012 at 8:17 AM by perceiveit

  • 1-10 of 10 Work Items
    • Previous
    • 1
    • Next
    • Showing
    • 10
    • Work Items