⟩ Suppose You develop a Windows-based inventory management application that interacts with a MicrosoftSQL Server database. Your application enables users to update information about items ininventory. Each time a user changes an inventory item, your application executes a SQL Serverstored procedure XYZSP to update rows in the database. XYZSP will run many times during eachuser session.Your application will use a SqlCommand object to execute XYZSP. You must revise your code sothat the use of this object optimizes query performance.What should you do?A. Call the SqlCommand.DeriveParameters method before each call toSqlCommand.ExecuteNonQuery.B. Call the SqlCommand.Prepare method before each call to SqlCommand.ExecuteNonQuery.C. Call the SqlCommand.DeriveParameters method before the first call toSqlCommand.ExecuteNonQuery.D. Call the SqlCommand.Prepare method before the first call to SqlCommand.ExecuteNonQuery.