queryover Questions

1

Solved

I have the following problem Basically I have the 2 snippets below: var contactAssociation = session.QueryOver<ContactAssociation>(() => contactAssociationAlias) .Where(() => conta...
Zante asked 15/6, 2011 at 18:12

1

Solved

How can I do the following using QueryOver and no Formula Fields. I have the following parent child relationship public class Club { public string Name { get; set; } public IList<Membership...
Prau asked 13/6, 2011 at 16:21

1

Solved

I'm trying to emulate subject query with NHibernate's IQueryOver. So far I have var q = CurrentSession.QueryOver<ObjectModel.Order>(). WhereRestrictionOn(o => o.Buyer.ID).IsIn(partyIDs)....
Natividadnativism asked 16/5, 2011 at 15:27

3

Solved

I am trying to create a query using QueryOver, which will fetch a collection using the Select or SubSelect mode. The entity in question is Track. I want to load a collection called TrackPrices, and...
Harm asked 10/3, 2011 at 16:21

1

Solved

I want to use query over to give me back an object public class TaskMap : ClassMap<Task> { public TaskMap() { Table("Tasks"); Id(x => x.TaskId); Map(x => x.TaskName).NvarcharWit...
Intelligible asked 7/5, 2011 at 18:6

1

Solved

I need to do a subquery on a sub collection but I can't get it to work. I tried this Task tAlias = null; List<Task> result = session.QueryOver<Task>(() => tAlias) .Where(Restric...
Spontoon asked 11/5, 2011 at 19:0

2

Solved

I have been searching the internet and can't find an example on how to use the queryover of nhibernate 3.0 For example I would like to use the string functions on the where clause of the queryover ...
Doall asked 11/5, 2011 at 15:43

1

Trying to use QueryOver and a flagged enum query. This works in Nhibernate.Linq: var results = repo.Query() .Where(x => (x.Classification & LineItemClassification.Shipping) == LineItemClas...
Baryon asked 5/4, 2011 at 20:14

1

Solved

I'm trying to get a count from a query with a group by and just can't figure out how to translate the SQL I want into NHibernate's QueryOver syntax. This is the SQL: select count(*) from (select...
Brainpan asked 21/4, 2011 at 17:37

1

Solved

I'm trying to convert a SQL query to NHibernate QueryOver syntax, but I don't understand how to sort by the count projection. This is what the SQL Query looks like: select top 10 v.intVoteUserID,...
Brandenburg asked 18/4, 2011 at 19:58

1

Solved

How can I use Future for delayed execution with Get() to retrieve a single record (or Load()?) Also, can I use Future with a detached QueryOver
Stereoscopy asked 15/4, 2011 at 19:20

1

Solved

I have the following objects in a hierarchy A > B > C > D. Each object is mapped to a table. I'm trying to write the following SQL using QueryOver: SELECT B FROM A, B, C, D WHERE A.ID = B...
Daryl asked 1/4, 2011 at 21:55

1

I have a HQL query: select max(l.Num) from SomeTable l group by l.Type, l.Iteration How can I translate/convert it to QueryOver? Following one: var grouped = session.QueryOver<SomeTable&gt...
Wanonah asked 31/3, 2011 at 21:22

1

Solved

I have a problem. I have Persons and Cats. Each Person has some Cats (there is a foreign key in Cats that points to the primary key in Persons). Each Cat has an Age. I want to select the Persons th...
Mcgary asked 4/3, 2011 at 14:18

1

Solved

I am trying some code out from a NH 3.0 Cookbook, and wondering why I can't get the code below to compile. I think the QueryProjectionBuilder that should make this work is in "NHibernate.Criterion....
Bowes asked 19/12, 2010 at 6:35

1

Solved

I'm in the process of learning QueryOver, but I can't for my life figure out how to do simple many to many queries. I've written the following: var result = Session.CreateCriteria(typeof (Produc...
Hulbert asked 10/10, 2010 at 14:53

© 2022 - 2024 — McMap. All rights reserved.