.NET Entity Framework 4 - How to run custom SQL when a certain table is updated

Question

When Table1.Foo changes, I want to update a column on Table2. What would be easiest is if I could just "run" some custom SQL after the update to Table1 is committed, however there doesn't seem to be a place to do this.

It seems the "recommended" solution is to override the SaveChanges() method of EntitiesContext. However, I have several dozen models and hundreds of columns - it seems rather hacky and inefficient to execute code every time any model anywhere is changed, and then say "If it happens to be this property of this model, then do this.."

My first approach was to use a database trigger, which would be great. Unfortunately, Oracle doesn't appear to support this type of updating I need to do in a trigger.

Any other ideas for this sort of thing?

E.J. Brennan · Accepted Answer · 2011-09-22 16:34:33Z

1

Are you sure you can't just add a trigger that calls a stored procedure like this:

http://searchoracle.techtarget.com/answer/Calling-a-stored-procedure-from-a-trigger

It'll let you put in the functionality you want without disturbing your dozens of models/programs.

answered Sep 22, 2011 at 16:34

E.J. Brennan

46.9k8 gold badges94 silver badges120 bronze badges

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

1 Comment

Mike Christensen Over a year ago

Man I wish, that would be an ideal solution. However, since I need to query other values from the same table and those values are in a state of flux, it isn't supported. See Justin Cave's response to my question here: stackoverflow.com/questions/7507636/…

Changgyu Oh · Accepted Answer · 2011-09-25 05:32:28Z

0

You can create a partial class for the given entity in your project, if you did not create one.

In your partial class, you override PropertyChangedEvent handler to update other table. I don't think you have to create a stored procedure for that.

answered Sep 25, 2011 at 5:32

Changgyu Oh

161 bronze badge

1 Comment

Mike Christensen Over a year ago

I'll look into this method. So if I change a property in another table, the Entity framework will just automatically track this change and update everything when the transaction commits?

Daniel Kienböck · Accepted Answer · 2011-09-22 16:14:39Z

0

you can create a stored procedure and call it in a very easy way... I think

answered Sep 22, 2011 at 16:14

Daniel Kienböck

1054 bronze badges

3 Comments

Mike Christensen Over a year ago

The question is, where do I call this stored procedure?

jrummell Over a year ago

ctx.Database.ExecuteSqlCommand() stackoverflow.com/questions/5474264/…

Mike Christensen Over a year ago

Yes, I know /how/ to execute a stored proc from .NET - The question is WHERE do you put that logic? After anything in the context changes? That seems hacky.

Boomer · Accepted Answer · 2011-09-22 17:06:00Z

0

use the POCO feature in EF 4.0.

check this link: http://www.devart.com/blogs/dotconnect/index.php/entity-framework-tips-and-tricks-part-2.html

specially this section 'ObjectContext.ExecuteStoreQuery'

answered Sep 22, 2011 at 17:06

Boomer

1,4781 gold badge15 silver badges19 bronze badges

Collectives™ on Stack Overflow

.NET Entity Framework 4 - How to run custom SQL when a certain table is updated

4 Answers 4

1 Comment

1 Comment

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related