criteria

How to query a subproperty with NHibernate’s criteria api and the entity to load only the subproperties matching a predicate condition...

Assuming the following: public class Order { public virtual int OrderId {get;set} public virtual ISet<Product> Products {get;set} } public class Product { public virtual int ProductId {get;set} public virtual string ProductName {get;set} } How would you query using the criteria api so that only an order with a specific o...

Is there an NHibernate criterion which does actually nothing?

Hi! I'm looking for an NHibernate criterion which does not add a restriction to a criteria. The reason for this is that I have a method which converts some input parameters into a criterion which is added to a criteria. There is a constellation of the input parameters where no restriction needs to by applied. Therefore I want to return ...

Choosing a Subversion Server

Hi, After settling on Subversion as my RCS needs (and AnkhSVN/TortoiseSVN for my primary Subversion clients), I am trying to choose an SVN server. I have looked at a bunch of them: Local (ie file:///) Collabnet VisualSVN Server Tigris SilkSVN SharpSVN Apache module I’ve installed each in a VM to try them out but have not found enoug...

NHibernate ICriteria subqueries with ISet<T> properties: Is this correct?

Given a class A related to another class B in a one-to-many relationship, how can you create an NHibernate query (using the Criteria API--no HQL) to find all objects A who "have none" of the related objects B? Specifics follow, but I wanted to get the question out there first. I have two model classes, Sample and SampleDiagnosis. Sam...

How to achieve "not in" by using Restrictions and criteria in Hibernate?

I have list of category. I need a list of category by excluding 2,3 row. Can we achieve through hibernate by using Criteria and Restriction? ...

Rich Domain Querying with NHibernate

Hi, I have been playing around with the AbstractSearchFilter featured in Ayende blog here. The idea is you abstract the query building for search to the UI. While I can see how it works for simplistic restriction queries I am struggling to see how this could be used for something such as subqueries on ID, which are very comment in my ap...

How can I sort in (n)hibernate on a property of a child object?

I have an object from my domain model that has a child object. How can I use a criteria query to order based on a property of the child? For example: class FooType { public int Id { get; set; } public string Name { get; set; } public BarType Bar { get; set; } } class BarType { public int Id { get; set; } public st...

Nhibernate query issue

Hi ! Considering the following mapping file where TemporaryAccessOpenCommand and TemporaryAccessCloseCommand both inherit from base class Command <class name="Command" table="xxx_Commands" lazy="false"> <id name="Id" type="Int32" unsaved-value="0"> <generator class="identity"/> </id> <property name="BeginDate" /> <property name="EndD...

Nhibernate Tag Cloud Query

Hi, This has been a 2 week battle for me so far with no luck. :( Let me first state my objective. To be able to search entities which are tagged "foo" and "bar". Wouldn't think that was too hard right? I know this can be done easily with HQL but since this is a dynamically built search query that is not an option. First some code: p...

How do add NOLOCK with nHibernate?

Hi, How do you add NOLOCK when using nhibernate? (criteria query) ...

Hibernate Criteria contains-in on an association to a table

Good day, I have a Hibernate mapping that looks something like this: <class name="MyEntity"> <set name="scalarSet" table="(select fk, scalar_value from other_table)"> <key column="fk"/> <property column="scalar_value" type="long"/> </set> </class Given this, how do I query such that a value of MyEntity.scalarSet (which is...

Sorting on multiple fields with criteria in Grails

Hi, I have the following query which id like to sorty by "raceDate" and by "raceNo" asc. I can figure out how to sort by one field, but not by two, any ideas? def list = { params.max = Math.min( params.max ? params.max.toInteger() : 20, 100) params.offset = params?.offset?.toInteger() ?: 0 params.sort = "raceDate" ...

Joining two tables over a compound index in Hibernate

I have Entity A - type - uniqueKey and Entity B - uniqueKey and i dont know how to integrate it into hibernate that i can produce results like from this query: select * from A left join B on B.uniqueKey = A.uniqueKey and A.tpye = 1 where A.id is null this will produce a result that has all the entries of B that are not in A fo...

How can one delete NHibernate objects using a criteria?

Dear ladies and sirs. This must be a simple question. Given a criteria, how one deletes the entities satisfying the criteria? The rationale: HQL and NH criteria are NHibernate specific constructs and as such they are server side DAL implementation details. I do not want them to "leak" to the client side. So, our client side provides ...

How to insert an "Optimizer hint" to Hibernate criteria api query

i have a hibernate query that is dynamically put together using the criteria api. it generates queries that are unbearably slow, if executed as-is. but i have noted they are about 1000% faster if I prepend /*+ FIRST_ROWS(10) */ to the query. how can i do this with the criteria api? i tried criteria.setComment(..), but this seems to be ...

Multi Criteria Search Algorithm

Hello, Here's the problem : I've got a huuge (well at my level) mysql database with technical products in it. I ve got something like 150k rows of products in my database plus 10 to 20 others tables with the same amount of rows. Each tables contains a lot of criteria. Some of the criteria are text values, some are decimal, some are just...

comparing/intersecting compare criteria

If there's any open source code that does this already I'm interested in hearing about it. But I haven't seen it yet so I'm trying to roll my own. Example: variable x = compareCriteriaBetween 3 and 6 variable y = compareCriteriaLesserThanOrEqual 5 The difficult part for me is finding an elegant way to compare the compareCriteria and ...

NHibernate: Creating a criteria which applies for all queries on a table

Using Castle ActiveRecord / NHibernate: Is there a way you can force an ICriterion on all queries on a table? For example, a good amount of of my tables have a "UserId" column. I might want to ensure that I am always selecting rows for the logged in user. I can easily create an ICriterion object, but I am forced to supply it for differe...

NHibernate 2.1: LEFT JOIN on SubQuery with Alias (ICriteria)

Hello, I am basically trying to create this query with NHibernate ICriteria interface: SomeTable 1:n AnotherTable SomeTable has columns: PrimaryKey, NonAggregateColumn AnotherTable has columns: PrimaryKey, ForeignKey, AnotherNonAggregate, YetAnotherNonAggregate SELECT table1.NonAggregateColumn, subquery.SubQueryAggregate...

Criteria building nhibernate

Hi, I was wondering if someone could help with an example criteria for nhibernate. I think I've got my head around fairly basic things, like finding records in a given table who's field matches a certain value etc. Where I'm currently tripping up is where you have a table with a foreign key for another table, and attempting to find rows ...