ASP.NET Entity Framework - Create Trigger Programatically

Question

I posted this question on the ASP.NET forums, and was eventually directed to post the same question here.

Original asp.net forums post: http://forums.asp.net/t/1774923.aspx/1?Database+Generated+DateTimes

I'm trying to add CreatedDate and ModifedDate to my Code First models. If this were database first I would have added a GETDATE() default value to both of these. A few options were presented on how to do this using C.F.. However, I think the cleanest suggestion was to use triggers to manage these date fields.

Is there a way to manage the creation of triggers using the E.F./C.F. so that I don't have to re-create them every time my model changes?

ricka6 from the asp.net forums suggested I include the following post as it may be related: Mapping many to many relationship

Thank you! -Walker

Community · Accepted Answer · 2017-05-23 12:10:53Z

0

Try using EF 4.3 with database migrations, so your database won't be recreated every time your model changes. Alternatively, you can take a look at this question for ideas how to create custom database initializer.

edited May 23, 2017 at 12:10

CommunityBot

11 silver badge

answered Mar 2, 2012 at 12:08

Balazs Tihanyi

6,7495 gold badges26 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ASP.NET Entity Framework - Create Trigger Programatically

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related