nhibernate-commit

[Michael D. <mik...@us...>]

Update of /cvsroot/nhibernate/nhibernate/src/NHibernate/Dialect
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26944/Dialect

Added Files:
	SQLiteDialect.cs 
Log Message:
NH161 - addition of SQLite driver and dialect.

--- NEW FILE: SQLiteDialect.cs ---
using System;
using System.Data;

namespace NHibernate.Dialect
{
	/// <summary>
	/// A SQL dialect for SQLite.
	/// </summary>
	/// <remarks>
	/// <p>
	/// Author: <a href="mailto:ib...@st..."> Ioan Bizau </a>
	/// </p>
	/// </remarks>
	public class SQLiteDialect : Dialect
	{
		public SQLiteDialect()
		{
			Register(DbType.Binary, "BLOB");
			Register(DbType.Byte, "INTEGER");
			Register(DbType.Int16, "INTEGER");
			Register(DbType.Int32, "INTEGER");
			Register(DbType.Int64, "INTEGER");
			Register(DbType.SByte, "INTEGER");
			Register(DbType.UInt16, "INTEGER");
			Register(DbType.UInt32, "INTEGER");
			Register(DbType.UInt64, "INTEGER");
			Register(DbType.Currency, "NUMERIC");
			Register(DbType.Decimal, "NUMERIC");
			Register(DbType.Double, "NUMERIC");
			Register(DbType.Single, "NUMERIC");
			Register(DbType.VarNumeric, "NUMERIC");
			Register(DbType.String, "TEXT");
		}

		public override string IdentitySelectString
		{
			get { return "select last_insert_rowid()"; }
		}
	}
}