DRAG DROP
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server database PassGuideDB.
To obtain data from PassGuideDB the ADO .NET Entity Framework to is used.
A new type is added.
The new type should organize scales values within a specific entity.
Stored procedures will be used to manage instances of the type.
What action should be taken.
Action #1, see link http://msdn.microsoft.com/en-us/library/vstudio/cc716778%28v=vs.100%29.aspx:
The ModificationFunctionMapping element in mapping specification language (MSL) maps the insert, update, and delete functions of a conceptual model entity type to stored procedures in the underlying database.
Action #3, see link http://msdn.microsoft.com/en-us/library/vstudio/bb738614%28v=vs.100%29.aspx:
The Function element in store schema definition language (SSDL) specifies a stored procedure that exists in the underlying database.
I am unclear as to why Action #2 is needed, and whether it’s even correct. Perhaps there is an error in the question (WTF are scales values?) maybe it should’ve been ‘scalar values’? Either way, hopefully this doesn’t come up on the exam.
Alright. Action #2 is definitely incorrect here. See question #160 in the first exam. Action #2 should be:
Create a complex type
…in the CSDL file.