Home |  Writing |  Consulting |  Schedule |  Scripts |  Links |  About










Paul's Blog...
Top Posts
Why use Stored Procs?
10 lessons from 35K tps
SQL Server:Fresh Vision
SQL Myths
Data Architecture
CodeGen AutoAudit Trail

Interviews...
CS TechCast
TechEd ArCast
PASSCamp 2008 Panel
SQL DownUnder


Locations of visitors to this page

SQL Server O/R Hybrid Database

Update: I've just signed with Manning Publications to write Object/Relational Hybrid Designs.

The SQL Server O/R Mapping experiment is an object-oriented abstraction facade layer that transforms SQL Server 2000 or 2005 from a relational database to an object-relational database.

O/R databases combine the query, industry, and integrity strengths of the relational engine with the development power of the object oriented interface, inheritance, association spidering, to create a vastly improved application development environment.



Developed completely with T-SQL, SQL Server O/R has been through about 20 iterations, and is well tuned for performance.

SQL Server O/R dbms supports the following Pure Object-Oriented concepts:
  • Classes / Sub Classes
  • Domain Integrity
  • Inheritance
  • Polymorphism
  • Complex Objects


  • Beyond pure OOdbms, SQL Server O/R dbms adds:
  • Workflow State
  • Complex Associations
  • Collections & Aggregations
  • Association Spidering
  • Façade Code Generation


  • Download
    O/R dbms ver.9
    O/R dbmsPowerPoint Presentation (1.8Mb)