You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You
create stored procedures by using the following signatures:
• CREATE procedure [dbo].[Product_Insert] (@name varchar (50) / 6pri.ce float)
• CREATE procedure [dbo].[Product_Updatej (@id int, Bname varchar(50), @price float)
• CREATE procedure [dbo].[Product_Delete] (@ id int)
• CREATE procedure [dbo] .[Order_Insert] (@productld int, @quantity int)
• CREATE procedure [dbo] .[Order_Update] (@id int, Gquantity int,@originalTimestamp
tlmestamp)
• CREATE procedure [dbo].[Order_Delete](@id int)
You create a Microsoft ADO.NET Entity Data Model (EDM) by using the Product and Order entities as
shown in the exhibit. (Click the Exhibit button.)
You need to map the Product and Order entities to the stored procedures. To which two procedures
should you add the Qproductld parameter? (Each correct answer presents part of the solution.
Choose two.)
A.
Order_Update
B.
Order_Delete
C.
Product_Delete
D.
Product_Update
Explanation:
@productId parameter resides in the order table…