Data Broker is a Data Access Layer and ORM framework. It is small, easy to use and implements various fault tolerant features. It requires no XML configuration for defining the object relational mapping, just some simple attributes in the data access classes. Developed in C#.Data BrokerWorks based solely on DAO classesGenerates SQL on the flyImplements best practices such as parameterized queriesOptimizes updates by caching original valuesAllows both flat and hierarchical result setsAllows for calling stored proceduresIs thread safeHas connection recovery - it will restore connection and re-send commandsHas support for deadlock recoveryCan be used in any type of project: WinForms, ASP.NET, Services, Console applications
Databases supported: SQL Server, Oracle, Informix, Firebird. Currently Data Broker has a slant towards SQL Server because it has been the most used database where Data Broker is used; feedback on the other databases is appreciated. The objective is to allow the same client code to be used seamlessly from database to database.
The documentation is still in development, but you are going to find samples of usage in the test source code.This framework is currently being used in mission critical systems, so it should be pretty stable. It is labelled as Beta because we want to get as much feedback as possible from the general public before solidifying its interfaces. We welcome constructive criticism and questions, please let us know if help is needed and we will respond as soon as time permits.
1. Configuration1.1 Simple1.2 Adding log4net logging
2.1 Defining a DAO
2.2 Simple queries