I'd rather play golf

Yesterday the first release candidate of NHibernate 3.3.0 was made available; you can find it here on sourceforge.net. In addition to the numerous bug fixes for NHibernate’s LINQ support, of interest to SQL Anywhere users will be some bug fixes and changes for SQL Anywhere 12.0.1 that I have described previously in this forum. These [...]

[Read more →]

The 3.2.0 GA release of the NHibernate object-relational mapping toolkit was recently released on July 30. Thanks to the efforts of Julian Maughan, the base NHibernate distribution contains two SQL Anywhere dialects, named SybaseSQLAnywhere10Dialect.cs and SybaseSQLAnywhere11Dialect.cs, that can be used largely unaltered with SQL Anywhere versions 10 and 11. However, some SQL Anywhere software configuration [...]

[Read more →]

Julian Maughan of the NHibernate project and I have recently been conversing through email about the state of the NHibernate dialects for Sybase products, including SQL Anywhere. This morning Julian posted an article on the NHibernate Development Google Group. It’s a request for feedback on a proposal to eliminate the existing SQL Anywhere NHibernate dialects [...]

[Read more →]

In case you missed it, NHibernate 3.0.0 (alpha) was announced in late July, and both binaries and source code for the new release is now available on sourceforge.net. With the 3.0.0 release, NHibernate includes support for LINQ, along with additional features such as: Along with a long list of bug fixes and improvements, it has [...]

[Read more →]

As documented in this NHibernate-Development Google Groups thread, reader Brian Weeres discovered a problem when using the SQLAnywhere11Dialect with a NHibernate 2.1.2 Criteria API query that performs pagination. The problem exists in the NHibernate 2.1.0 GA release. To illustrate the problem, here’s a modified version of the LoadEmployeesFromDatabase() function from the HelloNHibernate sample, in module [...]

[Read more →]

You can find an NHibernate dialect customized for the Sybase SQL Anywhere 12 server (currently in beta) here. This new SQLAnywhere12Dialect offers support for: The TIMESTAMP WITH TIME ZONE data type (also known as the DATETIMEOFFSET data type); and SEQUENCE values using the new SEQUENCE support in the SQL Anywhere 12 server. SQL Anywhere 12 [...]

[Read more →]

On 15 December I presented a webinar entitled “Object-relational Mappers: Friend or foe?”. A flash recording of this webcast is available here. After entering your contact information, you’ll be automatically redirected to another page and the flash recording will begin immediately.

[Read more →]

On Tuesday, 15 December 2009 I’ll be presenting a one-hour webinar entitled “Object-relational Mappers: Friend or foe?”: Object relational mappers (ORMs) such as LINQ, Hibernate, and ActiveRecord bridge the gap between the relational database world, and the object-oriented world. By abstracting the database into “virtual database objects”, they let programmers develop in any language and [...]

[Read more →]

In July I posted a new NHibernate dialect for SQL Anywhere versions 10 and up, which was based on the then-existing NHibernate 2.0.1GA distribution. This week I’ve modified the dialect slightly and compiled and tested it with the latest NHibernate 2.1.0GA distribution; you can download the new dialect source code and NHibernate.DLL libraries here. In [...]

[Read more →]

At June’s 2009 ACM SIGMOD Conference, Surajit Chaudhuri of Microsoft Research presented a thought-provoking paper [1] entitled “Query Optimizers: Time to Rethink the Contract?”. Here is the abstract: Query Optimization is expected to produce good execution plans for complex queries while taking relatively small optimization time. Moreover, it is expected to pick the execution plans [...]

[Read more →]