Using HSQL for .NET development and related questions of process

Question

My team uses a shared instance of Oracle for development using C#, NHibernate and ASP.NET, and we occasionally step on each others toes when making data or schema changes holding up everyone.

On another project I'm using Java and HSQL in 100% in-memory mode and just have Hibernate launch a script to import enough data to test with. It also creates and drops the schema. I considered using the same approach in .NET-land. With everything temporary and independent it would be impossible to step on each others toes, and we could still integrate our schema and data on the shared Oracle box.

I looked for HSQL on .NET and SharpHSQL seems to be a dead project (last release 2005).

Is there an active project equivalent to HSQL for .NET, or anything close enough to be used this way?

How have you got on using this approach in a team environment? Any issues?

How do you manage and version control data for populating the database? Is there a cross-platform solution for importing data?

Geraldo

Answer 1

See the HSQLDB.org web site. There is now a .NET implementation.

Edit: The implementation is for HSQLDB 1.8.0.x and is in the SVN repository. Needs to be compiled for use.

Eskisehir

I couldn't find the .net implementation on the web site. Could any one point me in the direction please? – Vintager

Answer 2

With something like Sqlite, you could take the same approach in your .NET applications as with your Java applications - creating the schema and populating test data via NHibernate schema export / NHibernate population code is a good way to manage this scenario (NHibernate works fine with Sqlite). If you chose to, you could potentially standardise on Sqlite with your Java applications too.

Plasty

+1 I use Sqlite for testing and development at my job from Java and have used it from an ASP.NET environment as well. Works great. – Luncheonette

Answer 3

Take a look at Effort

It is basically an ADO.NET provider that executes all the data operations on a lightweight in-process main memory database instead of a traditional external database.

I used it in my latest project and really like it. Easy to set up.

Coenzyme