Monday, February 13, 2012

Am i going the right way about this

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