The query (in the code), while running on SQL server returns the
following result.
53 10 _heading Supplier Sustainability
Assessment 101
53 10 _heading FR_SUST 102
54 10 _tabHome Home 101
55 10 _tabQuestionnaire Questionnaire 101
56 10 _tabResults Results 101
57 10 _tabResourcesFAQ Resources & FAQs
101
But while running the code on visual studio returns the first row
twice and instead of the second row -
53 10 _heading Supplier Sustainability
Assessment 101
53 10 _heading Supplier Sustainability
Assessment 101
54 10 _tabHome Home 101
55 10 _tabQuestionnaire Questionnaire 101
56 10 _tabResults Results 101
57 10 _tabResourcesFAQ Resources & FAQs
101
I have no idea as to why.
Code.
private IList<WebpageElement> GetWBById(int id)
{
using (ISession session = NHibernateHelper.OpenSession())
using (ITransaction transaction =
session.BeginTransaction())
{
try
{
string sql = @"
SELECT
web_page_html_element.html_element_id,
web_page_html_element.web_page_id,
html_element.html_element_name,
Html_Element_Text.html_element_txt,
Html_Element_Text.language_code
FROM Web_Page_Html_Element INNER JOIN
Html_Element ON
Web_Page_Html_Element.html_element_id =
Html_Element.html_element_id INNER JOIN
Html_Element_Text ON
Html_Element.html_element_id = Html_Element_Text.html_element_id
WHERE (Web_Page_Html_Element.web_page_id
= :id)";
ISQLQuery query =
(ISQLQuery)session.CreateSQLQuery(sql)
.SetInt32("id", id);
var list =
query.AddEntity(typeof(WebpageElement)).List<WebpageElement>();
return list;
}
finally
{
transaction.Commit();
}
}
}
WebpageElement.CS
public class WebpageElement
{
public virtual int Id { get; set; }
public virtual int WebpageId { get; set; }
public virtual string Name { get; set; }
public virtual string Text { get; set; }
public virtual string LanguageCode { get; set; }
public WebpageElement() { }
}
WebpagElement.hbm.xml
<class name="WebpageElement" table="web_page_html_element">
<id name="Id" column="html_element_id">
<generator class="native"/>
</id>
<property name ="WebpageId">
<column name="web_page_id"></column>
</property>
<join table="html_element">
<key column="html_element_id" />
<property name="Name">
<column name="html_element_name" />
</property>
</join>
<join table="html_element_text">
<key column="html_element_id"/>
<property name="Text">
<column name="html_element_txt" />
</property>
<property name="LanguageCode">
<column name="language_code" />
</property>
</join>
</class>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
