NHibernate VistaDB Driver and Dialect

New Post: Progress?

intesoft — Mon, 07 Sep 2009 03:08:45 GMT

I'm just about to start work updating this for the latest NHibernate 2.1 and the new VistaDB 4.0

NEW POST: Could not instantiate dialect class NHibernate.Dialect.VistaDBDialect

dannyyy — Mon, 05 May 2008 11:00:18 GMT

I've solved my problem.

The right appconfig.xml content for VistaDB looks like the following rows...

<config>
<add
key="hibernate.dialect"
value="NHibernate.Dialect.VistaDBDialect,NHibernate.VistaDBDriver"
/>
<add
key="hibernate.connection.driver_class"
value="NHibernate.Driver.VistaDBDriver,NHibernate.VistaDBDriver"
/>
<add
key="hibernate.connection.connection_string"
value="Data Source=C:\test.vdb3;Open Mode=NonExclusiveReadWrite"
/>
</config>

NEW POST: Could not instantiate dialect class NHibernate.Dialect.VistaDBDialect

dannyyy — Sun, 04 May 2008 13:48:20 GMT

Hello,

I wanna use ActiveRecord with VistaDB. I've seen there is no official driver or dialect for VistaDB.
Therefore I tried this one from CodePlex. But every time I get this NHibernate-Exception: Could not instantiate dialect class NHibernate.Dialect.VistaDBDialect

I've built the assambly from the source. After I've added the NHibernate.VistaDBDriver to my project and linked it in my appconfig.xml

<?xml version="1.0" encoding="utf-8" ?>

<activerecord>

<config>
<add
key="hibernate.connection.driver_class"
value="NHibernate.Driver.VistaDBDriver" />
<add
key="hibernate.dialect"
value="NHibernate.Dialect.VistaDBDialect" />
<add
key="hibernate.connection.provider"
value="NHibernate.Connection.DriverConnectionProvider" />
<add
key="hibernate.connection.connection_string"
value="Data Source=data/AccountingManager.vdb3" />
</config>

</activerecord>

What I did wrong? Can anyone send me a working project including all the assemblys and sources?

Thank you in advance.
Kindly regards,
Danny

NEW POST: Progress?

andrewh — Thu, 27 Mar 2008 07:09:41 GMT

I'm not the coordinator for this project, but ...

Based on the unit tests passed, its pretty close to a feature-complete (if not tuned & optimized) release.

Based on a quick look, this would be usable in many projects now, in a typical hibernate usage ... but this is just based on a quick look.

I cant speak for the coordinator of this project, but I'm planning on using this later in the year for one of our projects, and intend to at least try to polish off the rest of the unit test coverage. If VistaDB works out well for us, then we'll be involved for quite a while, and will almost certainly be involved.

This will also need continued updating to port the code to newer versions of NHibernate as they are released.

I wouldnt give up on this project yet ... I think we're just starting to see a real surge in the use of things like Spring.NET and NHibernate in new .net projects. And VistaDB occupies a fairly unique and compelling position between Jet/SQLite/etc and SQLServer2005/MySQL/Oracle/etc. That'll make projects like this quite interesting.

NEW POST: Progress?

stuartc — Tue, 11 Mar 2008 20:58:10 GMT

I have been watching this project for some time now hoping for a follow up release. A vistadb driver would be perfect for automated unit testing, any further dev planned?
What kind of effort do you think is required to get this project moving and can I help?

UPDATED RELEASE: Alpha (Dec 05, 2007)

Wed, 05 Dec 2007 20:30:20 GMT

Initial release of NHibernate Driver and Dialect to support VistaDB embedded database with the leading OR/M for .NET.

Note that this release sucessfully executes 91% of the NHibernate test suite (897 Tests, 35 Failures, 49 Errors) and future release will attempt to improve that but it does work as long as you are not making use of the functionality that currently fails.

UPDATED RELEASE: Alpha (Dec 05, 2007)

Wed, 05 Dec 2007 20:29:21 GMT

Initial release of NHibernate Driver and Dialect to supporty VistaDB embedded database.

Note that this release sucessfully executes 91% of the NHibernate test suite (897 Tests, 35 Failures, 49 Errors) and future release will attempt to improve that but it does work as long as you are not making use of the functionality that currently fails.

UPDATED RELEASE: Alpha (Dec 05, 2007)

Wed, 05 Dec 2007 20:21:21 GMT

Initial release.

NHibernate Test Suite:

897 Tests
35 Failures
49 Errors

UPDATED RELEASE: Alpha (Dec 05, 2007)

Wed, 05 Dec 2007 20:20:40 GMT

Initial release.

NHibernate Test Suite:

897 Tests
35 Failures
49 Errors

UPDATED RELEASE: Alpha (Dec 05, 2007)

Wed, 05 Dec 2007 20:19:24 GMT

Initial release.

NHibernate Test Suite:

897 Tests
35 Failures
49 Errors

UPDATED WIKI: Home

intesoft — Wed, 05 Dec 2007 20:18:34 GMT

About NHibernate

NHibernate is a port of Hibernate Core for Java to the .NET Framework. It handles persisting plain .NET objects to and from an underlying relational database. Given an XML description of your entities and relationships, NHibernate automatically generates SQL for loading and storing the objects. Optionally, you can describe your mapping metadata with attributes in your source code.

NHibernate supports transparent persistence, your object classes don't have to follow a restrictive programming model. Persistent classes do not need to implement any interface or inherit from a special base class. This makes it possible to design the business logic using plain .NET (CLR) objects and object-oriented idiom.

See: http://www.hibernate.org/343.html

About VistaDB

VistaDB 3.2 is the world's first fully managed and typesafe embedded SQL database engine built for Microsoft .NET, Compact Framework and Mono. VistaDB is the lightweight alternative to SQL Server 2005. No need to install complex services with your application, xcopy deployment makes shipping VistaDB with your app simple!

Developers can build embedded cross-platform ASP.NET and WinForms database applications for desktops, mobile devices and web servers using VB.NET, C# or any other Dot Net enabled language.

Fully managed embedded SQL database for .NET
Small < 1 MB footprint truly embedded ZeroClick™
More deployment options - Want to run from a DVDROM or other read only media? Our engine will let you burn the engine, database and your app and run from CD/DVD ROM. Imagine the ability to query your data from a backup without having to restore it first.
C# architecture built for .NET
Microsoft SQL Server 2005 compatible data types and T-SQL syntax
Visual Studio 2005 /2008 integration using Server Explorer
None of the SQL CE limits
Fully managed ADO.NET 2 provider or Direct Data Access (DDA)
Single user, multi user local or using shared network, and in memory database support. Partially trusted shared hosting is no problem.
SQL Views, CLR Procs, CLR Triggers, 64 bit native runtime support and other features not found in any other desktop database (including SQL CE!)
Royalty-free distribution - single CPU deployment of SQL Server costs more than a site license of VistaDB!
Nothing to install on users machines! No complex setup process required. XCopy our DLL with your application and you are done. No admin rights, no registry changes, we can even run as guest!
TSQL Procs support is coming soon in Version 3.3. Subscribers get early access through the beta builds. Help us test the most heavily requested feature for our future.

See: http://www.vistadb.net/

UPDATED WIKI: Home

intesoft — Wed, 05 Dec 2007 18:23:51 GMT

About NHibernate

About VistaDB

Fully managed embedded SQL database for .NET
Small < 1 MB footprint truly embedded ZeroClick™
More deployment options - Want to run from a DVDROM or other read only media? Our engine will let you burn the engine, database and your app and run from CD/DVD ROM. Imagine the ability to query your data from a backup without having to restore it first.
C# architecture built for .NET
Microsoft SQL Server 2005 compatible data types and T-SQL syntax
Visual Studio 2005 /2008 integration using Server Explorer
None of the SQL CE limits
Fully managed ADO.NET 2 provider or Direct Data Access (DDA)
Single user, multi user local or using shared network, and in memory database support. Partially trusted shared hosting is no problem.
SQL Views, CLR Procs, CLR Triggers, 64 bit native runtime support and other features not found in any other desktop database (including SQL CE!)
Royalty-free distribution - single CPU deployment of SQL Server costs more than a site license of VistaDB!
Nothing to install on users machines! No complex setup process required. XCopy our DLL with your application and you are done. No admin rights, no registry changes, we can even run as guest!
TSQL Procs support is coming soon in Version 3.3. Subscribers get early access through the beta builds. Help us test the most heavily requested feature for our future.

See: http://www.vistadb.net/

UPDATED WIKI: Home

intesoft — Wed, 05 Dec 2007 18:22:51 GMT

About NHibernate

About VistaDB

Fully managed embedded SQL database for .NET
Small < 1 MB footprint truly embedded ZeroClick™
More deployment options - Want to run from a DVDROM or other read only media? Our engine will let you burn the engine, database and your app and run from CD/DVD ROM. Imagine the ability to query your data from a backup without having to restore it first.
C# architecture built for .NET
Microsoft SQL Server 2005 compatible data types and T-SQL syntax
Visual Studio 2005 /2008 integration using Server Explorer
None of the SQL CE limits
Fully managed ADO.NET 2 provider or Direct Data Access (DDA)
Single user, multi user local or using shared network, and in memory database support. Partially trusted shared hosting is no problem.
SQL Views, CLR Procs, CLR Triggers, 64 bit native runtime support and other features not found in any other desktop database (including SQL CE!)
Royalty-free distribution - single CPU deployment of SQL Server costs more than a site license of VistaDB!
Nothing to install on users machines! No complex setup process required. XCopy our DLL with your application and you are done. No admin rights, no registry changes, we can even run as guest!
TSQL Procs support is coming soon in Version 3.3. Subscribers get early access through the beta builds. Help us test the most heavily requested feature for our future.

See: http://www.vistadb.net/

UPDATED WIKI: Home

intesoft — Wed, 05 Dec 2007 18:21:54 GMT

This project is intended to provide a driver and dialect to allow NHibernate to be used with VistaDB. This allows XCopy deployment of apps and development against a small, lightweight database which could be scaled up to SQL Server (or others) if required. It can also help when unit testing by creating an in-memory database on whatever machine the tests are running.

There are currently 0.91% of the NHibernate unit tests that fail (see attached NUnit report file) which I will work on to reduce.

Thew project contains the project and build files which should be placed in the NHibernate src folder for building (with the project added to the main NHibernate build file). The NHibernate.Test.dll.config file included shows the database connection strings used to run the tests after it has been built.

Note that the VistaDB engine assembly is a licensed component and will not be distributed with this project. This must be obtained from http://www.vistadb.net/http://www.vistadb.net//url directly.

!About NHIbernate

NHibernate is a port of Hibernate Core for Java to the .NET Framework. It handles persisting plain .NET objects to and from an underlying relational database. Given an XML description of your entities and relationships, NHibernate automatically generates SQL for loading and storing the objects. Optionally, you can describe your mapping metadata with attributes in your source code.

NHibernate supports transparent persistence, your object classes don't have to follow a restrictive programming model. Persistent classes do not need to implement any interface or inherit from a special base class. This makes it possible to design the business logic using plain .NET (CLR) objects and object-oriented idiom.

See: http://www.hibernate.org/343.htmlhttp://www.hibernate.org/343.html/url

!About VistaDB

VistaDB 3.2 is the world's first fully managed and typesafe embedded SQL database engine built for Microsoft .NET, Compact Framework and Mono. VistaDB is the lightweight alternative to SQL Server 2005. No need to install complex services with your application, xcopy deployment makes shipping VistaDB with your app simple!

Developers can build embedded cross-platform ASP.NET and WinForms database applications for desktops, mobile devices and web servers using VB.NET, C# or any other Dot Net enabled language.

Fully managed embedded SQL database for .NET
Small < 1 MB footprint truly embedded ZeroClick™
More deployment options - Want to run from a DVDROM or other read only media? Our engine will let you burn the engine, database and your app and run from CD/DVD ROM. Imagine the ability to query your data from a backup without having to restore it first.
C# architecture built for .NET
Microsoft SQL Server 2005 compatible data types and T-SQL syntax
Visual Studio 2005 /2008 integration using Server Explorer
None of the SQL CE limits
Fully managed ADO.NET 2 provider or Direct Data Access (DDA)
Single user, multi user local or using shared network, and in memory database support. Partially trusted shared hosting is no problem.
SQL Views, CLR Procs, CLR Triggers, 64 bit native runtime support and other features not found in any other desktop database (including SQL CE!)
Royalty-free distribution - single CPU deployment of SQL Server costs more than a site license of VistaDB!
Nothing to install on users machines! No complex setup process required. XCopy our DLL with your application and you are done. No admin rights, no registry changes, we can even run as guest!
TSQL Procs support is coming soon in Version 3.3. Subscribers get early access through the beta builds. Help us test the most heavily requested feature for our future.

See: http://www.vistadb.net/http://www.vistadb.net//url