简单的商品管理系统（ASP.net MVC + Spring.NET + NHibernate）源码（含有数据库生成语句）

Build 3.3.1.GA ============================= ** Sub-task * [NH-3167] - Support for Microsoft Sql Server 2012 sequences * [NH-3170] - Add native "iif" function to MsSql2012Dialect ** Bug * [NH-2789] - LINQ query on byte? simple property fails on MSSQL 2005 (tinyint) * [NH-2812] - Performing a Linq query on a non-null byte property throws an InvalidCastException * [NH-3121] - Silent truncation of binary data * [NH-3124] - invalid cast to int in generated sql with a char property * [NH-3125] - Invalid SQL when querying via LINQ with grouping (regression from 3.2) * [NH-3126] - InvalidCastException when cascading saves to transient dictionary values * [NH-3138] - Distinct Bug on MSSQL with OrderBy/Limit and functions in Projection/Order * [NH-3142] - Batch-loading of lazy children failing when key is composite * [NH-3145] - HQL query using base class entity with lazy properties throws "No Persister For" error * [NH-3147] - Calling Contains on a subquery that contains a join throws an Exception * [NH-3153] - Duplicated id generator tables if schema is specified using different methods for different classes. * [NH-3162] - Byte.Equals in LINQ Where clauses throws NotSupportedException * [NH-3172] - "Duplicate dynamic module name within an assembly" ** Improvement * [NH-3104] - Typo in Warning Messages * [NH-3149] - MsSql2005Dialect should use nowait in LockMode.UPGRADE_NOWAIT * [NH-3156] - ShowBuildMenu.bat does not work with spaces in repository folder name * [NH-3168] - Add support for bit_length function for MsSql2000Dialect and above * [NH-3169] - Add supprot for extract function for MsSql2000Dialect and above Build 3.3.0.GA ============================= ** Known BREAKING CHANGES from NH3.2.0.GA to NH3.3.0.GA ##### Possible Breaking Changes ##### * [NH-2214] - SQL Server 2005/2008: Exception is now thrown when paging a statement that requires distinct results, and is ordered by a column that is not included in the result set of the query - Dialog.ExtractColumnOrAliasNames method signature and visibility changed - may affect custom dialects that use this method * [NH-2950] - IAccessCallback.NextValue property renamed and changed to a method called IAccessCallback.GetNextValue() * [NH-2953] - SequenceStyleGenerator now forces use of a table if a pooled optimizer is chosen and the dialect doesn't support pooled sequences. * [NH-2960] - Queries for an entity name will now not include instances of the same class mapped using a different entity name. * [NH-2664] - IHqlExpressionVisitor has new property ISessionFactory SessionFactory { get; } * [NH-3067] - The use of Substring() in Linq queries have been corrected so the zero-based index parameter in C# is converted to one-based index in SQL. * [NH-2528] - Throw exception instead of silently truncate string and blob data * [NH-3086] - The base dialect now defaults to ANSI syntax for substring. A custom dialect may need to adjust for this. ** Bug * [NH-2956] - SybaseSQLAnywhere10Dialect doesn't override OffsetStartsAtOne * [NH-3111] - Wrong SQL generated when subquery uses objects from parent query ** Improvement * [NH-3086] - All dialects should support substring() with two arguments Build 3.3.0.CR1 ============================= ** Bug * [NH-1477] - Saving a collection (thats been Cleared) with all-delete-orphan using Oracle with ODP drivers * [NH-2214] - Distinct and Row_number problem * [NH-2347] - Casts inside aggregate functions are incorrectly applied outside of them * [NH-2419] - Linq Provider Problem with group by with an order by clause * [NH-2429] - SQL Server Linq Average function on Interger field only returns truncated interger value * [NH-2439] - LINQ 'in' query not fully interpreted * [NH-2451] - LINQ Issue - joining twice with same table when used in both select and where. Second join is a full select and filtered in where instead of a join .. on * [NH-2452] - NH 3.0 Linq provider does not correctly translate standard .Key property when grouping * [NH-2492] - Problem with ROW_NUMBER and DISTINCT operator using LINQ * [NH-2511] - System.ArgumentException: Object of type 'System.Linq.Expressions.ConstantExpression' cannot be converted to type 'System.Linq.Expressions.LambdaExpression' when passing an expression through a method * [NH-2527] - AbstractBatcher reuses disposed IDbCommands which causes an ArgumentOutOfRangeException with OracleDataClientDriver * [NH-2560] - NoViableAltException with ordering by projection in GroupBy * [NH-2664] - Linq, cannot query dynamic-component * [NH-2706] - subselect in LINQ query with Contains clause produces wrong SQL * [NH-2722] - Linq Count() does not respect previous calls to Select() or Distinct() * [NH-2744] - NewArrayInit Is not Implemented * [NH-2763] - queryover fails where referencing enum in VB.NET * [NH-2781] - linq's OrderBy by a calculated column doesn't work * [NH-2809] - Incorrect specification of VARBINARY(MAX) in MsSql2005Dialect * [NH-2828] - Persist uploads not initialized collections on flush * [NH-2833] - "where" clause not working after "group by", generates wrong SQL * [NH-2846] - Fetch on Count Throws Error * [NH-2850] - Unable to use enums in NH 3.2 QueryOver checked comparison * [NH-2853] - SetFirstResult and SetMaxResults do not work correctly on Oracle (ODP.NET) * [NH-2856] - Retrieval of cached query with Fetch throws exception * [NH-2857] - Medium Trust Bug in 3.2 * [NH-2858] - ToString() on Guid column with SQL Server Dialects * [NH-2863] - Criteria API restriction over aggregate function wrapped in NotExpression is wrongly placed in WHERE clause instead of HAVING clause which generates invalid SQL * [NH-2869] - Custom extension methods in the select clause are not projected using HQL * [NH-2880] - Proxies loose their session reference on session deserialization * [NH-2881] - Fix not found key handling on extra lazy one to many maps * [NH-2886] - Informix support broken * [NH-2889] - QueryOver component with multiple properties results in Sql Error * [NH-2891] - Too many parameters removed (Pervasive SQL) - SELECT doesn't work * [NH-2893] - NHibernate SQL Parameter on IBM.Data.DB2.iSeries provider * [NH-2904] - Wrong query generation with LINQ subquery * [NH-2906] - Using the same parameter name for two differently typed where clauses throws an exception * [NH-2913] - LINQ query that contains .Any() produces invalid SQL * [NH-2917] - Paging error with Skip().Take(). * [NH-2925] - Improper SQL is generated for Take (pagination) for dialects which have UseMaxForLimit = true (like Oracle) * [NH-2927] - Oracle Dialect does not handle the correct resolution for timestamp version columns * [NH-2937] - Invalid index 0 for this DB2ParameterCollection with Count=0. * [NH-2940] - OracleDialect creates wrong sql using SetFirstResult with criteria queries * [NH-2946] - Superfluous join when querying by foreign key given Id with LINQ * [NH-2954] - PostgreSQL should SupportsPooledSequences * [NH-2959] - Polymorphic queries in MultiQuery, MultiCriteria and Futures cause ArgumentOutOfRangeException * [NH-2960] - Query using entity name also returns entities of same type but different entity name * [NH-2967] - MySQL Schema Update tool fails with exception * [NH-2976] - AbstractPersistentCollection.Remove does not remove item from an uninitialized dictionary * [NH-2989] - ComponentAsId does not set Id Property * [NH-2998] - Allow to use AsQueryable on child collection * [NH-3000] - QuerySyntaxException: Exception of type 'Antlr.Runtime.NoViableAltEx