In VB6, when i wanted to manipulate SQL Server from code I would included a reference to the SQL-DMO. Is there a newer way to do this in .NET?