I have this query:


That works fine, just as intended, but the SQL log show 2 select statements as does SQL Profilier.


Why are two selects being executed?

those selects are identical
maybe there's a bug on the outputing

I thought it may be the logging as well, but when I use SQL Profiler that shows all the SQL getting executed on the DB, it shows 2 statements, that are identical, being executed.

Anybody have any idea on this?

I am just trying to understand what is going on.

I look at SQL Profiler( shows the SQL being executed on the DB) and this query shows up twice:

exec sp_executesql N'select blogentity0_.Id as Id0_, blogentity0_.Name as Name0_, blogentity0_.Host as Host0_, blogentity0_.Path as Path0_, blogentity0_.Skin as Skin0_ from Blog blogentity0_ where (blogentity0_.Host=@p0 )and(blogentity0_.Path=@p1 )',N'@p0 nvarchar(9),@p1 nvarchar(5)',@p0=N'LocalHost',@p1=N'Path1'

post the mapping... maybe that will give a clue

Here is the mapping file, its pretty standard as far as I know.

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="YABE.Core" namespace="YABE.Core.Domain">
<class name="BlogEntity" table="Blog">
<id name="Id" column="Id" access="field.camelcase">
<generator class="identity" />
</id>
<property name="Name" />
<property name="Host" />
<property name="Path" />
<property name="Skin" />
</class>
</hibernate-mapping>

Here is the configuration: (I am using Castle's NHibernate facility, which is why the config looks a bit different)

<item key="hibernate.connection.provider">NHibernate.Connection.DriverConnectionProvider</item>
<item key="hibernate.connection.driver_class">NHibernate.Driver.SqlClientDriver</item>
<item key="hibernate.connection.connection_string">Data Source=(local)\SQL2005;Initial Catalog=YABE_Test;Integrated Security=SSPI</item>
<item key="hibernate.dialect">NHibernate.Dialect.MsSql2005Dialect</item>
<item key="hibernate.show_sql">true</item>