[Nhibernate-commit] SF.net SVN: nhibernate:[3757] trunk/nhibernate/src/NHibernate

[<aye...@us...>]

Revision: 3757
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=3757&view=rev
Author:   ayenderahien
Date:     2008-09-13 06:36:20 +0000 (Sat, 13 Sep 2008)

Log Message:
-----------
Fixing binary parameter lengths on SQL CE

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Dialect/MsSqlCeDialect.cs
    trunk/nhibernate/src/NHibernate.Test/NHibernate.Test-3.5.csproj

Added Paths:
-----------
    trunk/nhibernate/src/NHibernate.Test/DialectTest/SqlCEDialectFixture.cs

Modified: trunk/nhibernate/src/NHibernate/Dialect/MsSqlCeDialect.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Dialect/MsSqlCeDialect.cs	2008-09-13 06:35:33 UTC (rev 3756)
+++ trunk/nhibernate/src/NHibernate/Dialect/MsSqlCeDialect.cs	2008-09-13 06:36:20 UTC (rev 3757)
@@ -17,8 +17,8 @@
 			RegisterColumnType(DbType.AnsiString, "NVARCHAR(255)");
 			RegisterColumnType(DbType.AnsiString, 4000, "NVARCHAR");
 			RegisterColumnType(DbType.AnsiString, 1073741823, "NTEXT");
-			RegisterColumnType(DbType.Binary, "VARBINARY(4000)");
-			RegisterColumnType(DbType.Binary, 4000, "VARBINARY($l)");
+			RegisterColumnType(DbType.Binary, "VARBINARY(8000)");
+			RegisterColumnType(DbType.Binary, 8000, "VARBINARY($l)");
 			RegisterColumnType(DbType.Binary, 1073741823, "IMAGE");
 			RegisterColumnType(DbType.Boolean, "BIT");
 			RegisterColumnType(DbType.Byte, "TINYINT");

Added: trunk/nhibernate/src/NHibernate.Test/DialectTest/SqlCEDialectFixture.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/DialectTest/SqlCEDialectFixture.cs	                        (rev 0)
+++ trunk/nhibernate/src/NHibernate.Test/DialectTest/SqlCEDialectFixture.cs	2008-09-13 06:36:20 UTC (rev 3757)
@@ -0,0 +1,30 @@
+namespace NHibernate.Test.DialectTest
+{
+	using Dialect;
+	using Mapping;
+	using NUnit.Framework;
+
+	[TestFixture]
+	public class SqlCEDialectFixture
+	{
+		[Test]
+		public void BinaryBlob_mapping_to_SqlCe_types()
+		{
+			Dialect dialect = new MsSqlCeDialect();
+			SimpleValue sv = new SimpleValue();
+			sv.TypeName = NHibernateUtil.BinaryBlob.Name;
+			Column column = new Column();
+			column.Value = sv;
+
+			// no length, should produce maximum
+			Assert.AreEqual("VARBINARY(8000)", column.GetSqlType(dialect, null));
+
+			// maximum varbinary length is 8000
+			column.Length = 8000;
+			Assert.AreEqual("VARBINARY(8000)", column.GetSqlType(dialect,null));
+
+			column.Length = 8001;
+			Assert.AreEqual("IMAGE", column.GetSqlType(dialect, null));
+		}
+	}
+}
\ No newline at end of file

Modified: trunk/nhibernate/src/NHibernate.Test/NHibernate.Test-3.5.csproj
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/NHibernate.Test-3.5.csproj	2008-09-13 06:35:33 UTC (rev 3756)
+++ trunk/nhibernate/src/NHibernate.Test/NHibernate.Test-3.5.csproj	2008-09-13 06:36:20 UTC (rev 3757)
@@ -135,6 +135,7 @@
     <Compile Include="DialectTest\FirebirdDialectFixture.cs" />
     <Compile Include="DialectTest\MsSql2005DialectFixture.cs" />
     <Compile Include="DialectTest\MsSqlDialectFixture.cs" />
+    <Compile Include="DialectTest\SqlCEDialectFixture.cs" />
     <Compile Include="DialectTest\SQLiteDialectFixture.cs" />
     <Compile Include="DriverTest\NullReferenceFixture.cs" />
     <Compile Include="DriverTest\OracleClientDriverFixture.cs" />


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.