asp.net - Is there any way to get all data retrieved between two points in C# code (Linq-to-sql) -


my cenario follow: i'm working in 1 system developed in c# asp.net (a big, huge , definetly grown anyway system). , i'm trying begin create unit tests start refactor (believe, it's need refactor (there controllers 10k, 12k lines). problem lot of things in system related database (and system tightly coupled database). database context instantiated in lot of pieces of code, , not injected. so, point mock data local mdb file refactor code , create unit tests have own mdb (with database structure, data use).

in though? that:

[testmethod()] public void anytest() {     var dblogger = new dblogger(); //this class not created, it's example.     dblogger.start();       worstwrittenmethodever(); //this method call other methods insides,                                 //a couple of                                 //and don't know order ,                                //complexity (much times high), ,                                //instantiate datacontext lot of times ,                                //a lot of data retrieval.      db.stoplog();     console.writeline(db.dataretrieved); //and in line print tables     //and data retrieved between 2 points. }

after that, data, mock 1 mdb file, , refactor unit test above unit test.

is there anyway that?

looks not easy task. , think should use popular , tested library or tool. recommendation use miniprofiler. allows capture sql queries (also includes support of linqtosql). has ui , api interact within code. sql queries data can use following method:

miniprofiler.current.getsqltimings();

Comments

Post a Comment

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

i have following sample code used pre-decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(--c); cout << c << endl; return; } } this function give output input 4 : dp3 dp2 dp1 dp0 0 1 2 3 but when use post decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(c--); cout << c << endl; return; } } output goes in infinite loop dp4 can explain me in detail why happens ? this happens because function(c--) called same value of c , when finishes c decremented. recursively called, hence called same value no chance of return , hit stack overflow error. assume this, int x = 1, y = 0; y = x++ result y == 1 , x == 2. if y = ++x , bot x , y 2.
Read more

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

i added new project. made mistake in projectname.conf file in sites-available apache2, led me reinstalling apache2. after reinstalling , re-enabling projects on every page of every project .. <body> run(); </body> .. i've run composer update, restarted service, restarted pc, checked config files, tried disabling new project. there nothing in error log, , access.log: 127.0.0.1 - - [15/may/2015:01:40:47 +0200] "get / http/1.1" 304 181 "-" "mozilla/5.0 (x11; ubuntu; linux x86_64; rv:38.0) gecko/20100101 firefox/38.0" maybe i'm forgetting apache2 reinstall? don't think did different last time installed it. looks haven't setup php correctly. take @ this great guide , maybe you're forgetting link php config apache2.
Read more

php - How can I echo out this array? -

i don't know how go grabbing data in variable , put foreach loop. class tree{ private $info = array( array('name'=>'jim','state'=>'nu','company'=>'nu','phone'=>array('cell'=>'5615111111','office'=>'5611111111'),'email'=>array('primary'=>'exs@example.com','ex@there.com')), array('name'=>'joe smith','city'=>'phoenix','phone'=>'4805551111','email'=>'jsmith@some_email.com'), array('name'=>'john doe','city'=>'chandler','company'=>'doe co.','email'=>array('jdoe@gmail.com','personal'=>'email@email.com'),'phone'=>'6025550002') ); } if you're inside of class, can access private variable using $this->variablename . example, i...
Read more