which, if any, procedures should this mapping be applied?

Signature exhibit:
”CREATE procedure [dbo].[Job_Insert](@employeeId ,int, @quality int)
”CREATE procedure [dbo].[Job_Update](@id int. @quality int, @originalTimestamptimestamp)
”CREATE procedure [dbo].[Job_Delete](@id int)
”CREATE procedure [dbo].[Employee_Insert](@name varchar(20).@salary float)
”CREATE procedure [dbo].[Employee_Update](@id int, @ id int, @name varchar(20),@salary
float)
”CREATE procedure [dbo].[Employee_Delete](@id int)
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
There is an MS ADO.NET EDM (Entity Data Model) for the Employee and Order tables.

There is 1 to many relation between the ID column in the Employee Table and the
EmployeeID column in the Job table. The Employee and Jobs entities might need to be
mapped to the stored procedures, being displayed in the signature exhibit.
To which, if any, procedures should this mapping be applied? Select all that applies.

Signature exhibit:
”CREATE procedure [dbo].[Job_Insert](@employeeId ,int, @quality int)
”CREATE procedure [dbo].[Job_Update](@id int. @quality int, @originalTimestamptimestamp)
”CREATE procedure [dbo].[Job_Delete](@id int)
”CREATE procedure [dbo].[Employee_Insert](@name varchar(20).@salary float)
”CREATE procedure [dbo].[Employee_Update](@id int, @ id int, @name varchar(20),@salary
float)
”CREATE procedure [dbo].[Employee_Delete](@id int)
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
There is an MS ADO.NET EDM (Entity Data Model) for the Employee and Order tables.

There is 1 to many relation between the ID column in the Employee Table and the
EmployeeID column in the Job table. The Employee and Jobs entities might need to be
mapped to the stored procedures, being displayed in the signature exhibit.
To which, if any, procedures should this mapping be applied? Select all that applies.

A.
No mapping is required.

B.
Employee_Update

C.
Job_Delete

D.
Job_Updat

E.
Employee_Delete

Explanation:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


John Galt

John Galt

I have no clue what the correct answers are here. Anyone?

John Galt

John Galt

I hate these retarded questions with no clear answers. Here’s one article I found that states:
Function mappings require that you map all three of the funcitons, Insert, Update and Delete. If you only map one or two of the functions, the model will not validate.

That leads me to believe that the correct answer is (A. No mapping is required), because the other answers don’t include ‘Insert’ mapping.

Source:
http://learnentityframework.com/LearnEntityFramework/tutorials/using-stored-procedures-for-insert-update-amp-delete-in-an-entity-data-model/