Posted
by masoud ramezani
on Stack Overflow
See other posts from Stack Overflow
or by masoud ramezani
Published on 2010-06-07T11:35:33Z
Indexed on
2010/06/07
11:42 UTC
Read the original article
Hit count: 236
When must we use eager loading in NHibernate? What is it's usage?
© Stack Overflow or respective owner
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
I have two objects with a many-to-many relationship between them, as follows:
public class LeftHandSide
{
public LeftHandSide()
{
Name = String.Empty;
Rights = new HashSet<RightHandSide>();
}
public int Id { get; set; }
public string Name { get; set;…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello there,
I am trying to use NHibernate with Spring.Net und mySQL 5. However, when setting up the connection and creating the SessionFactoryObject, I get this InvalidCastException:
NHibernate seems to cast MySql.Data.MySqlClient.MySqlConnection to System.Data.Common.DbConnection which causes…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
One of practices advocated by Nhibernate experts is to do all actions in inside a transaction.
In a typical 3 tier web architecture, Nhibernate depedency is limited the data layer.
In such a case is it fine to use
using (var tr = NHibernateSession.Current.BeginTransaction()) {
at the controller…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello, and first off thanks for your time to look at this.
For a research project I'm working on, I have a somewhat complex design (which I've been given) to persist to a database via NHibernate.
Here's an example of the class hierarchy:
TransitStrategy, TransportationCompany and TransportationLocation…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello, I have a table with a time column in my SQL Server 2008 database.
The property of the object I'm trying to map to is a TimeSpan.
How can i tell FluentNHibernate to use the TimeAsTimeSpan NHibernate type, so that I don't have cast problems?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have an application that has an n+1 query problem, but when I implemented a way to load the data eagerly, I found absolutely no performance gain. I do use an identity map, so objects are only created once.
Here's a benchmark of ~3000 objects.
first query + first object creation: 0.00636100769043…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Simple task: given that an article has many comments, be able to display in a long list of articles how many comments each article has. I'm trying to work out how to preload this data with Arel.
The "Complex Aggregations" section of the README file seems to discuss that type of situation, but it…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have two models in relation one-to-many:
class Question(db.Model):
questionText = db.StringProperty(multiline=False)
class Answer(db.Model):
answerText = db.StringProperty(multiline=False)
question = db.ReferenceProperty(Question, collection_name='answers')
…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Is it possible to do eager loading with HQL without touching mappings?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm a little confused as to the mechanics of eager loading in active record. Lets say a Book model has many Pages and I fetch a book using this query:
@book = Book.find book_id, :include => :pages
Now this where I'm confused. My understanding is that @book.pages is already loaded and won't execute…
>>> More
