Ayende @ Rahienhttp://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660pb commented on NHProf: Alive! It is alive!Instead of checking the SQL string, check what the SQL string is based on so it isn't dependent on formatting changes, those auto generated aliases, etc., Maybe something like: Assert.IsTrue(selectBlogById.HasTablesExact(new string[] { "Blogs" })); Assert.IsTrue(selectBlogById.HasColumnsExact(new string[] { "Id", "Title", "Subtitle", "AllowsComments", "CreatedAt" })); http://ayende.com/3647/nhprof-alive-it-is-alive#comment8http://ayende.com/3647/nhprof-alive-it-is-alive#comment8Wed, 15 Oct 2008 19:20:20 GMTAyende Rahien commented on NHProf: Alive! It is alive!pb, Can you explain more? I don't think that I follow you http://ayende.com/3647/nhprof-alive-it-is-alive#comment7http://ayende.com/3647/nhprof-alive-it-is-alive#comment7Wed, 15 Oct 2008 13:51:18 GMTpb commented on NHProf: Alive! It is alive!I was thinking more along the lines of Query.HasColumns(new string[] { "Column1", "Column1").IsForTable("SomeTable"), etc. http://ayende.com/3647/nhprof-alive-it-is-alive#comment6http://ayende.com/3647/nhprof-alive-it-is-alive#comment6Wed, 15 Oct 2008 13:46:54 GMTAyende Rahien commented on NHProf: Alive! It is alive!Ken, This is going to be commercial, so I don't think so http://ayende.com/3647/nhprof-alive-it-is-alive#comment5http://ayende.com/3647/nhprof-alive-it-is-alive#comment5Mon, 13 Oct 2008 08:19:45 GMTKen Egozi commented on NHProf: Alive! It is alive!Is the code available anywhere? http://ayende.com/3647/nhprof-alive-it-is-alive#comment4http://ayende.com/3647/nhprof-alive-it-is-alive#comment4Mon, 13 Oct 2008 07:19:14 GMTKrzysztof Koźmic commented on NHProf: Alive! It is alive!Maybe it's time to introduce WhitespaceIgnoringStringComparer ? To NUnit, not Ayende's tool. http://ayende.com/3647/nhprof-alive-it-is-alive#comment3http://ayende.com/3647/nhprof-alive-it-is-alive#comment3Mon, 13 Oct 2008 07:10:05 GMTCory Foy commented on NHProf: Alive! It is alive!Not even formatting changes. This test *will* fail on Mono/Linux unless the code is compiled because all of those newlines are \r\n and Linux would be \n. Trust me - that was one of the most difficult challenges we faced with getting NUnit running. System.Environment.NewLine is your friend: [www.cornetdesign.com/.../...nvironmentnewline.html](http://www.cornetdesign.com/2006/03/importance-of-systemenvironmentnewline.html)http://ayende.com/3647/nhprof-alive-it-is-alive#comment2http://ayende.com/3647/nhprof-alive-it-is-alive#comment2Mon, 13 Oct 2008 00:29:11 GMTpb commented on NHProf: Alive! It is alive!Would you consider the test to be overspecified since formatting changes would break this test which tests functionality? http://ayende.com/3647/nhprof-alive-it-is-alive#comment1http://ayende.com/3647/nhprof-alive-it-is-alive#comment1Mon, 13 Oct 2008 00:19:54 GMT