[nhibernate-issues] [JIRA] Commented: (NH-668) Support Sqlite ADO.Net 2.0 DataProvider

[NHibernate J. <mik...@us...>]

     [ http://jira.nhibernate.org/browse/NH-668?page=comments#action_14670 ]
     
Bertrand LEGA commented on NH-668:
----------------------------------

As you may have heard "SQLite ADO.Net Provider" the initial project providing an ADO.NET driver for Sqlite is discontinued.

Instead, a new project sqlite-dotnet2 have started and keep providing nice ADO.NET driver.

As of today, Nhibernate only provides built-in support for the "SQLite ADO.Net Provider" driver which does not support Sqlite 3 ! Hopefully, "sqlite-dotnet2" does.

The first patch seems to be Nhibernate 1.2 specific and doesn't work for 1.03. So I changed the original code (written by Ioan Bizau).

In the zip, you will find : 
  - the visual studio 2005/2003 project
  - the code (yeah)
  - debug and release dlls for .net 2.0 and .net 1.1

I've tested it with the following feature 
   - autoincrement
   - BOOLEAN and DATE fields.

For more information, see http://forum.hibernate.org/viewtopic.php?p=2335245#2335245
Bye,
Bertrand.

> Support Sqlite ADO.Net 2.0 DataProvider
> ---------------------------------------
>
>          Key: NH-668
>          URL: http://jira.nhibernate.org/browse/NH-668
>      Project: NHibernate
>         Type: Patch
>   Components: Data Providers
>     Versions: 1.2.0.Beta1
>     Reporter: Steve Wagner
>     Priority: Trivial
>      Fix For: 1.2.0.Beta1
>  Attachments: sqlite_driver_patch.patch
>
> NHibernate ist compiled against the old version of the SQLite ADO.Net Provider. But this Provider isnt updated since Feb. 2005.
> The newer one only supports Ado.Net 2.0. You can find it on http://sourceforge.net/projects/sqlite-dotnet2 . 
> Enclosed a SVN Patch that uses the Ado.Net 2.0 Version if NHibernate isn't compiled with .Net 1.0 1.1 or Mono 1.0.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira