Yes, but you have to know when to use SQL and when to use .net.

SQL is still the language of choice for set based operations while

.net is useful for things you cannot accomplish easily with SQL. For example I have found .net to be invaluable in SSIS when you want to call external dlls.