EffiProz: A Cross-Platform Embedded Database for .NET Programmers

| by Jonathan Allen Follow 576 Followers on Aug 23, 2010. Estimated reading time: 1 minute |

EffiProz is an embedded database written entirely in C# that can has both a disk-based and a memory-only mode. This has allowed its developers to port it to most environments that have CLR including .NET Compact, Mono, Windows 7, and Silverlight. The next version will extend this to mobile platforms.

When we asked Irantha Suwandarathna of EffiProz why we should use it instead of SQL Server Compact or SQLite he responded,

If someone is interested in features,

  • Extreme Performance
  • ACID compliant transactions
  • Full blown standard compliant SQL support (More than what is supported by SQLite or SQLCE)
  • Fully Managed code database engine
  • Want the same database to work on .NET, Compact Framework, Silverlight, Mono, Windows Phone, Moonlight, ( in Future on Android and iPhone) applications (or Migrating database files between these platforms) (With basic HSQL compatibly you will be able to use the same database files even between .NET and JAVA applications interchangeably.)

In addition EffiProz supports Entity Framework and will have MonoTouch in the next version (1.3). Support for MonoDroid is planned for some time after that is released.

Since the quality of an application is largely dependent on the quality of the components it is built from, we made sure to ask about their testing and quality assurance procedures.

We have a regression test suite with over 10,000 Lines Of Code. In our current 1.2 release we have achieve about 74% code coverage. For 1.3 release bar is set for 80% coverage. We repeat the test suite for each of our storage layers. Again we rerun those test cases 2 times: once to test Transaction Log recovery and then to test Regular Shutdown. In addition to this automated regression test suite we also do extensive manual testing as well.

HSQLDB, an open source Java datatabase, formed the basis of this product.

EffiProz is started as a translation of HSQLDB to .NET framework. But EffiProz has now incorporated many more features that are not present in HSQLDB (for example SQL Server compatible UniqueIdentifier Data Type). HSQLDB is Licensed under a liberal BSD style license. EffiProz is free for none commercial use (Academic, Research, etc.). You are required to purchase a License for a commercial use.

Rate this Article

Adoption Stage

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread


Login to InfoQ to interact with what matters most to you.

Recover your password...


Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.


More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.


Stay up-to-date

Set up your notifications and don't miss out on content that matters to you