Geek Answers Handbook

Using HSQL for .NET Development and Related Process Issues

My team uses a common Oracle instance for development using C #, NHibernate, and ASP.NET, and we step on each other from time to time when we make changes to the data or schema, supporting everyone.

In another project, I use Java and HSQL in 100% memory mode and just run a Hibernate script to import enough data for testing. It also creates and deletes the schema. I considered using the same approach in .NET-land. With everything temporary and independent, it would be impossible to step on each other, and we could integrate our schema and data into a common Oracle box.

I searched HSQL on .NET and SharpHSQL seems to be a dead project (latest version 2005).

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

How did you use this approach in a team environment? Any problems?

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

+7
c # process embedded-database hsqldb
source share
3 answers

See the HSQLDB.org website. Now there is a .NET implementation.

Edit: the implementation is for HSQLDB 1.8.0.x and is located in the SVN repository. Must be compiled for use.

+2
source share

With something like Sqlite, you can use the same approach in your .NET applications as your Java applications - creating a schema and populating test data with NHibernate / NHibernate export schema code is a good way to manage this script (NHibernate is great works with Sqlite). If you do, you can also standardize Sqlite with your Java applications.

+4
source share

Take a look at Effort

Basically, it is an ADO.NET provider that performs all these operations with a lightweight main memory database during operation instead of a traditional external database.

I used it in my last project and he really likes it. Easy setup.

0
source share

More articles:


All Articles