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, a开发者_运维问答fsharm
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.
Closest thing I can think of is SQL CLR.
Otherwise there is no OO scripting support in MSSQL.
LINQ - kind of...
精彩评论