Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If the second query is executing 3,000 queries, it is almost certainly lazy-loading the <code>Settings</code> collection. As you iterate over the list, you access this collection, and each time NHibernate goes back to the database to fetch it. <strong>Try setting the fetch mode for the Settings property to eager load in the mapping.</strong></p> <p>Beyond that, the LINQ provider could be an issue. What version of NHibernate are you using? The 2.x LINQ provider has some real limitations. It has been reimplemented in the 3.0 trunk, but you'll have to download and compile it from the source.</p> <p>By the way, ICriteria vs IQueryable is not related to Fluent NHibernate. Criteria API and LINQ are two providers through which you can create queries. Fluent NHibernate is an alternative way to perform configuration.</p>
    singulars
    1. This table or related slice is empty.
    1. POUnable to figure out how to do Joins within IQueryable
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJay
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POUnable to figure out how to do Joins within IQueryable
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThis is only a problem on a single page within the Admin. Thanks for your suggestion and in most cases it would be the right move. Unfortunately in my situation it causes more problems then it solves. It causes my other pages to pull too much data from the SQL server. That is bad since SQL is not Localhost. I have tracked down what I have to do. I need to use ICriteria and with the way Fluent NHibernate is setup in the project I am using it is not declared so I can't easily use it. I am working through adding it as an option. Thanks for your suggestion.
      singulars
      1. PO
      1. USMichael D. Kirkpatrick
    2. CO@Michael Sorry, I wasn't clear. I meant set it to eager load as a way to identify the problem. If that works, then no, you don't want to *always* eager load, only when you need it. You can specify the fetch mode on a per-query basis, but I'm not clear why you can't use the criteria API. It doesn't relate to FNH. If you have an `ISession` with which to do a LINQ query you can do a criteria query.
      singulars
      1. PO
      1. USJay
    3. COI am choosing this as the answer since eager loading solved about 2/3 of the problem. ICriteria was not available because it was not listed in the custom NHibernate Interface. I added it to the custom NHibernate Interface and that option became available. I was able to solve the problem entirely through using ICriteria. Thanks for giving me the idea to look at it in a different light.
      singulars
      1. PO
      1. USMichael D. Kirkpatrick
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload