The UI tools I have used definitely don't use the ado.net provider or NHibernate. However, the conversion tool that created the SQLite database (http://http://www.codeproject.com/Articles/26932/Convert-SQL-Server-DB-to-SQLite-DB) definitely does use the ADO.NET provider, and it managed to create the database very quickly. It is less than 3Mb - ie not a very large data set at all.
What surprises me is that there is a LOT of chatter on the web about using SQLite with NHibernate for unit testing, and this implies that it may actually be faster than SQLServer or MySQL (especially when used with :memory: databases) I wondered whether it may be a permissions issue because I had not given write permissions for the IIS_WPG group to the SQLite database, but this does not appear to have made any difference either (though this may have prevented me from writing to the database if I ever get that far!) -- You received this message because you are subscribed to the Google Groups "nhusers" group. To view this discussion on the web visit https://groups.google.com/d/msg/nhusers/-/Z_a0PmM7JOoJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
