You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You create stored procedures by using the following signatures:
CREATE procedure [dbo].[Product_Insert](@name varchar(50),@price float)
CREATE procedure [dbo].[Product_Update](@id int, @name varchar(50), @price float)
CREATE procedure [dbo].[Product_Delete](@id int)
CREATE procedure [dbo].[Order_Insert](@productId int, @quantity int)
CREATE procedure [dbo].[Order_Update](@id int, @quantity int,@originalTimestamp timestamp)
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:
You need to map the Product and Order entities to the stored procedures. To which two procedures should you add the @productId parameter?
(Each correct answer presents part of the solution. Choose two.)
A.
Product_Delete
B.
Product_Update
C.
Order_Delete
D.
Order_Update
Explanation:
@productId parameter resides in the order table…