Ado.net

[bobby21]

Hello,
can anybody help me in saying what exactly we use for interacting with database. What i mean is, do we use stored procedures using connection oriented model (or) do we use disconnected model directly in companies......
please somebody help me out....

[techvinny]

Hi...

The choice of using a connected and disconnected data model would depend on situation to situation even within the same app.
While connection oriented approach gives you better performance but there would be a hit on the load of users it could support concurrently.
With the disconnected model, you have the flexibility to work on the data offline and then at some point merge/commit the changes to the database.

HTH!!!

Cheers.