Creating .In and .NotIn extension methods for NHibernate 3 Linq provider

In Bringing the IN clause from SQL to C# I have shown how to create extension methods for C# that mimic the “in” clause from SQL. I like these methods a lot, but they cannot be used in Linq to NHibernate queries, because it cannot interpret them by default. Luckily, it’s not that hard to … More Creating .In and .NotIn extension methods for NHibernate 3 Linq provider

Oracle Forms

Last weeks I had a project in university I had to create using Oracle Forms. It should have been simple, so I chose to create cinema ticket booking application with just 5 database tables and a few forms. University’s using Oracle 10g R2 for their databases, so I downloaded the appropriate package that includes Forms … More Oracle Forms

Firebird Stored Procedure parameters order: implementing in the DAL

So the fun continues. In my previous post I wrote that Firebird Stored Procedure (SP) parameters must be passed in the correct order, as they’re defined in the procedure itself. However, the example I gave with a class that uses attributes to map class properties to SP parameters was not quite complete. As I started … More Firebird Stored Procedure parameters order: implementing in the DAL