<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" auto-import="false" namespace="Devtoo.Data" assembly="Devtoo.Data">
<class name="Devtoo.Data.Article" table="tblArticle" lazy="false">
<id name="ArticleId" column="ArticleId" unsaved-value="0">
<generator class="identity"></generator>
</id>
<property name="Title"></property>
<property name="SubmitDate"></property>
<property name="Body"></property>
<property name="AuthorId"></property>
<property name="Diggs"></property>
<many-to-one name="Author" class="Devtoo.Data.User" column="AuthorId" insert="false" update="false"></many-to-one>
<many-to-one name="Queue" class="Devtoo.Data.ArticleQueue"></many-to-one>
<bag name="Comments" generic="true">
<key column="ArticleId"></key>
<one-to-many class="Devtoo.Data.ArticleComment"></one-to-many>
</bag>
</class>
</hibernate-mapping>


<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" auto-import="false" namespace="Devtoo.Data" assembly="Devtoo.Data">
<class name="Devtoo.Data.ArticleQueue" table="tblArticleQueue" lazy="false">
<id name="ArticleQueueId" column="ArticleQueueId" unsaved-value="0">
<generator class="identity"></generator>
</id>
<property name="ArticleId"></property>
<property name="ApprovedDate"></property>
<property name="EditorId"></property>
</class>
</hibernate-mapping>

[Serializable]
public class Article
{
private int articleId;
public int ArticleId
{
get { return articleId; }
set { articleId = value; }
}
private string title;
public string Title
{
get { return title; }
set { title = value; }
}
private DateTime submitDate;
public DateTime SubmitDate
{
get { return submitDate; }
set { submitDate = value; }
}
private string body;
public string Body
{
get { return body; }
set { body = value; }
}
private ArticleQueue queue;
public ArticleQueue Queue
{
get { return queue; }
set { queue = value; }
}
private Guid authorId;
public Guid AuthorId
{
get { return authorId; }
set { authorId = value; }
}
private int diggs;
public int Diggs
{
get { return diggs; }
set { diggs = value; }
}
private IList<ArticleComment> comments;
public IList<ArticleComment> Comments
{
get { return comments; }
set { comments = value; }
}
private User author;
public User Author
{
get { return author; }
set { author = value; }
}
public Article() { }
}



and i'm doing the following query:
public static IList GetLatestArticles(int amount)
{
IQuery iquery = DatabaseFactory.Session.CreateQuery(String.Format(@"SELECT TOP {0} a FROM Article a INNER JOIN a.Queue", amount));
return iquery.List();
}


and i'm getting the error:
NHibernate.ADOException : could not load an entity: [Data.Article#1] Invalid column name 'Queue'

Can you successfully load a Queue object on it's own?

your m-1 definition for Queue is missing the column name so NH is assuming the column is the same as the property. I suspect your table uses QueueID instead:



or whatever the column name in your tblArticle table that relates to tblArticleQueue.