I have built a WM5 SQLce2005 application using, primarily, table adapters which sparked a discussion whether it is more effiecent to use table adapters or use SQLce command execution with coding for a device.
Are there any papers / threads or thoughts as to the best access method to use?
The best access method in terms of performance and memory overhead is SQLCeResultset and SQLCEdatareader. There are various performance papers out there, for example: http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032307726&CountryCode=US
No comments:
Post a Comment