| |
ADO.NET interview questions: - What are basic methods of Data adapter and mention the use of data adapter?
There are three most commonly used
methods of Data adapter: - Fill: - Exe
|
ADO.NET interview questions: - How can we fire a simple SQL Statement using ADO.NET?
First imports the namespace “System.Data.SqlClient”. Create a connection object and call the “O
|
ADO.NET interview questions: - Show difference between “Optimistic” and “Pessimistic” locking and how many ways are there to implement optimistic locking in ADO.NET?
In optimistic locking there is no locking actually. It only checks if the old values are changed, in
|
ADO.NET Interview Questions: - What are basic methods of Data adapter?
There are three most commonly used methods of Data adapter:- Fill: - Executes the Select Command
|
ADO.NET Interview Question: - What are the major differences between classic ADO and ADO.NET?
ollowing are some major differences between both :- In ADO we have recordset and in ADO.NET
|
ADO.NET interview questions: - What are the various ways to implement optimistic locking in ADO.NET?
Following are the ways to implement optimistic locking using ADO.NET:-
When we call “Update” method of Data Adapter it handles locking internally. If the Dataset values are not matching with current data in Database, it raises concurrency exception error. We can easily trap this error using Try. Catch block and raise appropriate error message to the user.
Define a Date time stamp field in the table. When actually you are firing the UPDATE SQL statements, compare the current timesta
|