what best proceed .savechanges() slight ado.net information services?


does anyone have good information use .savechanges() method?



i am experiencing accumulation issues attempting .savechanges() slight information context object. i am holding information an existent information source, formulating suitable entityframework/dataservice objects, populating those combined objects data, adding those objects context following saving information job .savechanges.



the scenarios i've adult (and problems compared them) such ... any unfolding i have foreach loop holding information rows datatable generating objects, attaching context go. (note: 3 objects "member" twin "addresses" trustworthy around setlink call) - fundamentally reworking apparatus take information data store massage information store unprotected information services.




  • call .savechanges() but any parameters once during finish foreach loop (i.e. outmost loop)


    • outofmemory blunder 1/3 proceed (30,000 out 90,000 saves) - certain duty nonetheless any save vigilant seperate sql database, there run out memory on?


  • call .savechanges() but any parameters once per loop


    • this works, nonetheless takes absolutly evermore (8 hours 90,000 saves)


  • call .savechanges(savechangesoption.batch) once during finish foreach loop


    • same outofmemory error, nonetheless but any saves database


  • call .savechanges(savechangesoption.batch) once per loop


    • 404 found error


  • call .savechanges(savechangesoption.batch) once per 10 loops


    • 400 bad ask blunder (occassionally)

    • outofmemory after array itterations


  • a array futile attempts emanate context once per loop, have non-static during start loop have private member non-static available.


    • differing results, amateurish quantify, zero unequivocally good




what prefered slight job .savechanges() fan vigilant doing infinite information bucket this? there something i'm removing .savechanges() works? anyone yield some-more sum once should utilizing duty (if any) prerequisites saving information around information services? there any best practices around .savechanges() slight call? there any quite good support .savechanges() slight call?



Comments

Post a Comment

Popular posts from this blog

list macos calm editors formula editors

i searched found maudite's doubt text editors nonetheless windows. as have doubt guessed, i am perplexing out there any text/code editors mac besides i know of. i'll correct post consolidate editors listed. free textwrangler xcode mac vim aquamacs closer uncanny emacs jedit editra eclipse netbeans kod textmate2 - gpl brackets atom.io commercial textmate bbedit subethaedit coda sublime calm 2 smultron webstorm peppermint articles associated subject faceoff, best calm editor ever? maceditors.com, mac editors comforts compared thank everybody total suggestions.
Read more

how hibernate @any-related annotations?

could someone explain me any-related annotations ( @any , @anymetadef , @anymetadefs @manytoany ) work practice. i have tough awaiting any useful support (javadoc alone isn't unequivocally helpful) these. i have so distant collected somehow assent referencing summary extended classes. case, since there an @onetoany annotation? 'any' referring unparalleled 'any', churned 'any'? a short, receptive illustrating instance unequivocally many appreciated (doesn't have compile). edit: many i accept replies answers give credit where due, i found both smink's sakana's answers informative. since i can't accept several replies the answer , i unfortunately symbol conjunction answer.
Read more

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?

Image
hopefully settlement value thousand lines formula since i don't wish have frame down asp.net code, html, javascript, css yield an instance (but i'll supply i on ask someone doesn't contend "oh, i've seen before! try this...") [actually, i post formula css - bottom question]. here apportionment form page being displayed firefox: the blue boxes surrogate stylings <label> add-on orange lines surrogate border styles <div> tags (so i where extend break). <label> 's styled float: left <div 's right. addition, heir controls <div> also float:left definitely line adult tip <div> (since there taller controls multiline textboxes down below). the radio buttons generated an asp control, wrapped <span> - also floated left given heir <div> . here same apportionment shade rendered ie7: there few teenager digest differences, nonetheless large that's pulling me crazy additional white space beside <input> con...
Read more