Problem using SQLite :memory: with NHibernate

by

A SQLite memory database only exists as long as the connection to it remains open. To use it in unit tests with NHibernate:
1. Open an ISession at the beginning of your test (maybe in a [SetUp] method).
2. Use the connection from that session in your SchemaExport call.
3. Use that same session in your tests.
4. Close the session at the end of your test (maybe in a [TearDown] method).

More Related Contents:

  1. Minimal and correct way to map one-to-many with NHibernate
  2. Should I transform Entity (Persistent) objects to DTO objects?
  3. How to implement batch fetching with Fluent NHibernate when working with Oracle?
  4. Conversion of a datetime2 data type to a datetime data type results out-of-range value
  5. Query on HasMany reference
  6. Unable to load DLL ‘SQLite.Interop.dll’
  7. Generic Repository or Specific Repository for each entity?
  8. Password Protect a SQLite DB. Is it possible?
  9. Is there a .NET/C# wrapper for SQLite? [closed]
  10. NHibernate AliasToBean transformer associations
  11. SQLite Insert very slow?
  12. Create SQLite Database and table
  13. auto create database in Entity Framework Core
  14. Identifying NHibernate proxy classes
  15. NHibernate How do I query against an IList property?
  16. How to tell Fluent NHibernate not to map a class property
  17. What is the best way to connect and use a sqlite database from C#
  18. Polymorphism: Is ORM entity a Domain Entity or Data Entity?
  19. How does TransactionScope roll back transactions?
  20. Create/Use User-defined functions in System.Data.SQLite?
  21. SQLite keeps the database locked even after the connection is closed
  22. Entity Framework | Sequence contains more than one matching element
  23. Enabling Foreign key constraints in SQLite
  24. Options for using System.Data.SQLite in a 32bit and 64bit C# world
  25. Unable to find the requested .Net Framework Data Provider – SQLite
  26. NHibernate.MappingException: No persister for: XYZ
  27. How should I set up my integration tests to use a test database with Entity Framework?
  28. How does the SQLite Entity Framework 6 provider handle Guids?
  29. SHA1 hashing in SQLite: how?
  30. Best way to convert IList or IEnumerable to Array

Leave a Comment