Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is main five diffrent between Connected And
Disconnected environment

Answer Posted / neha

1.Connected: It works when connection object is opened.
Disconnected: It works regardless of the connection object
state (opened or closed doesnot matter).

2.Connected: It can retrieve data from single table only.
Disconnected: It can retrive data from multiple tables.

3.Connected: The data persists even after the shutdown of
application.
Disconnected: The data doesnot persist after the application
closure, as it was all programmatic.

4.Connected: We get the updated data always.
Disconnected: The data we retrieve is not guaranteed to be
updated.

5.Connected: Fast access to the data.
Disconnected: Slow access to data.

6.Connected: It is useful in the scenarios where data is
updated rapidly, for eg, stock market.
Disconnected: It is useful in the scenarios where data is
not updated usually, for eg, school database, where data is
changed after one year only.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is ado.net dead?

1015


How would you connect to a database by using .NET?

942


Give few examples of datareader that is used in different dataproviders.

981


Define executenonquery?

919


What is an orm, and why would you use one instead of plain old ado.net?

1052


Explain ado.net features? Benefits? Drawbacks?

1053


Can you explain how to enable and disable connection pooling?

966


What are the important features of ado.net 2.0?

1076


Explain all the classes those are used for database connections between sql server and asp.net?

1010


What connected data?

966


What do you mean by ‘batch updates’?

1046


What is the difference between executenonquery () and executescalar ()?

957


What is row state?

988


Which parameter of ConnectionString is used to specify the name of the database?

1061


How to copy the contents from one table to another table and how to delete the source table in ado.net?

1039