Is it possible to create default value via expression in Entity Developer for columns such as UpdatedOn?

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
EdB
Posts: 92
Joined: Mon 15 Oct 2012 09:24

Is it possible to create default value via expression in Entity Developer for columns such as UpdatedOn?

Post by EdB » Wed 08 Jan 2014 14:51

Hi,

I need to populate 2 columns:

a) UpdatedOn
b) UpdatedBy

Is it possible to specify the population of these in ED?

Usually I would write a trigger at DB level. Also I would be interested in extracting the application user name for the "UpdatedBy" value not the DB login name like "SA" or whatever.

Thanks in advance.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Is it possible to create default value via expression in Entity Developer for columns such as UpdatedOn?

Post by Shalex » Fri 10 Jan 2014 09:21

Entity Developer doesn't include this functionality. Please use an approach with triggers as you did.

Post Reply