Is there any way I can run multiple SQL statements inside one SqlCommand? For example, I'd like to insert a record and then SELECT SCOPE_IDENTITY and return it. Also, it seems that you cannot use ...