Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between connected environment and a
disconnected environment?
- 2 Answers
- 7716 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / neha
Connected:
In connected environment, the connection object is
constantly opened to operate on the databases, and is closed
after all the operation are performed.
Advantages: fast retrieval of data, updated information is
always accessed
Disadvantage: security threats
Disconnected:
In the disconnected environment, the connection object is
opened for the minimum amount of time, that is, the time
when data is retrieved. After the data is retrieved from the
database, the connection is closed, and all the operations
like INSERT, UPDATE, DELETE, etc are performed offline. The
change during the operation can be reflected back to the
database in the similar manner.
Advantage: no security threats, increase in performance as
connection is not constantly opened.
Disadvantage: slow data retrival.
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / pavithra
In connected,an application is constantly connected to data
source.
advantages :
data concurrency is avoided because one user is connected
to a data source and updating data,while another user cant
made changes on data.
In disconnected environment ,application isnt directly
connected to data source.user use connection at once to
retrieve data and connection closed after retreiving.
limitation:
data concurrency.
| Is This Answer Correct ? | 4 Yes | 3 No |
types of Store procedure in Sqlserver2000?
Why is ADO.NET serialization slower than ADO ?
What are the advantages of ado.net?
What is sql connection in ado.net?
Explain executenonquery?
What is data relation in ado.net?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
Describe the disconnected architecture of ADO.NET’s data access model.
Define ado.net?
What is untyped dataset?
When we are running the Application, if any errors occur in the Stored Procedure then how will the server identify the errors?
What is difference between dataset and datatable?
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
