[Firebird-net-provider] Wanted: Firebird-Programmer for Open Source project (app. 6 hours work)

[Philipp S. <no...@12...>]

Hello

I'm developing the .NET Data Access Object, an persistence framework 
that consists of

- a vendor-independent relational data access layer (comparable to JDBC)
- an object-relational mapping unit (container managed persistence)
- a Visual Studio .NET Add-in to map relational data to objects (mapping 
data is stored in XML files, no code generation needed)


To access specific databases, so called Data Access Objects are being 
used which implement a set of template methods of a common abstract base 
class, e.g.


//MySql Data Access Object
public override IDbConnection GetConnection()
{
   return new MySqlConnection();
}



Using the framwork is pretty easy. A container is used through it's 
interface while the container uses a Data Access Object through the 
abstract base class. The container does not now the currently used DBMS 
and your application does not know the container:

//store current instance
IPersistableObjectHandler container = GlobalConfig.Container;
container.CreatePersistable(this);




The process of creating a new DAO is pretty easy, but there are a few 
things to test as the framework supports transactions, output 
parameters, sequences etc.

The whole solution comes along with a very simple sample application 
(PigFarm) that accesses 3 tables on a database (Farm, Pig, Fruit). 
Depending on the used container (there are currently 2 container 
implementations), the database is being accessed via Stored Procedures 
or SQL (stored externally in XML files).

I'm looking for a Firebird programmer who will create and test a new DAO 
for the current Firebird release. Furthermore, the PigFarm database 
should be ported to Firebird including sequences and Stored Procedures. 
To make this a painless job, I can provide you with DDL and the current 
DAO-implementation for Oracle. I guess the whole thing will not take 
more than 6 hours - the DAO itself will be implemented in a few minutes.


You may want to have a look at the project site that also contains the 
contact address:
http://dao.sourceforge.net


The currently available release on SourceForge is 1.3.1 but I will 
provide you with the RC for 1.4 which contains many enhancements 
regarding database compatibility (sequence support, improved mapping 
abilities and ID handling). If you're interested in implementing the 
DAO, please contact me.

Thanks for your support

Philipp