You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application.
You use the Entity Framework Designer to create an Entity Data Model using model-first development.
The database has the following requirements:
* each table must have a datetime column named time_modified
* each table requires a trigger that updates the value of the time_modified column when a row is inserted or updated
You need to ensure that the database script that is created by using the Generate Database From Model option meets the requirements.
What should you do?
A.
Create a new T4 template, and set the DDL Generation template to the name of the new template.
B.
Create a new Windows Workflow Foundation workflow, and set Database Generation Workflow to the name of the new workflow.
C.
Add a DateTime property named time_modified to each entity in the model and set the property’s StoreGeneratedPattern to Computed.
D.
Add a new entity named time_modified to the model, and modify each existing entity so that it inherits from the new entity.
Explanation:
Model-First in the Entity Framework 4
(http://msdn.microsoft.com/en-us/data/ff830362)
Why not C? (See question #41).
I tried to figure out, what did you mean by that, because Q#41 seems to be about connection strings.
Anyways, it could be a pain in the *** to add a property to each entity if you have like 50 ones in your model. It is much faster apply something to all with T4.
Yeah, they reversed the order of the questions on this site a while back. What used to be Q41 is now Q148.