c# - Insert into multiple tables using WCF Transactions -

-

i trying add entry table , use primary key of added entry create additional entry table.

the error getting is

the transaction manager has disabled support remote/network transactions. (exception hresult: 0x8004d024)

i believe caused creating multiple connections within single transactionscope, doing within 1 context / using statement, not believe should receiving error.

service

    [operationbehavior(transactionscoperequired = true)]     public void creategroup(newgroupdata data)     {         var grouprepo = _grouprepo ?? new investigatorgrouprepository();         grouprepo.creategroup(data.userid, data.investigatorgroupname, data.hasgameassignment, data.institutionid);      }

repository

   public void creategroup(string userid, string investigatorgroupname, bool hasgameassignment, int institutionid)     {         using (var context = new gamedbcontext())         {             var newgroup = new investigatorgroup()             {                 investigatorgroupname = investigatorgroupname,                 hasgameassignment = hasgameassignment,                 institutionid = institutionid,                 istrashed = false             };              int institutionuserid =                 context.institutionusers.where(                     iu => !iu.istrashed && iu.apuser.userid == userid && iu.institutionid == institutionid).select(iu => iu.institutionuserid).single();              var newgroupuser = new investigatorgroupuser()             {                 institutionuserid = institutionuserid,                 investigatorgroup = newgroup,                 creationdate = datetime.now             };             context.investigatorgroupusers.add(newgroupuser);              context.savechanges();         }     }

you start wrong assumption.

the line...

int newgroupid = context.investigatorgroups.add(newgroup).investigatorgroupid;

...will assign 0 newgroupid. add method marks entity insert, doesn't insert it. savechanges writes data database, not other method in entity framework.

so assignment...

investigatorgroupid = newgroupid,

...is faulty well. have assign new investigatorgroup navigation property in investigatorgroupuser:

investigatorgroup = newgroup,

add navigation property investigatorgroupuser if haven't got yet.

if have that, it's enough execute these lines:

context.investigatorgroupusers.add(newgroupuser); context.savechanges();

no need add newgroup object too, added adding newgroupuser.

so if that, transaction need 1 savechanges uses internally default. code show, don't need transactionscope. if part of greater wcf transaction story may different, think @ least needed misconceptions straightened out.


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