NHibernate – CreateCriteria vs CreateAlias

by

given these requirements there would be no difference, the generated SQL is the same:
for mappings:

    <?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
    <class name="Project" table="Project">
        <id name="Id" type="Int32" unsaved-value="0">
            <column name="Id" sql-type="int" not-null="true" unique="true"/>
            <generator class="native" />
        </id>
        <many-to-one name="Job" column="FK_JobId" cascade="save-update" not-null="true" />
    </class>
</hibernate-mapping>
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
    <class name="Job" table="Job">
        <id name="Id" type="Int32" unsaved-value="0">
            <column name="Id" sql-type="int" not-null="true" unique="true"/>
            <generator class="native" />
        </id>
        <property name="Name" type="String">
            <column name="Name" sql-type="nvarchar" length="50" not-null="true"/>
        </property>
    </class>
</hibernate-mapping>

and classes 

public class Project
    {
        public Project() { }

        public virtual int Id { get; set; }

        public virtual Job Job { get; set; }
    }
public class Job
    {
        public Job() { }

        public virtual int Id { get; set; }

        public virtual String Name { get; set; }
    }

these criteria definitions 

ICriteria criteriacrit = session
  .CreateCriteria(typeof (Project))
  .CreateCriteria("Job", "job")
  .Add(Restrictions.Eq("job.Name", "sometextA"));

ICriteria aliascrit = session
  .CreateCriteria(typeof (Project))
  .CreateAlias("Job", "job")
  .Add(Restrictions.Eq("job.Name", "sometextB"));

generate the same SQL

SELECT 
  this_.Id as Id2_1_, 
  this_.FK_JobId as FK2_2_1_, 
  job1_.Id as Id1_0_, 
  job1_.Name as Name1_0_ 
FROM 
  Project this_ 
  inner join Job job1_ 
    on this_.FK_JobId=job1_.Id 
WHERE job1_.Name = @p0; @p0 = 'sometextA'

SELECT 
  this_.Id as Id2_1_, 
  this_.FK_JobId as FK2_2_1_, 
  job1_.Id as Id1_0_, 
  job1_.Name as Name1_0_ 
FROM
  Project this_ 
  inner join Job job1_ 
    on this_.FK_JobId=job1_.Id 
WHERE job1_.Name = @p0; @p0 = 'sometextB'

note however that the CreateAlias relies on the mappings to generate associations whereas the CreateCriteria call allows to specify JoinType.

so, these calls

ICriteria criteriacrit = session
  .CreateCriteria(typeof(Project))
  .CreateCriteria("Job",JoinType.LeftOuterJoin)
  .Add(Restrictions.Eq("Name", "sometextA"));

ICriteria aliascrit = session
  .CreateCriteria(typeof (Project))
  .CreateAlias("Job", "job")
  .Add(Restrictions.Eq("job.Name", "sometextB"));

generate these SQL statements

SELECT 
  this_.Id as Id2_1_, 
  this_.FK_JobId as FK2_2_1_, 
  job1_.Id as Id1_0_, 
  job1_.Name as Name1_0_ 
FROM 
  Project this_ 
  **left outer** join Job job1_
    on this_.FK_JobId=job1_.Id 
WHERE job1_.Name = @p0; @p0 = 'sometextA'

SELECT 
  this_.Id as Id2_1_, 
  this_.FK_JobId as FK2_2_1_, 
  job1_.Id as Id1_0_, 
  job1_.Name as Name1_0_ 
FROM Project this_ 
  **inner join** Job job1_ 
    on this_.FK_JobId=job1_.Id 
WHERE job1_.Name = @p0; @p0 = 'sometextB'

More Related Contents:

  1. What is the best way to set a register to zero in x86 assembly: xor, mov or and?
  2. Why are loops always compiled into “do…while” style (tail jump)?
  3. Enhanced REP MOVSB for memcpy
  4. Why is Skylake so much better than Broadwell-E for single-threaded memory throughput?
  5. Efficiently compute pairwise squared Euclidean distance in Matlab
  6. Understanding the impact of lfence on a loop with two long dependency chains, for increasing lengths
  7. How to speed up A* algorithm at large spatial scales?
  8. Comparing BSXFUN and REPMAT
  9. Branch alignment for loops involving micro-coded instructions on Intel SnB-family CPUs
  10. Why is XCHG reg, reg a 3 micro-op instruction on modern Intel architectures?
  11. What methods can be used to efficiently extend instruction length on modern x86?
  12. Should I use multiplication or division?
  13. Spark: Inconsistent performance number in scaling number of cores
  14. Lost Cycles on Intel? An inconsistency between rdtsc and CPU_CLK_UNHALTED.REF_TSC
  15. Faster implementation of verbal arithmetic in Prolog
  16. postgresql COUNT(DISTINCT …) very slow
  17. R: speeding up “group by” operations
  18. Why should recursion be preferred over iteration?
  19. LCP time between LightHouse and Performance – Google Chrome
  20. simplest tool to measure C program cache hit/miss and cpu time in linux?
  21. Why is division more expensive than multiplication?
  22. Mapping 2 vectors – help to vectorize
  23. Should a developer aim for readability or performance first? [closed]
  24. Return address prediction stack buffer vs stack-stored return address?
  25. When should we use prefetch?
  26. Relative performance of x86 inc vs. add instruction
  27. Efficient sse shuffle mask generation for left-packing byte elements
  28. preallocate list in R
  29. How to analyze golang memory?
  30. How to avoid Query Plan re-compilation when using IEnumerable.Contains in Entity Framework LINQ queries?

Leave a Comment