views:

233

answers:

2

Does anyone know a good reference to look into what Object Relational features are available in SQL Server (any version)? I found a really good summery for Oracle but all I can find for SQL Server is information about LINQ to SQL, which is good stuff, but I'm looking for more power in the database like defined types, nested tables, etc.

I know you can use CLR types in SQL Server, and that would be interesting to me too, I just am looking for a good place to read about all the OR features it has.

PS. I'm willing to purchase a book.

+1  A: 

You should read Best Practices for Semantic Data Modeling for Performance and Scalability.

Remus Rusanu
Thank you, that looks interesting. *printing*
tster
A: 

The SQL Server is not as object relational as one might expect - not that long ago I realized that it does not (even) support table inheritance.

Daniel Brückner
That's what it seems like to me, but I was hoping I was wrong and just couldn't find information about it because no one in academia uses it.
tster
Coming from PostgreSQL I couldn't believe that, too. But I searched hard, read a lot, talked to some cohorts, and am quite confident now, that MS SQL does at least not support table inheritance.
Daniel Brückner