http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Dirk, It is supported for the next 10 years http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment24http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment24Fri, 09 Oct 2009 11:26:57 GMTI thought Linq to SQl was not being supported by MS anymore? Has this changed? http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment23http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment23Fri, 09 Oct 2009 09:42:09 GMTRob, It is complex and not really interesting. http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment22http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment22Tue, 06 Oct 2009 20:29:09 GMTDo you mind sharing how then? I'm guessing by your terse replies that you probably don't want to say, maybe for competitive reasons or something. I'm just curious because it seems like a useful thing to be able to do. http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment21http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment21Tue, 06 Oct 2009 20:05:52 GMTRob, I am not making ANY changes to he linq to sql binaries, they are running as they always did. I am hooking up to them externally. Ivo, It is a good first test. http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment20http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment20Tue, 06 Oct 2009 20:02:57 GMTmmhhh is not Linq to SQL dead or something? http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment19http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment19Tue, 06 Oct 2009 17:05:45 GMTI don't get it. If you're using someone else's linq to sql dlls (or your own custom ones) the inject extensibility points, then your first bit about there being 0 you need to do to make it work isn't true as you'd need to change the reference to be to your dll. Unless you unregister from the gac and add yours or something. http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment18http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment18Tue, 06 Oct 2009 16:19:33 GMT@Ayende : this is as tasty as a bun covered in aweseomsauce! I can't _wait_ to get my hands on this :) I hope it's not a pre-April fools joke ... +1 for giving L2S some love :) http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment17http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment17Mon, 05 Oct 2009 23:44:23 GMTcowgaR, Yes, it is for real, and I intend to target the 3.5 versions first. http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment16http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment16Mon, 05 Oct 2009 23:26:51 GMTyour rhino logo looks a bit weird next to the "Linq to SQL" tag ... i've to get used to that after associating the rhino with alt net for a long time, maybe you change that to a softer, "rhino light" ;) ... however great to see that you get some business going on after volunteering for so long http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment15http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment15Mon, 05 Oct 2009 22:28:04 GMTwell I see the x-profiler post now... man, haven't been here for a while and the "world is changing so fast".. :) and how "peaceful and quiet", I mean relaxing, my world was without the need to hit Oren's blog this night if there's anything new, hehe http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment14http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment14Mon, 05 Oct 2009 20:48:34 GMTok I'm too excited to read article (or comments) so I just quickly spit my question out... is it real? will it be avaiable for Entity Framework v4? man you're killing me :D http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment13http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment13Mon, 05 Oct 2009 20:44:50 GMTGood to see L2S being given some love. It deserves it. http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment12http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment12Mon, 05 Oct 2009 20:43:24 GMTNice work Ayende. This is a good example of the benefits you get from well-architected code -- the fact that this was so easy to implement, because you're not tightly coupled to any particular ORM. And now you can get rich selling NH Prof to millions of L2S users :) http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment11http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment11Mon, 05 Oct 2009 20:27:14 GMTThis will be huge. Sql Profiler is just not good enough these days. http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment10http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment10Mon, 05 Oct 2009 16:56:17 GMTSergejus, The first two, certainly. The third is much more complicated, and likely won't be there. http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment9http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment9Mon, 05 Oct 2009 16:54:41 GMTAyende, Recently I've spent a _lot_ of time optimizing LINQ to SQL performance. This tool will be really handy for the devs! Are you planning to put alerts for the: [*] N+1 selects [*] Possibly suboptimal queries (for example select * from 10 tables). [*] Unclosed transactions [*] ... I'd be very interested in testing your bits ;) http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment8http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment8Mon, 05 Oct 2009 16:28:07 GMTSell out!!!!!! ;) http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment7http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment7Mon, 05 Oct 2009 14:41:50 GMTOh no... You changed the blog by-line. So you don't want any more patches? ;) http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment6http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment6Mon, 05 Oct 2009 14:40:14 GMTRob, Do you see the blo's tag line? That is how. http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment5http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment5Mon, 05 Oct 2009 13:25:33 GMTHow are you hooking all the datacontext open stuff? http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment4http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment4Mon, 05 Oct 2009 13:17:50 GMTYES!!!!!!!!!!!!!! http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment3http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment3Mon, 05 Oct 2009 13:15:51 GMTRonald, Yes, there is perf penalty, and you can put an if around it for production usage. http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment2http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment2Mon, 05 Oct 2009 12:58:57 GMTThis is something that I often wish I could do with LinqPad. Very cool Oren! The only thing that worries me is that initialize line. Does it incur penalty on production? Is there a switch to turn it off if it does (kinda like setting verbosity on logging)? http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment1http://ayende.com/4230/linq-to-sql-profiler-spike-results#comment1Mon, 05 Oct 2009 12:53:42 GMT