我们是否还需要在C＃代码和存储过程中应用Sql Transaction？

I have a stored procedure which is updating multiple tables in SQL Server. This procedure is being used from C# code.I have a stored procedure which is updating mul