[Nhibernate-commit] SF.net SVN: nhibernate:[5515] trunk/nhibernate/src/NHibernate/Dialect/ SQLiteDialect.cs

[<pa...@us...>]

Revision: 5515
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5515&view=rev
Author:   patearl
Date:     2011-03-24 02:50:00 +0000 (Thu, 24 Mar 2011)

Log Message:
-----------
Improved SQLite type mapping to match the System.Data.SQLite provider, which is by far the dominant provider.

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Dialect/SQLiteDialect.cs

Modified: trunk/nhibernate/src/NHibernate/Dialect/SQLiteDialect.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Dialect/SQLiteDialect.cs	2011-03-23 21:48:51 UTC (rev 5514)
+++ trunk/nhibernate/src/NHibernate/Dialect/SQLiteDialect.cs	2011-03-24 02:50:00 UTC (rev 5515)
@@ -24,28 +24,28 @@
 		public SQLiteDialect()
 		{
 			RegisterColumnType(DbType.Binary, "BLOB");
-			RegisterColumnType(DbType.Byte, "INTEGER");
-			RegisterColumnType(DbType.Int16, "INTEGER");
-			RegisterColumnType(DbType.Int32, "INTEGER");
-			RegisterColumnType(DbType.Int64, "INTEGER");
+            RegisterColumnType(DbType.Byte, "TINYINT");
+            RegisterColumnType(DbType.Int16, "SMALLINT");
+			RegisterColumnType(DbType.Int32, "INT");
+			RegisterColumnType(DbType.Int64, "BIGINT");
 			RegisterColumnType(DbType.SByte, "INTEGER");
 			RegisterColumnType(DbType.UInt16, "INTEGER");
 			RegisterColumnType(DbType.UInt32, "INTEGER");
 			RegisterColumnType(DbType.UInt64, "INTEGER");
 			RegisterColumnType(DbType.Currency, "NUMERIC");
 			RegisterColumnType(DbType.Decimal, "NUMERIC");
-			RegisterColumnType(DbType.Double, "NUMERIC");
-			RegisterColumnType(DbType.Single, "NUMERIC");
+			RegisterColumnType(DbType.Double, "DOUBLE");
+			RegisterColumnType(DbType.Single, "DOUBLE");
 			RegisterColumnType(DbType.VarNumeric, "NUMERIC");
 			RegisterColumnType(DbType.AnsiString, "TEXT");
 			RegisterColumnType(DbType.String, "TEXT");
 			RegisterColumnType(DbType.AnsiStringFixedLength, "TEXT");
 			RegisterColumnType(DbType.StringFixedLength, "TEXT");
 
-			RegisterColumnType(DbType.Date, "DATETIME"); 
+			RegisterColumnType(DbType.Date, "DATE"); 
 			RegisterColumnType(DbType.DateTime, "DATETIME");
-			RegisterColumnType(DbType.Time, "DATETIME");
-			RegisterColumnType(DbType.Boolean, "INTEGER");
+			RegisterColumnType(DbType.Time, "TIME");
+			RegisterColumnType(DbType.Boolean, "BOOL");
 			RegisterColumnType(DbType.Guid, "UNIQUEIDENTIFIER");
 
             // Using strftime returns 0-padded strings.  '07' <> 7, so it is better to convert to an integer.


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