Name | Modified | Size | Downloads / Week |
---|---|---|---|
Parent folder | |||
Readme.txt | 2013-09-08 | 2.1 kB | |
Typed Query v0.9.6.zip | 2013-09-08 | 884.3 kB | |
Totals: 2 Items | 886.3 kB | 0 |
0.91 Changes Added truncate query Force transaction on thread More parameters on query performed event Refactored query interface classes Implemented ExecuteReturnGeneratedKeys() on insert query for sql server Definition checker working for postgreSql IQueryResult is now called IResult 0.92 Changes Added database class code generator Added JoinIf, LeftJoinIf and RightJoinIf query syntax Fixed default value issue on new rows Table generator now includes schema name in code 0.93 Changes Added Float, NFloat, Double and NDouble columns Added table generator support for DateTime2 and DateTimeOffset fields Bug fix - Cast exception on BigIntSum and BigIntAvg running on PostgreSql Added include schema option to table generator Added % (Mod) operator to some fields Added Query Executing event that fires when a query first begins Fixed issue where Left Joins threw an exception 0.94 Changes Added new stored procedure support Added RETURNING syntax to insert, update and delete queries Added DateTimeOffset column support Added aggregate date functions for - Year, Month, DayOfMonth, Hour, Minute, Second 0.95 Added window function syntax support including new Row_Number(), Rank() and Dense_Rank() functions Removed ExecuteReturnGeneratedKeys(...) Syntax. Noew replaced by Returning(...) syntax. 0.96 Added read only connection security feature so that select queries that run outside of a trasaction are run in a read only query if the database class implements this feature. See documentation. Changed QueryExecuting and QueryPerformed events to pass the database class being used in the executing query. Added Key Column Support Added support for table and column comments Added static And(...) and Or(...) methods to Condition class Fixed a number of issues with the table definition generator. Fixed bug where calling Update(...) on a row more than once causes an exception. Fixed row update rules to stop rows getting into an invalid state after roll backs and multiple updates within a single transaction.