Hi,
Im building an application in vb.net 05 and mobile sql. When i added the mobile database in visual studio it added a Dataset object in the object viewer.
Now my question is should i add table adapters to this and do my selects inserts updates and deletes using this, or should i us the sqlceclient class connect to the db use a command object ect and do my operations?
I need it to be as fast as possible and 100 reliable.
Can anyone give me a clue as to the best way forward?
Trev
The automatic creating of bindingsource and datasource datasets is a convenience in VS2005 and you can certainly do most of your interaction with SQL Mobile using this approach. If you want finer-grained control over your interaction with SQL Mobile (for performance tuning for example), then I wouldn't use the auto-generated bindings and instead use SqlCeResultSet, SqlCeDataReader, and SqlCeCommands in TableDirect mode to perform your database operations when possible.
Darren
No comments:
Post a Comment