PA href="http://codebetter.com/blogs/kyle.baley/archive/2009/01/06/nhibernate-profiler-minute-15.aspx"FONT face=Verdana size=2Kyle mentions/FONT/AFONT face=Verdana size=2 he was playing with Oren's NHibernate Profiler and how excited he was that NHibernate Profiler was able to detect and thus help him reduce the number of queries for a single page. He mentions: #8220;The target this time is NHibernate Profiler. As of this moment, I've had it "installed" for all of fifteen minutes and I've already reduced the query count of one page from 205 to 1.#8221;/FONT/P PFONT face=Verdana size=2Kyle is just playing with NHibernate Profiler, but it brings up an excellentnbsp;question for those who are new to using /FONTA href="http://davidhayden.com/blog/dave/category/24.aspx?Show=All"FONT face=Verdana size=2O/R Mappers/FONT/AFONT face=Verdana size=2 - do you really know how your shiney O/R Mapper is communicating with the database? Is it eager loading or lazy loading those objects? It is making one roundtrip or 500 roundtrips to get the data?/FONT/P PFONT face=Verdana size=2I have talked to numerous developers in the past who have been surprised by the chattiness of their O/R Mapper. I mentioned quite awhile ago in a post about LINQ To SQL, /FONTA href="http://codebetter.com/blogs/david.hayden/archive/2007/08/06/linq-to-sql-query-tuning-appears-to-break-down-in-more-advanced-scenarios.aspx"FONT face=Verdana size=2LINQ To SQL - Query Tuning Appears To Break Down In *More Advanced* Scenarios/FONT/AFONT face=Verdana size=2, that you can run into those dreaded SELECT N+1 scenarios if you are not careful and end up creating 10's if not 100's of queries to fetch a graph of objects from the database. This also unexpectedly happens to developers who use lazy loading and then access that load-on-demand data 1nbsp;query at a time, causing once again 10's if not 100's of extranbsp;queries in the background./FONT/P PFONT face=Verdana size=2As you use O/R Mappers you start to become more aware of these situations, but you always need to fire up SQL Server Profiler or even a profiler like /FONTA href="http://davidhayden.com/blog/dave/archive/2008/09/04/RedGateANTSProfiler4Released.aspx"FONT face=Verdana size=2ANTS Profiler/FONT/AFONT face=Verdana size=2 or /FONTA href="http://davidhayden.com/blog/dave/archive/2008/05/08/dotTraceProfiler31VisualStudio2008VistaWindowsServer2008.aspx"FONT face=Verdana size=2dotTrace/FONT/AFONT face=Verdana size=2 to find those hotspots in your applications that may be causednbsp;by excessive database roundtrips by the O/R Mapper. I am not suggesting you go crazy with performance optimization, but it is important to understand what the O/R Mapper is doing in the background and act accordingly./FONT/P PFONT face=Verdana size=2A href="http://www.davidhayden.com/"David Hayden/A/FONT/P PFONT face=Verdana size=2/FONTnbsp;/P PFONT face=Verdana size=2STRONGRelated Posts:/STRONG/FONT/P UL LIA href="http://davidhayden.com/blog/dave/archive/2008/12/14/IUpdatableLINQToSQLADONETDataServicesUpdatedORMappers.aspx"FONT face=Verdana size=2IUpdatable for LINQ To SQL and ADO.NET Data Services Updated - O/R Mappers/FONT/A/LI LIA href="http://davidhayden.com/blog/dave/archive/2008/11/14/LearnASPNETMVCNHibernateORMapperSharpArchitecture.aspx"FONT face=Verdana size=2Learn ASP.NET MVC and NHibernate O/R Mapper - Sharp Architecture/FONT/A/LI LIA href="http://pnpguidance.net/Post/SampleFluentNHibernateT4TemplatesCodeGenerationLINQToSQL.aspx"FONT face=Verdana size=2Sample Fluent NHibernate T4 Templates for Code Generation via LINQ To SQL/FONT/A/LI LIA href="http://pnpguidance.net/Post/DownloadSubsonicAlpha3ORMapperLINQSupport.aspx"FONT face=Verdana size=2Download Subsonic Alpha 3 - O/R Mapper with LINQ Support/FONT/A/LI LIA href="http://pnpguidance.net/Post/TelerikOpenAccessORMapperDataAccessLayerLINQSupport.aspx"FONT face=Verdana size=2Telerik OpenAccess O/R Mapper - Data Access Layer with LINQ Support/FONT/A/LI/UL Pnbsp;/Pimg src ="http://davidhayden.com/blog/dave/aggbug/3754.aspx" width = "1" height = "1" /

PFONT face=Verdana size=2Tag: /FONTA href="http://www.flacodebrew.net/"FONT face=Verdana size=2Florida .NET Developer Events/FONT/A/P PFONT face=Verdana size=2/FONTnbsp;/P PFONT face=Verdana size=2IMG alt="Sarasota .NET Developers" src="/photos/sarasotadev-logo.jpg" align=rightIf you can make it to the STRONGSarasota .NET Developer Meeting on Thursday, January 22, 2009 at 6pm at the Sarasota Community Foundation/STRONG, I will be presenting:/FONT/P PFONT face=Verdana size=2/FONTnbsp;/P H2FONT face=Verdana size=2Introduction to Aspect-Oriented Programming ( AOP ):/FONT/H2 PFONT face=Verdana size=2Learn how to be more productive and write more maintainable software by leveraging aspect-oriented programming features in various dependency injection and third party frameworks. In this session we will look at how you can reduce the amount of logging, authorization, validation, caching, etc. code you write by using functionality provided by Unity, Enterprise Library, PostSharp, Castle DynamicProxy, Windsor, and other 3rd party Frameworks./FONT/P PFONT face=Verdana size=2/FONTnbsp;/P PFONT face=Verdana size=2Due to the nature of this topic we will be talking about a lot of topics:/FONT/P UL LIA href="http://codebetter.com/blogs/david.hayden/archive/2008/09/30/decorator-pattern.aspx"FONT face=Verdana size=2Decorator Pattern/FONT/A/LI LIA href="http://www.pnpguidance.net/post/GenericDecoratorChainsExampleUnityDependencyInjectionContainer.aspx"FONT face=Verdana size=2Generic Decorator Chains/FONT/A/LI LIFONT face=Verdana size=2Logging, Security, Validation, Caching and other Cross-Cutting Concerns/FONT/LI LIA href="http://www.pnpguidance.net/Tag/DependencyInjection.aspx"FONT face=Verdana size=2Dependency Injection/FONT/AFONT face=Verdana size=2 and /FONTA href="http://www.pnpguidance.net/Tag/IoC.aspx"FONT face=Verdana size=2Inversion of Control/FONT/A/LI LIFONT face=Verdana size=23rd Party Libraries: Autofac, Unity, Windsor, PostSharp, DynamicProxy, /FONTA href="http://www.pnpguidance.net/Category/EnterpriseLibrary.aspx"FONT face=Verdana size=2Enterprise Library/FONT/A/LI/UL PFONT face=Verdana size=2/FONTnbsp;/P PFONT face=Verdana size=2If you are new to these topics, I will provide an introduction to each topic as well as show real-world use of these libraries and concepts in various applications./FONT/P PFONT face=Verdana size=2/FONTnbsp;/P PFONT face=Verdana size=2Date: Thursday, January 22, 2009/FONT/P PFONT face=Verdana size=2Sarasota Community FoundationBR2635 Fruitville Rd.BRSarasota, FL 34237BR(just west of Tuttle on the north side of Fruitville)./FONT/P PFONT face=Verdana size=2/FONTnbsp;/P PFONT face=Verdana size=2Check out the Sarasota .NET Developers Website for other A href="http://www.sarasotadev.net/"upcoming events/A./FONT/P PFONT face=Verdana size=2/FONTnbsp;/P PFONT face=Verdana size=2I hope to see you there!/FONT/P PA href="http://www.davidhayden.com/"FONT face=Verdana size=2David Hayden/FONT/A/P Pnbsp;/Pimg src ="http://davidhayden.com/blog/dave/aggbug/3753.aspx" width = "1" height = "1" /

PFONT face=Verdana size=2IMG alt="Microsoft MVP" src="/photos/mvplogo.jpg" align=rightI have been on vacation for the past two weeks enjoying a bit of rest and relaxation./FONT/P PFONT face=Verdana size=2On January 1st I received a wonderful email message from Microsoft congratulating me on being awarded a STRONGMicrosoft MVP in 2009/STRONG. I am once again honored and humbled by being awarded the distinction ofnbsp;Microsoft MVP in C# for 2009. This is my 4th year receiving the award and it always brings a smile to my face at the start of each year./FONT/P PFONT face=Verdana size=2I am starting the new year with a bang again with a number of presentations scheduled for the beginning of the year:/FONT/P UL LIFONT face=VerdanaFONT size=2STRONGIntroduction to Aspect-Oriented Programming/STRONG in Sarasota Florida on January 22, 2009/FONT/FONT/LI LIFONT face=VerdanaFONT size=2STRONGSQL Server Data Access Tips and Techniques/STRONG in Tampa for SQL Saturday ( Tentative )/FONT/FONT/LI LIFONT face=Verdana size=2Three Presentations at the South Florida Code Camp on February 7, 2009:/FONT/LI UL LIFONT face=Verdana size=2STRONGIntroduction to Enterprise Library and Unity Application Block/STRONG/FONT/LI LIFONT face=Verdana size=2STRONGIntroduction to Aspect-Oriented Programming/STRONG/FONT/LI LIFONT face=Verdana size=2STRONGASP.NET MVC Extensibility/STRONG/FONT/LI/UL LIFONT face=Verdana size=2TBD Topic for the Tampa .NET Developer Group in March 2009/FONT/LI LIFONT face=Verdana size=2TBD Topic for the Central Florida .NET User Group on Tuesday, April 21, 2009/FONT/LI LIFONT face=Verdana size=2IASA Tampa Presentation on STRONGEnterprise Library and Unity/STRONG in April or May 2009 ( Pending )/FONT/LI/UL PFONT face=Verdana size=2/FONTnbsp;/P PFONT face=Verdana size=2You can also catch me on my various blogs:/FONT/P UL LIA href="http://www.davidhayden.com/"FONT face=Verdana size=2David Hayden/FONT/AFONT face=Verdana size=2: RSS = /FONTA href="http://feeds.feedburner.com/DavidHayden"FONT face=Verdana size=2http://feeds.feedburner.com/DavidHayden/FONT/A/LI LIA href="http://www.pnpguidance.net/"FONT face=Verdana size=2Patterns amp; Practices Guidance/FONT/AFONT face=Verdana size=2: RSS = /FONTA href="http://feeds.feedburner.com/PnPGuidance"FONT face=Verdana size=2http://feeds.feedburner.com/PnPGuidance/FONT/A/LI LIA href="http://www.flacodebrew.net/"FONT face=Verdana size=2Florida .NET Developer Events/FONT/AFONT face=Verdana size=2: RSS = /FONTA href="http://feeds.feedburner.com/FlaCodeBrew"FONT face=Verdana size=2http://feeds.feedburner.com/FlaCodeBrew/FONT/A/LI LIA href="http://codebetter.com/blogs/david.hayden/"FONT face=Verdana size=2CodeBetter.com/FONT/AFONT face=Verdana size=2: RSS = /FONTA href="http://codebetter.com/blogs/david.hayden/rss.aspx"FONT face=Verdana size=2http://codebetter.com/blogs/david.hayden/rss.aspx/FONT/A/LI/UL PFONT face=Verdana size=2/FONTnbsp;/P PFONT face=Verdana size=2Happy Holidays and Best Wishes!/FONT/P PFONT face=Verdana size=2Dave/FONT/P PFONT face=Verdana size=2/FONTnbsp;/Pimg src ="http://davidhayden.com/blog/dave/aggbug/3752.aspx" width = "1" height = "1" /

An updated release...img src ="http://davidhayden.com/blog/dave/aggbug/3751.aspx" width = "1" height = "1" /

A start for sharing your creative juices...img src ="http://davidhayden.com/blog/dave/aggbug/3750.aspx" width = "1" height = "1" /

Latest Service Pack.img src ="http://davidhayden.com/blog/dave/aggbug/3749.aspx" width = "1" height = "1" /

Should we be seeing custom code anymore?img src ="http://davidhayden.com/blog/dave/aggbug/3748.aspx" width = "1" height = "1" /

Microsoft should have provided this with .NET 3.5 SP1...img src ="http://davidhayden.com/blog/dave/aggbug/3747.aspx" width = "1" height = "1" /

This is stunning. About time...img src ="http://davidhayden.com/blog/dave/aggbug/3746.aspx" width = "1" height = "1" /

Quick tip on green tea...img src ="http://davidhayden.com/blog/dave/aggbug/3745.aspx" width = "1" height = "1" /

Small businesses need a hand up...img src ="http://davidhayden.com/blog/dave/aggbug/3744.aspx" width = "1" height = "1" /

Good way for children and adults...img src ="http://davidhayden.com/blog/dave/aggbug/3743.aspx" width = "1" height = "1" /

I hate to see the Bucs lose, but the Panthers were on fire last night...img src ="http://davidhayden.com/blog/dave/aggbug/3742.aspx" width = "1" height = "1" /

Really hate these insects with a passion :)img src ="http://davidhayden.com/blog/dave/aggbug/3741.aspx" width = "1" height = "1" /

This will be interesting...img src ="http://davidhayden.com/blog/dave/aggbug/3740.aspx" width = "1" height = "1" /

Phil Haack has an example, too...img src ="http://davidhayden.com/blog/dave/aggbug/3739.aspx" width = "1" height = "1" /

Another quick example.img src ="http://davidhayden.com/blog/dave/aggbug/3738.aspx" width = "1" height = "1" /

Tis the season to think about healthimg src ="http://davidhayden.com/blog/dave/aggbug/3737.aspx" width = "1" height = "1" /

Just updated to new versions...img src ="http://davidhayden.com/blog/dave/aggbug/3736.aspx" width = "1" height = "1" /

A tip on improving NHibernate Performance...img src ="http://davidhayden.com/blog/dave/aggbug/3735.aspx" width = "1" height = "1" /

I didn't realize Windows Mobile was so low in the rankings.img src ="http://davidhayden.com/blog/dave/aggbug/3734.aspx" width = "1" height = "1" /

I presented Spark at the event and wanted to provide some links...img src ="http://davidhayden.com/blog/dave/aggbug/3733.aspx" width = "1" height = "1" /

Worth attending if you have the time...img src ="http://davidhayden.com/blog/dave/aggbug/3732.aspx" width = "1" height = "1" /

Macworld gives Fusion an eddy award if that means anything to you.img src ="http://davidhayden.com/blog/dave/aggbug/3725.aspx" width = "1" height = "1" /

December sale.img src ="http://davidhayden.com/blog/dave/aggbug/3724.aspx" width = "1" height = "1" /

Simple example of creating a pie chart.img src ="http://davidhayden.com/blog/dave/aggbug/3723.aspx" width = "1" height = "1" /