CD -C# 1st
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](Gname varchar(50),8price 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, Gquantity Int)
• CREATE procedure [dbo].[Order_Update](@id int, Gquantity int,GoriginalTimestamp
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_Delete
B.
Product_Update
C.
Order_Update
D.
Product_Delete
Explanation:
@productId parameter resides in the order table…