c# - Entity Framework 6 - How can I view the SQL that will be generated for an insert before calling SaveChanges -

-

in entity framework 6, possible view sql executed insert before calling savechanges? 

using (var db = new stuffentities()){     db.things.add(new thing({...});     //can sql insert statement @ point?     db.savechanges(); }

i'm familiar how generated sql query before execution so:

var query = db.thing.where(x => x.id == 9); console.writeline(query.tostring()); //this prints sql select statement

the query returns iqueryable<> whereas insert returns dbset , calling tostring on dbset prints standard object name.

another option (if understand question correctly), use idbcommandinterceptor implementation, seemingly allows inspect sql commands before executed (i hedge words have not used myself).

something this:

public class commandinterceptor : idbcommandinterceptor {     public void nonqueryexecuting(         dbcommand command, dbcommandinterceptioncontext<int> interceptioncontext)     {         // whatever command.commandtext     } }

register using dbinterception class available in ef in context static constructor:

static stuffentities() {     database.setinitializer<stuffentities>(null); // or have     system.data.entity.infrastructure.interception.dbinterception.add(new commandinterceptor()); }

Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more