Is there any library for T-SQL to turn it object oriented?

Question

Hi all,

Microsoft Ajax Library has added full object orientation to JavaScript. Is there any library, framework, component, package, etc equivalent for T-SQL? It would be very nice to write object oriented SQL scripts in MS SQL Server.

Cheers, afsharm

Answer 1

SQL Server, like other RDBMSs, doesn't come in an object flavor. Sorry.

These days this problem is solved on the application end through the use of ORM (object-relational mapping) frameworks. Options depend on what development platform you're using. For .NET, take a look at Microsoft's Entity Framework and SubSonic.

Answer 2

LINQ - kind of...

Answer 3

Closest thing I can think of is SQL CLR.

Otherwise there is no OO scripting support in MSSQL.