;)

On Tue, Apr 12, 2011 at 12:10 PM, rhartzog <[email protected]> wrote:

> It was being issued twice, you are right Fabio (surprise).  It had to
> do with the lazy loading on a many-to-any association of a parent
> object above this one.  Thank you.
>
> On Apr 12, 9:56 am, rhartzog <[email protected]> wrote:
> > How am I issuing the query twice?
> >
> > using (var tx = _session.BeginTransaction())
> > {
> >     var market = _session.Query<Market>().Where(m => m.Id ==
> > [ID]).Single();
> >
> > }
> >
> > That is one select and it is being issued two times.  What am I
> > missing?
> >
> > On Apr 12, 9:45 am, Fabio Maulo <[email protected]> wrote:
> >
> >
> >
> >
> >
> >
> >
> > > because you are doing the query two times ?
> > > note: Query<T> != session.Get<T>
> >
> > > On Tue, Apr 12, 2011 at 11:36 AM, rhartzog <[email protected]> wrote:
> > > > If I issue a Get<T>(id) against the session I receive a single query:
> >
> > > > SELECT market0_.Id              as Id15_0_,
> > > >       market0_.Name            as Name15_0_,
> > > >       market0_.Code            as Code15_0_,
> > > >       market0_.DesignCityCode  as DesignCi4_15_0_,
> > > >       market0_.Disclaimer      as Disclaimer15_0_,
> > > >       market0_.WarrantyEmail   as Warranty6_15_0_,
> > > >       market0_.Phone_AreaCode  as Phone7_15_0_,
> > > >       market0_.Phone_Prefix    as Phone8_15_0_,
> > > >       market0_.Phone_Suffix    as Phone9_15_0_,
> > > >       market0_.Phone_Extension as Phone10_15_0_,
> > > >       market0_.Latitude        as Latitude15_0_,
> > > >       market0_.Longitude       as Longitude15_0_,
> > > >       market0_.Icon            as Icon15_0_,
> > > >       market0_.Zoom            as Zoom15_0_,
> > > >       market0_.State           as State15_0_
> > > > FROM   Markets market0_
> > > > WHERE  market0_.Id = '[ID]' /* @p0 */
> >
> > > > If I use the linq provider it issues two queries and I can't figure
> > > > out why.  I have tried both _session.Query<Market>().Where(m => m.Id
> > > > == [ID]).Single() and I have also tried (from m in
> > > > _session.Query<Market>() where m.Id == [ID] select m).Single().  Both
> > > > of these result in two queries, the only difference is the
> > > > capitalization in nhprof.  I can't figure out why it would be issuing
> > > > two selects.  (No, I do not have both of the above queries in at the
> > > > same time.  I switched them out for testing and both resulted in the
> > > > same thing):
> >
> > > > SELECT market0_.Id              as Id15_0_,
> > > >       market0_.Name            as Name15_0_,
> > > >       market0_.Code            as Code15_0_,
> > > >       market0_.DesignCityCode  as DesignCi4_15_0_,
> > > >       market0_.Disclaimer      as Disclaimer15_0_,
> > > >       market0_.WarrantyEmail   as Warranty6_15_0_,
> > > >       market0_.Phone_AreaCode  as Phone7_15_0_,
> > > >       market0_.Phone_Prefix    as Phone8_15_0_,
> > > >       market0_.Phone_Suffix    as Phone9_15_0_,
> > > >       market0_.Phone_Extension as Phone10_15_0_,
> > > >       market0_.Latitude        as Latitude15_0_,
> > > >       market0_.Longitude       as Longitude15_0_,
> > > >       market0_.Icon            as Icon15_0_,
> > > >       market0_.Zoom            as Zoom15_0_,
> > > >       market0_.State           as State15_0_
> > > > FROM   Markets market0_
> > > > WHERE  market0_.Id = '[ID]' /* @p0 */
> >
> > > > select market0_.Id              as Id15_,
> > > >       market0_.Name            as Name15_,
> > > >       market0_.Code            as Code15_,
> > > >       market0_.DesignCityCode  as DesignCi4_15_,
> > > >       market0_.Disclaimer      as Disclaimer15_,
> > > >       market0_.WarrantyEmail   as Warranty6_15_,
> > > >       market0_.Phone_AreaCode  as Phone7_15_,
> > > >       market0_.Phone_Prefix    as Phone8_15_,
> > > >       market0_.Phone_Suffix    as Phone9_15_,
> > > >       market0_.Phone_Extension as Phone10_15_,
> > > >       market0_.Latitude        as Latitude15_,
> > > >       market0_.Longitude       as Longitude15_,
> > > >       market0_.Icon            as Icon15_,
> > > >       market0_.Zoom            as Zoom15_,
> > > >       market0_.State           as State15_
> > > > from   Markets market0_
> > > > where  market0_.Id = '[ID]' /* @p0 */
> >
> > > > Notice the queries are exactly the same except for the
> > > > capitalization.  NHProf build is 837 and NHibernate version is
> > > > 3.1.0.4000.  I can't figure this out and would appreciate some help.
> >
> > > > --
> > > > You received this message because you are subscribed to the Google
> Groups
> > > > "nhusers" group.
> > > > To post to this group, send email to [email protected].
> > > > To unsubscribe from this group, send email to
> > > > [email protected].
> > > > For more options, visit this group at
> > > >http://groups.google.com/group/nhusers?hl=en.
> >
> > > --
> > > Fabio Maulo
>
> --
> You received this message because you are subscribed to the Google Groups
> "nhusers" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en.
>
>


-- 
Fabio Maulo

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to