Generate data script from DbContext in entity framework

Question

I am working on entity framework and would want to generate and insert/update/delete script from the DbContext object, when changes are about to be saved. As of now I have only been able to get the DDL script from the context, by using the following snippet.

string str = ((IObjectContextAdapter)_objDataContext).ObjectContext.CreateDatabaseScript();

Is there a way to generate a script for all the changes?

Lukas Kabrt · Accepted Answer · 2015-10-21 20:13:41Z

3

There isn't any built-in way to generate DML scripts for changes before the SaveChanges() method is called, but it is possible to intercept insert/update/delete commands as they are being sent to the DB after SaveChanges() has been called.

EF 6 introduced two extensibility points for such scenarios.

It it possible to set the _objDataContext.Database.Log property a TextWriter, where all SQL commands issued by the context will be logged.

Another option is implementing an interceptor, that is called by the EF when it is about to execute a command or after the command has been executed. Interceptors allow you to log the SQL command being sent and even provide a way to suppress execution of the command.

To create an interceptor you need to write a class that implements the IDbCommandInterceptor interface and register this class in Entity Framework.

DbInterception.Add(new MyInterceptor());

For more details you can see a sample implementation on MSDN.

A solution for older versions of the Entty Framework might be a wrapping provider around your current db provider.

answered Oct 21, 2015 at 20:13

Lukas Kabrt

5,5194 gold badges45 silver badges59 bronze badges

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

1 Comment

SubqueryCrunch Over a year ago

This is just the thing that i was searching for! also something that might help others: StringBuilder sb = new StringBuilder(); dbContext.Database.Log = s => sb.AppendLine(s);

Collectives™ on Stack Overflow

Generate data script from DbContext in entity framework

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related