icriteria
NHIbernate: Setting up subquery to use property value from outer query
I have the following sub/criteria: var sq = DetachedCriteria.For<Title>() .CreateAlias(\"Genres\", \"genre\")[详细]
2023-02-25 01:02 分类:问答Using Postgres aggregate functions with NHibernate
I have the following query: SELECT title_id, title, array_agg(g.name) FROM title t INNER JOIN title_genre tg USING(title_id)[详细]
2023-02-21 05:30 分类:问答Querying a many-to-many collection or how to include a many-to-many table in a criteria query?
I am quite new to the world of NHibe开发者_如何学Crnate and I can\'t seem to get this to work with the use of a criteria query: query a many-to-many relationship or query a collection (set/bag) on an[详细]
2023-02-19 11:44 分类:问答NHibernate Paged Results & Incorrect Row Count
I have a model called \'BusinessPage\' which can be associated with 1 or more \'BusinessPageCategories\'. So I\'ve got a 3rd table called \'BusinessPagesInCategories\' that links these two.[详细]
2023-02-15 21:05 分类:问答NHibernate CreateAlias - Joins on arbitrary columns
This question seems to come up a bit and I\'ve yet to see a good answer. I have two classes with no foreign key and no real relationship other than a common field, in this case \"Title\".[详细]
2023-02-07 12:28 分类:问答Are NHibernate ICriteria queries cached or put in the identity map?
Using NHibernate I usually query for single record开发者_JAVA百科s using the Get() or Load() methods (depending on if I need a proxy or not):[详细]
2023-02-07 01:53 分类:问答Nhibernet select count
I have two entity A: public class Product { pu开发者_运维技巧blic virtual int ID { get; set; } public virtual IList<Picture> Pictures { get;set;}[详细]
2023-02-04 07:36 分类:问答Does DetachedCriteria/ICriteria have any restriction on join depth?
Imagine I have C1, C2 and C3 classes. Suppose we can have string dummy = c1.ContainerC2.ContainerC3.Prop1. Is there any restriction that does not allow me to create an alias directly from C3 without h[详细]
2023-01-27 02:25 分类:问答NHibernate correlated subquery using ICriteria
I\'ve been doing some work evaluating NHibernate for an upcoming project and am working through some use cases to see how it performs. I haven\'t yet been able to find a way to express the following q[详细]
2023-01-22 06:40 分类:问答How to run Nhibernate ICriteria query with setFetchMode(Lazy) when lazy=false defined in HBM?
I\'d like to run a criteria query with lazy many-to-one associations. Those associations are set as lazy=\"false\" in the HBM. It\'s because we use it eagerly 90% of the project.[详细]
2023-01-18 14:57 分类:问答