Inserting rows using TableDirect on indexed tables

Question

When inserting rows using TableDirect access, does anything special need to be done if the table is indexed?  For example, do I need to specify the index name during the insert or position the cursor?

Answer 1

No, nothing special is required if the table is indexed. You can see a sample code pattern here: http://windowsmobiledn.com/sql-compact-edition-insert-performance/ (under 3 - resultset)

---

http://erikej.blogspot.com Erik Ejlskov Jensen - Please mark as answer, if this was it.

Answer 2

yeah... that link doesn't exist anymore.

Answer 3

Look at the source code for http://sqlcebulkcopy.codeplex.com

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog