http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Ayende, can you detail the process a little bit more? In a topic complete away from profiller stuff, I have great interest in such thing http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment10http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment10Wed, 18 Nov 2009 19:37:28 GMTOnce again, the blogs tagline is *very* apt. http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment9http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment9Tue, 17 Nov 2009 23:45:11 GMTFabian, You can't actually implement internal interfaces using SRE, that is the first thing that I tried, and it doesn't work. What I mean by breaking the type system is creating a type that lies about what it is. When you ask it "are you a Foo", it will say yes, and when you ask it, "are you Bar" (totally unrelated to Foo) it will say yes as well. It is a lying type, basically, and a nasty one that relies on specific usage pattern. http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment8http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment8Tue, 17 Nov 2009 08:08:01 GMTOkay, I'll give in and ask the question: What do you mean by you "had to break the CLR type system to get this to work"? I'd guess you could do a few things by using transparent proxies and injecting them via reflection, but I wouldn't consider this as a breaking of the type system. You could also use Reflection.Emit to implement some internal interfaces (hoping that the accessibility flags won't be verified at runtime, of which I'm not sure). This actually is cheating the type system (if it works), but I'm not sure whether this is what you did. So what's behind that ominous phrase? :) http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment7http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment7Tue, 17 Nov 2009 08:03:30 GMT@"Chris Smith": There is a reason the stuff ayende changed using reflection is private. Imagine everything would be public: People would rely on internals all the time. The .net framework code would be unchangeable in even the simplest detail. http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment6http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment6Tue, 17 Nov 2009 01:01:40 GMTAnother reason B&D languages should go away! It makes it hard for you to get to the good stuff (and change it). Bring on C# 6... which will resemble python with a C syntax. http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment5http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment5Mon, 16 Nov 2009 18:35:34 GMTThat's hilarious. In my experience with L2S, coercive hook ins have become a somewhat typical necessity. http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment4http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment4Mon, 16 Nov 2009 17:20:59 GMTImran, That is probably too expensive to do on tool that emphasis low footprint on the profiled app http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment3http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment3Mon, 16 Nov 2009 15:01:11 GMTWonder if there is anyway to hook in to the client statistics that are generated when queries are run (e.g. the stats the management studio shows when you turn on the 'include client statistics' option). http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment2http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment2Mon, 16 Nov 2009 12:42:19 GMTha! best post ever! http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment1http://ayende.com/4294/l2s-prof-hardships-getting-query-duration-and-row-counts#comment1Mon, 16 Nov 2009 10:44:34 GMT