SharpHsql new version 1.0.2.5
For the people that reads this and doesn't know what SharpHsql is, here comes the short explanation: it's a port to .NET (C#) of the well know embebdded Java database engine known as HSQLDB. This port includes an ADO.NET provider with full capabilities and Windows CE / PocketPC version.
Well, in this version I have almost put inside-out every class in the project. All classes, methods, variables, etc are now using the MS recommended naming conventions. No more Java like classes and methods.
Also I have made a huge refactor of all classes and added some features:
- Added support for variables:
DECLARE @MyVar INT; SET @MyVar = 25; SELECT @MyVar; - Added support for OUTPUT parameters in SharpHsqlCommand
(only for ExecuteNonQuery by now). - Identity columns starts it's value on 1, not zero.
- Creation of tables now defaults to CACHED if not specified.
- Date/Time is now stored correctly (with milliseconds).
- Fixed all other reported bugs (and some more).
- Changed visibility of almost everything.
- Changed those getXXX and setXXX methods to properties.
- Constants variables were changed to enums.
- Implemented IDisposable where previously existed a "finalize" method.
- Changed the name of some methods & properties to something more meaningful.
- All classes marked as Sealed when inheritance is not needed/desired.
- Added some more logging.
- Added every XML comment to all public classes, enums, etc.
- Generated a help file with NDoc.
- Run FxCop. Only 256 violations are left (some more work to do).
And some more.... well, this is a very nice release if you let me say it.
You can download the source and binaries from GotDotNet.
Please play with the bits and let me know what you think!
I need some collaboration for documentation and UNIT TESTING. Anybody care to port the HSQLDB tests?
That's all for now, best regards.
Andrés G Vettori
MCSE/MCSD/MCT
Leader of the C# Community of the Microsoft Users Group Argentina