Tdo -Typed Data Object 2.0
By Andrea Ferendeles

Tdo is the acronym of Typed Data Object and is made up of a NET assembly (Tdo.dll) and a source code generator (TdoCodeGenerator.exe). The source code generator produces a collection of derived classes (VB.NET/C#.NET) that extends the base classes within the Tdo.dll assembly, all under the Object Oriented model. Every generated class has the scope "to represent" an object of your SQL database, where object are Tables, Views, Stored Procedures, Functions. According to this model, every table or view, etc, is considered as an object itself that shows its attributes and operations (that are properties and methods). That means that the single cell of a table or the single parameter of a stored procedure will be seen as object itself. All these classes are enclosed in a hierarchically macro-object as a representation of the entire database - the TdoHelper class. More ahead we'll see all the possible operations that we can execute on our database (select, insert, update, delete, stored procedure, etc) that will be called from the present methods within the TdoHelper class objects.

Tdo Is Open Source

From this version (2.0), Tdo has become an open source project and both the source code and the setup package are downloadable from sourceforge.net at the following web address: http://tdo.sourceforge.net. The setup package installs both the base library Tdo.dll and the source code generator TdoCodeGenerator.exe. To be able to use it it's recommended to have already installed both MS Visual Studio .NET 2005 and Sql Server 2005 (or EXPRESS/2000/7/MSDE).

[continued]