Does SQL Server support Object modeling?

Thanks in advance