What is nested Classes?
If you create the child class object which constructor will fire first?
In what instances you will declare a constructor to be private?
Can we have different access modifiers on get/set methods of a property?
If we put goto / return statement in try / catch block will the finally code execute?
What is Indexer?
Can we have static indexer in C#?
Chapter 4: ADO.NET
What are the different components in ADO.NET?
What is the namespace in which .NET has the data functionality class?
When should we use System.Data.SqlClient and System.Data.OleDB?
What is difference between dataset and data reader?
What is the use of command objects?
What are Dataset objects?
What is the use of data adapter?
What are basic methods of Data adapter?
How can we fire a simple SQL Statement using ADO?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
How can we force the connection object to close after my data reader is closed?
I want to force the data reader to return only schema of the data store rather than data.
How can we fine-tune the command object when we are expecting a single row?
Which is the best place to store connection string in .NET projects?
How do you fill the dataset?
What are the various methods provided by the dataset object to generate XML?
How can we save all data from dataset?
How can we check that some changes have been made to dataset since it was loaded?
How can we add/remove row is in “Data Table” object of “Dataset”?
What is basic use of “Data View”?
What is the difference between “Dataset” and “Data Reader”?
How can we load multiple tables in a Dataset?
How can we add relation between tables in a Dataset?
What is the use of Command Builder?
What’s difference between “Optimistic” and “Pessimistic” locking?
How many ways are there to implement optimistic locking in ADO.NET?
How can do pessimistic locking?
How can we perform transactions in .NET?
What is difference between Dataset.Clone and Dataset.Copy?
Can you explain the difference between an ADO.NET Dataset and an ADO Record set?
Explain in detail the fundamental of connection pooling?
What is Maximum Pool Size in ADO.NET Connection String?
How to enable and disable connection pooling?
What are themajor differences between classic ADO and ADO.NET?
Chapter 5: ASP.NET
500 Important C# and.NET interview questions asked to C# developers
Start from the beginning
