TheWheel wrote:
Geographic data format (GDF) is used primarily for navigation systems. I was wondering if anyone was familiar with this format and if I can use either DTS or SSIS to import the GDF flat files into SQL?
Is the GDF file comma separated? Tab delimited?
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