Thanks for reply. I appreciate your time and help. My doubt is the ObjectSet.ToList is the way it is supposed to work ? when we prepare sql statement manually to retrieve records we only write once and not one for each record. Secondly the problem in using the fast load "From statement" is it gets back with anonymous type, which is a problem for updating the records back...
-----Original Message----- From: Jiri Cincura [mailto:disk...@cincura.net] Sent: Tuesday, October 04, 2011 3:05 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Entity Framework On Tue, Oct 4, 2011 at 1:25 AM, Muthu Annamalai <muthuannama...@sbcglobal.net> wrote: > When I use ObjectSet.ToList, the provider creates an select statement for > each and every record in the list and it takes forever to load an list of > 10000 records. > > > > But instead if I use like > > “From item in Objectset select item.id, item….” It only creates one single > statement and in blink of an eye it loads all the records. I am also > attaching the SQL statements that is sent by the provider to the database… Because these two statements are not equal. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider