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
|
