Demo applications with source code
Simple query with criteria on the Microsoft Northwind® database
Following sample shows just the principles of simple mapping to the Microsoft Northwind® Access database and a query with criteria of suppliers. Only direct object mapping to tables and object field to table column is configured. Mapping configuration can be seen opening the file Mapping.xml in DADO Database Mapper®
Persist Windows® forms and controls on a database
Following sample shows how to persist existing .NET objects from the System.Windows.Forms package. You can see how DADO Solution® is absolutely not intrusive in your object model. Any object, no matter from where it inherits or which interfaces it implements, can be persisted and serialized through a network between any client and DADO Application Server®. It also shows advanced serialization surrogate usage and 1:n mapping. By double clicking on any row you can see the associated dialog created from the database data. Mapping configuration can be seen opening the file Mapping.xml in DADO Database Mapper®
Mapping inheritance to relational structures
Following sample shows how to map object inheritance on relational structures. It shows all types of inheritance mapping (Normalized inheritance, Redundant inheritance and Shared inheritance) and how to query on the base types or inherited types. The object model is kept very simple (a base type "Animal" with inherited types "Man" and "Dog") to concentrate on inheritance mapping and not on other mapping features. Mapping configuration can be seen opening the files Mapping.Normalized.xml ,Mapping.Redundant.xml or Mapping.Shared.xml in DADO Database Mapper®.
Query across three Microsoft Northwind® distributed databases
Following sample shows the Northwind database tables distributed over three MS-Access databases (Northwind.Categories.mdb, Northwind.Products,mdb ,Northwind.Suppliers.mdb) and the demo application querying objects with 1:1 references across database boundaries. Mapping configuration can be seen opening the files Mapping.xml in DADO Database Mapper®.
Advanced object / relational mapping
Following sample shows advanced object/relational mappings, from direct field mapping to advanced object-in-one-field or 1:1 and 1:n relationships mapping, value association mapping and more.
Distributed databases accessed with DADO Broker System®
Following sample shows the Northwind database tables distributed over three MS-Access databases (Northwind.Categories.mdb, Northwind.Products,mdb ,Northwind.Suppliers.mdb ) and relative O/R mapping data defined in three different mapping files (Northwind.CategoriesMapping.xml, Northwind.ProductsMapping.xml and Northwind.SuppliersMapping.xml ) and brokered through DADO Broker System®. Broker configuration can be seen opening the file Broker.xml in DADO Broker System®.
Persistence of a "Setting" object in a name/value table
Following sample shows for to persist your application settings in a name/value table