I'm expecting slow performance problems with my data layer tests - Database Testing: How to Regression Test a Relational Database
People often use an In-Memory Database
to speed up regression tests.
Java people often use Hibernate+HSQL combination: Testing with an in-memory Database
, Unit-Testing Hibernate With HSQLDB
Someone like H2
, because it has "Compatibility modes for IBM DB2, Apache Derby, HSQLDB, MS SQL Server, MySQL, Oracle, and PostgreSQL." - H2 VS HSQLDB
Well, it is always interesting to read news from java world...
What could we get here in a meagre .NET world?
And how could you help us with TOA?
Can you include an in-Memeory database into the TOA supporting list?
Or maybe it would be simpler to develop your own "in-Memeory database" ?
It could be a big DataSet with DataTables mapped to the classes with the schema.
We will not get a full SQL support, but we could prepare data in tables and check it there.
This looks as quite enough. (At least for my issues)
What do you think?