Reply to thread

Message

[CODE] public IList<TuningDetail> ReferringTuningDetail()
{
//select * from 'foreigntable'
SqlBuilder sb = new SqlBuilder(StatementType.Select, typeof (TuningDetail));

// where foreigntable.foreignkey = ourprimarykey
sb.AddConstraint(Operator.Equals, "idChannel", idChannel);

// passing true indicates that we'd like a list of elements, i.e. that no primary key
// constraints from the type being retrieved should be added to the statement
SqlStatement stmt = sb.GetStatement(true);

// execute the statement/query and create a collection of User instances from the result set
return ObjectFactory.GetCollection<TuningDetail>(stmt.Execute());

// TODO In the end, a GentleList should be returned instead of an arraylist
//return new GentleList( typeof(TuningDetail), this );
}[/CODE]
this code is really like "select * from TuningDetails where idChannel = :idChannel". there is anyway only one record can be returned. So we need to ask e.g. "select * from TuningDetails where isTV = true" once, put the result in a dictionary, and then ask dictionary when filling listviews - i believe dictionary search in memory is faster than thousands of sql queries...

<blockquote data-quote="Vasilich" data-source="post: 762938" data-attributes="member: 97516">[CODE]&nbsp; &nbsp; public IList&lt;TuningDetail&gt; ReferringTuningDetail()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; //select * from 'foreigntable'&nbsp; &nbsp; &nbsp; SqlBuilder sb = new SqlBuilder(StatementType.Select, typeof (TuningDetail));&nbsp; &nbsp; &nbsp; // where foreigntable.foreignkey = ourprimarykey&nbsp; &nbsp; &nbsp; sb.AddConstraint(Operator.Equals, &quot;idChannel&quot;, idChannel);&nbsp; &nbsp; &nbsp; // passing true indicates that we'd like a list of elements, i.e. that no primary key&nbsp; &nbsp; &nbsp; // constraints from the type being retrieved should be added to the statement&nbsp; &nbsp; &nbsp; SqlStatement stmt = sb.GetStatement(true);&nbsp; &nbsp; &nbsp; // execute the statement/query and create a collection of User instances from the result set&nbsp; &nbsp; &nbsp; return ObjectFactory.GetCollection&lt;TuningDetail&gt;(stmt.Execute());&nbsp; &nbsp; &nbsp; // TODO In the end, a GentleList should be returned instead of an arraylist&nbsp; &nbsp; &nbsp; //return new GentleList( typeof(TuningDetail), this );&nbsp; &nbsp; }[/CODE]this code is really like &quot;select * from TuningDetails where idChannel = :idChannel&quot;. there is anyway only one record can be returned. So we need to ask&nbsp; e.g. &quot;select * from TuningDetails where isTV = true&quot; once, put the result in a dictionary, and then ask dictionary when filling listviews - i believe dictionary search in memory is faster than thousands of sql queries...</blockquote>

[QUOTE="Vasilich, post: 762938, member: 97516"] [CODE] public IList<TuningDetail> ReferringTuningDetail() { //select * from 'foreigntable' SqlBuilder sb = new SqlBuilder(StatementType.Select, typeof (TuningDetail)); // where foreigntable.foreignkey = ourprimarykey sb.AddConstraint(Operator.Equals, "idChannel", idChannel); // passing true indicates that we'd like a list of elements, i.e. that no primary key // constraints from the type being retrieved should be added to the statement SqlStatement stmt = sb.GetStatement(true); // execute the statement/query and create a collection of User instances from the result set return ObjectFactory.GetCollection<TuningDetail>(stmt.Execute()); // TODO In the end, a GentleList should be returned instead of an arraylist //return new GentleList( typeof(TuningDetail), this ); }[/CODE] this code is really like "select * from TuningDetails where idChannel = :idChannel". there is anyway only one record can be returned. So we need to ask e.g. "select * from TuningDetails where isTV = true" once, put the result in a dictionary, and then ask dictionary when filling listviews - i believe dictionary search in memory is faster than thousands of sql queries... [/QUOTE]