Pointing to different databases (Test vs production) database perhaps where your data is actually different?
Also when you do one test where you say this is the result from SQL server, and this is the result from Visual studio I don't understand how you are getting these result sets. Are you doing a SQL profiler traces? What is the resulting SQL statements when you turn on logging in nHibernate in one environment from another. What is the table definition look like (add the create table script here so we can look at your keys). Please expand on how you are getting different results, specifically how are you noticing them because you may be comparing apples to oranges here. On Aug 16, 3:27 pm, Kasi <[email protected]> wrote: > Bump. Anybody?! > > On Aug 15, 12:34 am, Kasi <[email protected]> wrote: > > > > > 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>- Hide quoted text - > > - Show quoted text - -- 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.
