Overblog Follow this blog
Edit post Administration Create my blog
October 29 2010 6 29 /10 /October /2010 18:55

Get Interview tutorials and videos on .NET 3.5, 4.0, ADO.NET, SQL Server, CAS, Security, WCF, SharePoint, Azure, OOPS and many more on www.questpond.com

 


(B) How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

(B) How can we force the connection object to close after my data reader is closed?

(B) I want to force the data reader to return only schema of the data store rather than data.

(B) How can we fine-tune the command object when we are expecting a single row?

(B)What are the various methods provided by the dataset object to generate XML?

(B) How can we save all data from dataset?

(B) How can we check that some changes have been made to dataset since it was loaded?

(B) How can we add/remove row is in “Data Table” object of “Dataset”?

(B) What is basic use of “Data View”?

(B) What is the difference between “Dataset” and “Data Reader” ?

(B) How can we load multiple tables in a Dataset?

(B) How can we add relation between tables in a Dataset?

(B) What is the use of Command Builder?

(B) What’s difference between “Optimistic” and “Pessimistic” locking ?

(A) How many ways are there to implement locking in ADO.NET?

(A)How can we perform transactions in .NET?

(I) What is difference between Dataset? Clone and Dataset. Copy?

(A) Can you explain the difference between an ADO.NET Dataset and an ADO Record set?

(A) Explain in detail the fundamental of connection pooling?

(A)What is Maximum Pool Size in ADO.NET Connection String?

(A)How to enable and disable connection pooling?

(I) What extra features does ADO.Net 2.0 have ?

Introduction

 

In this section we will touch base on one of important concepts in ADO.Net. You can download my .NET Interview Question PDF from http://www.questpond.com/SampleDotNetInterviewQuestionBook.zip .

I have also put all these design patterns in a video format and uploaded on http://www.questpond.com/FreeDesign1.htm . You can visit http://www.questpond.com and download the complete architecture interview questions PDF which covers SOA , UML , Design patterns , Togaf , OOPs etc.

Happy job hunting......

(B) How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?


ADO.NET provides the SqlCommand object, which provides the functionality of executing stored procedures.

Note :- Sample code is provided in folder “WindowsSqlClientCommand”. There are two stored procedures created in same database “Employees” which was created for the previous question.


CREATE PROCEDURE SelectByEmployee @FirstName nvarchar(200) AS
Select FirstName from Employees where FirstName like @FirstName + '%'
CREATE PROCEDURE SelectEmployee AS
Select FirstName from Employees

If txtEmployeeName.Text.Length = 0 Then
objCommand = New SqlCommand(“SelectEmployee”)
Else
objCommand = New SqlCommand(“SelectByEmployee”)
objCommand.Parameters.Add(“@FirstName”, Data.SqlDbType.NVarChar, 200)
objCommand.Parameters.Item(“@FirstName”).Value = txtEmployeeName.Text.Trim()
End If

 In the above sample, not much has been changed only that the SQL is moved to the stored procedures. There are two stored procedures one is “Select Employee” which selects all the employees and the other is “SelectByEmployee” which returns employee name starting with a specific character. As you can see to provide parameters to the stored procedures, we are using the parameter object of the command object. In such question interviewer expects two simple answers one is that we use command object to execute stored procedures and the parameter object to provide parameter to the stored procedure. Above sample is provided only for getting the actual feel of it. Be short be nice and get a job.

(B) How can we force the connection object to close after my data reader is closed?


Command method Execute reader takes a parameter called as Command Behavior where in we can specify saying close connection automatically after the Data reader is close.

PobjDataReader = pobjCommand.ExecuteReader (CommandBehavior.CloseConnection)

(B) I want to force the data reader to return only schema of the data store rather than data.


PobjDataReader = pobjCommand.ExecuteReader (CommandBehavior.SchemaOnly)

(B) How can we fine-tune the command object when we are expecting a single row?


Again, CommandBehaviour enumeration provides two values Single Result and Single Row. If you are expecting a single value then pass “CommandBehaviour.SingleResult” and the query is optimized accordingly, if you are expecting single row then pass “CommandBehaviour.SingleRow” and query is optimized according to single row.

(B) Which is the best place to store connection string in .NET projects?


Config files are the best places to store connection strings. If it is a web-based application “Web.config” file will be used and if it is a windows application “App.config” files will be used.

(B) What are the steps involved to fill a dataset?


Twist: - How can we use data adapter to fill a dataset?

Sample code is provided in “WindowsDataSetSample” folder in CD.”LoadData” has all the implementation of connecting and loading to dataset. This dataset is finally bind to a List Box. Below is the sample code.


Private Sub LoadData()
Dim strConnectionString As String
strConnectionString = AppSettings.Item(“ConnectionString”)
Dim objConn As New SqlConnection(strConnectionString)
objConn.Open()
Dim objCommand As New SqlCommand(“Select FirstName from Employees”)
objCommand.Connection = objConn
Dim objDataAdapter As New SqlDataAdapter()
objDataAdapter.SelectCommand = objCommand
Dim objDataSet As New DataSet
End Sub


In such type of questions interviewer is looking from practical angle, that have you worked with dataset and datadapters. Let me try to explain the above code first and then we move to what steps should be told during interview.

Dim objConn As New SqlConnection(strConnectionString)
objConn.Open()

 First step is to open the connection. Again, note the connection string is loaded from config file.

Dim objCommand As New SqlCommand(“Select FirstName from Employees”)
objCommand.Connection = objConn


Second step is to create a command object with appropriate SQL and set the connection object to this command.

Dim objDataAdapter As New SqlDataAdapter()
objDataAdapter.SelectCommand = objCommand


Third steps is to create the Adapter object and pass the command object to the adapter object.

objDataAdapter.Fill(objDataSet)

 Fourth step is to load the dataset using the “Fill” method of the data adapter.

lstData.DataSource = objDataSet.Tables(0).DefaultView
lstData.DisplayMember = “FirstName”
lstData.ValueMember = “FirstName”


Fifth step is to bind to the loaded dataset with the GUI. At this moment sample has list box as the UI. Binding of the UI is done by using Default View of the dataset. Just to revise every dataset has tables and every table has views. In this sample, we have only loaded one table i.e. Employees table so we are referring that with an index of zero.
Just say all the five steps during interview and you will see the smile on the interviewer’s face and appointment letter in your hand.

(B)What are the various methods provided by the dataset object to generate XML?


Note:- XML is one of the most important leap between classic ADO and ADO.NET. So this question is normally asked more generally how can we convert any data to XML format. Best answer is convert in to dataset and use the below methods.

• ReadXML
Read’s a XML document in to Dataset.
• GetXML
This is a function, which returns the string containing XML document.
• Writexml
This writes a XML data to disk.

(B) How can we save all data from dataset?


Dataset has “Accept Changes” method, which commits all the changes since last time “Accept changes” has been executed.

Note :- This book does not have any sample of Acceptchanges. We leave that to readers as homework sample. But yes from interview aspect that will be enough.

(B) How can we check that some changes have been made to dataset since it was loaded?


Twist: - How can we cancel all changes done in dataset?

Twist: - How do we get values, which are changed, in a dataset?

For tracking down changes, Dataset has two methods, which comes as rescue “Get Changes “and “Has Changes”.
Get Changes


Returns dataset, which are changed since it, was loaded, or since Accept changes was executed.
Has Changes

Or abandon all changes since the dataset was loaded use “Reject Changes This property indicates that has any changes been made since the dataset was loaded or accept changes method was executed.
Note:- One of the most misunderstood things about these properties is that it tracks the changes of actual database. That is a fundamental mistake; actually the changes are related to only changes with dataset and have nothing to with changes happening in actual database. As dataset are disconnected and do not know anything about the changes happening in actual database.

(B) How can we add/remove row is in “Data Table” object of “Dataset”?


“Data table” provides “NewRow” method to add new row to “Data Table”. “Data Table” has “DataRowCollection” object that has all rows in a “Data Table” object. Following are the methods provided by “DataRowCollection” object:-

Add

Adds a new row in Data Table
Remove

It removes a “Data Row” object from “Data Table”
Remove At

It removes a “Data Row” object from “Data Table” depending on index position of the “Data Table”.

(B) What is basic use of “Data View”?


“Data View” represents a complete table or can be small section of rows depending on some criteria. It is best used for sorting and finding data with in “data table”.
Data view has the following methods:-
Find

It takes an array of values and returns the index of the row.
Find Row

This also takes array of values but returns a collection of “Data Row”.
If we want to manipulate data of “Data Table” object create “Data View” (Using the “Default View” we can create “Data View” object) of the “Data Table” object and use the following functionalities:-
Add New

Adds a new row to the “Data View” object.
Delete

Deletes the specified row from “Data View” object.

(B) What is the difference between “Dataset” and “Data Reader” ?


Twist: - Why is Dataset slower than Data Reader is?Fourth point is the answer to the twist.

Note:- This is my best question and we expect everyone to answer it. It is asked almost 99% in all companies....Basic very Basic cram it.

Following are the major differences between “Dataset” and “Data Reader”:-
• “Dataset” is a disconnected architecture, while “Data Reader” has live connection while reading data. If we want to cache data and pass to a different tier “Dataset” forms the best choice and it has decent XML support.

• When application needs to access data from more than one table “Dataset” forms the best choice.

• If we need to move back while reading records, “data reader” does not support this functionality.

• However, one of the biggest drawbacks of Dataset is speed. As “Dataset” carry considerable overhead because of relations, multiple table’s etc speed is slower than “Data Reader”. Always try to use “Data Reader” wherever possible, as it is meant especially for speed performance.

(B) How can we load multiple tables in a Dataset?


objCommand.CommandText = "Table1"
objDataAdapter.Fill(objDataSet, "Table1")
objCommand.CommandText = "Table2"
objDataAdapter.Fill(objDataSet, "Table2")

Above is a sample code, which shows how to load multiple “Data Table” objects in one “Dataset” object. Sample code shows two tables “Table1” and “Table2” in object ObjDataSet.

lstdata.DataSource = objDataSet.Tables("Table1").DefaultView
In order to refer “Table1” Data Table, use Tables collection of Datasets and the Default view object will give you the necessary output.

(B) How can we add relation between tables in a Dataset?


Dim objRelation As DataRelation
objRelation=New
DataRelation("CustomerAddresses",objDataSet.Tables("Customer").Columns("Custid")
,objDataSet.Tables("Addresses").Columns("Custid_fk"))
objDataSet.Relations.Add(objRelation)

Relations can be added between “Data Table” objects using the “Data Relation” object. Above sample, code is trying to build a relationship between “Customer” and “Addresses” “Data table” using “Customer Addresses” “Data Relation” object.

(B) What is the use of Command Builder?


Command Builder builds “Parameter” objects automatically. Below is a simple code, which uses command builder to load its parameter objects.

Dim pobjCommandBuilder As New OleDbCommandBuilder(pobjDataAdapter)
pobjCommandBuilder.DeriveParameters(pobjCommand)

Be careful while using “Derive Parameters” method as it needs an extra trip to the Data store, which can be very inefficient

(B) What’s difference between “Optimistic” and “Pessimistic” locking ?


In pessimistic locking when user wants to update data it locks the record and till then no one can update data. Other user’s can only view the data when there is pessimistic locking.
In optimistic locking multiple users can open the same record for updating, thus increase maximum concurrency. Record is only locked when updating the record. This is the most preferred way of locking practically. Now a days in browser based application it is very common and having pessimistic locking is not a practical solution.

(A) How many ways are there to implement locking in ADO.NET?


Following are the ways to implement 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 timestamp with one existing in the database. Below is a sample SQL which checks for timestamp before updating and any mismatch in timestamp it will not update the records. This I the best practice used by industries for locking.

Update table1 set field1=@test where Last Timestamp=@Current Timestamp

• Check for original values stored in SQL SERVER and actual changed values. In stored procedure check before updating that the old data is same as the current Example in the below shown SQL before updating field1 we check that is the old field1 value same. If not then some one else has updated and necessary action has to be taken.

Update table1 set field1=@test where field1 = @oldfield1value
Locking can be handled at ADO.NET side or at SQL SERVER side i.e. in stored procedures. For more details of how to implementing locking in SQL SERVER read “What are different locks in SQL SERVER?” in SQL SERVER chapter.

(A)How can we perform transactions in .NET?


The most common sequence of steps that would be performed while developing a transactional application is as follows:

• Open a database connection using the Open method of the connection object.
• Begin a transaction using the Begin Transaction method of the connection object. This method provides us with a transaction object that we will use later to commit or rollback the transaction. Note that changes caused by any queries executed before calling the Begin Transaction method will be committed to the database immediately after they execute. Set the Transaction property of the command object to the above mentioned transaction object.
• Execute the SQL commands using the command object. We may use oneormorecommand objects for this purpose, as long as the Transaction property of all the objects is set to a valid transaction object.
• Commit or roll back the transaction using the Commit or Rollback method of the transaction object.
• Close the database connection.

(I) What is difference between Dataset? Clone and Dataset. Copy?


Clone: - It only copies structure, does not copy data.
Copy: - Copies both structure and data.

(A) Can you explain the difference between an ADO.NET Dataset and an ADO Record set?


There two main basic differences between record set and dataset:-
• With dataset you an retrieve data from two databases like oracle and sql server and merge them in one dataset , with record set this is not possible
• All representation of Dataset is using XML while record set uses COM.
• Record set cannot be transmitted on HTTP while Dataset can be.

(A) Explain in detail the fundamental of connection pooling?


When a connection is opened first time, a connection pool is created and is based on the exact match of the connection string given to create the connection object. Connection pooling only works if the connection string is the same. If the connection string is different, then a new connection will be opened, and connection pooling will not be used.

Figure 9.5: - Connection Pooling action.

Let us try to explain the same pictorially. In the above figure, you can see there are three requests “Request1”, “Request2”, and “Request3”. “Request1” and “Request3” have same connection string so no new connection object is created for “Request3” as the connection string is same. They share the same object “ConObject1”. However, new object “ConObject2” is created for “Request2” as the connection string is different.

Note: - The difference between the connection string is that one has “User id=sa” and other has “User id=Testing”.

(A)What is Maximum Pool Size in ADO.NET Connection String?


Maximum pool size decides the maximum number of connection objects to be pooled. If the maximum pool size is reached and there is no usable connection available the request is queued until connections are released back in to pool. So it’s always a good habit to call the close or dispose method of the connection as soon as you have finished work with the connection object.

(A)How to enable and disable connection pooling?


For .NET it is enabled by default but if you want to just make sure set Pooling=true in the connection string. To disable connection pooling set Pooling=false in connection string if it is an ADO.NET Connection. If it is an OLEDBConnection object set OLE DB Services=-4 in the connection string.

(I) What extra features does ADO.Net 2.0 have ?


Bulk Copy Operation
Bulk copying of data from a data source to another data source is a newly added feature in ADO.NET 2.0. ADO.NET inrtoduces bulk copy classes which provide fastest way to transfer\ data from once source to the other. Each ADO.NET data provider has bulk copy classes. For example, in SQL .NET data provider, the bulk copy operation is handled by SqlBulkCopy class, which can read a DataSet, DataTable, DataReader, or XML objects.
Data Paging
A new method is introduced ExecutePageReader which takes three parameters - CommandBehavior, startIndex, and pageSize. So if you want to get rows ony from 10 - 20, you can simply call this method with start index as 10 and page size as 10.
Batch Update
If you want to update large number of data on set ADO.NET 2.0 provides UpdateBatchSize property, which allows you to set number of rows to be updated in a batch. This increases the performance dramatically as round trip to the server is minimized.
Load and Save Methods
In previous version of ADO.NET, only DataSet had Load and Save methods. The Load method can load data from objects such as XML into a DataSet object and Save method saves the data to a persistent media. Now DataTable also supports these two methods. You can also load a DataReader object into a DataTable by using the Load method.
New Data Controls
In toolbox you can see three new controls - DataGridView, DataConnector, and DataNavigator.
DataReader's New Execute Methods
Some new execute methods introduced are ExecutePageReader, ExecuteResultSet, and ExecuteRow.

Other Interview question PDF's

.NET Interview Question PDF

 

Project Management interview questions

Download Networking Interview Questions

Download Software Testing Interview Questions

Download Sql Server Interview Questions

Download C# and ASP .Net Projects

Download Java Interview Questions

Download Software Architecture Interview Questions

Download Excel Question and Answers

 

Share this post

Repost 0
Published by questpond.over-blog.com
write a comment

comments

Important .NET and C# interview questions and answers

.Net interview questions: - Explain why it is not preferred to use finalize for clean up?

.Net interview questions: - Show the five levels in CMMI?

.NET interview questions and answers: – Which is the best place to store connection string in .NET projects?

C# interview questions and answers: – Explain the use of Icomparable in c#?

C# interview questions: - How can we check which rows have changed since dataset was loaded?

C# interview questions and answers: - Can you write a simple c# code to display Fibonacci series?

.NET interview questions and answers: - What is difference betweenIcomparable VS Icomparer ?

C# and .NET interview question: -What is short circuiting in C#?

C# and .NET interview question: - What are symmetric and asymmetric algorithms?

Important c# and .NET interview question on object pooling and Gridview events?

.NETinterview questions and answers: – Will the finally run in this code?

How to prepare for c# and .NETinterviews?

C# and .NET Interview questions: - What is Thread.Join () in threading?

.NET Interview questions and answers: -What is serialization and deserialization in .NET?

C# and .NET interview question: - What is hashing?

c# and .NET interview question:- what connects dataset and data source ?

.Net interview questions and answers: - What is the difference between “Web.config” and “Machine.Config”?

.NET interview questions and answers: - What is TPL?

.NET Interview questions and answers: -What are different access modifiers?

.NET and c# Interview Question and answers: – If we want to update interface with new methods, what is the best practice?

 MVC ( Model view controller) interview questions and answers      

ASP.NET Application and Page Life Cycle 

12 Important FAQ’s on VSTS Testing (Unit testing, load testing, automated testing, database testing and code coverage) 

 6 important use of Partial/Mock testing

6 important uses of Delegates and Events

7 Simple Steps to Run Your First Azure Blob Program

8 Steps to Create Workflows using SharePoint Designer

Azure FAQ Part 1

C# Code Reviews using StyleCop – Detailed Article

Four real world uses of Partial classes and Partial methods

SharePoint Quick Start FAQ Part 1

SharePoint Quick Start FAQ Part 6 – Workflows, Workflows and Workflows

SharePoint Workflow Basics

 

 

 

 

MVC Interview questions videos

Viewdata,viewbag,tempdata

 

MVC asynch controllers

What is View Model in ASP.NET MVC?



ADO.NET interview questions videos



Explain ADO.NET Connection pooling

 

 

Windows Phone Application Questions Videos

 

How to create a simple windows phone application ?

 

 

MVC Interview questions and answers Article

 

(Model view controller)MVC Interview questions and answers

MVC interview questions with answers video: – What is Web API how to implement the same?

ASP.Net MVC  4 interview questions with answers: - What is Bundling and minification in Model view controller ?

MVC interview questions with answers :- Is it possible to return values instead of Actionresults?

MVC interview questions with answers :- What are the actionresults available in MVC?

MVC interview questions with answers:-Html.PartialvsHtml.RenderPartialvsHtml.RenderPage in MVC

MVC ASP.NET INTERVIEW QUESTIONS WITH ANSWERS :- WHAT IS THE DIFFERENCE BETWEEN VIEWSTATE VS VIEWDATA ?

MVC vs ASP.NET ( MVC Interview question with answers )?

How can we detect that a MVC controller is called by POST or GET ? ( ASP.NET MVC Interview questions with answers)

What are the different ways by which you will get Form Data in controller? ( MVC Interview questions with answers)

What is the difference between Presenter and Controller in MVC?(MVC interview questions with answers)

Learn MVC (Model view controller) Step by Step in 7 days – Day 4

MVC Interview questions and answers PDF

MVC interview questions with answers

ActionResult vs. View() vs. ViewResult :- MVC interview questions with answers

Explain Areas in MVC?( MVC interview questions with answers)

Can you explain the purpose of ViewModel in MVC?( ASP.NET MVC Interview questions with answers)

ASP.NET MVC interview questions: - What are Filters in MVC?

What are areas in MVC?( MVC Interview questions with answers)

Explain the concept of View Model in MVC?

Exception Handling in MVC

Explain MVC application life cycle?


100 MVC Interview question PDF download released , Enjoy


Learn Microsoft Business intelligence step by step – Day 1


Can you create TempBag just like ViewBag?( MVC Interview questions)


MVC Unit Testing Unleashed

MVC and .NET learning tutorials for components of MVC and how do you perform unit testing in MVC?

Explain MVC model binders ? ( ASP.NET MVC interview questions)

Explain the difference between layout and master pages ? (MVC Razor interview questions)

Advantages of ViewModel in MVC(Model View Controller)

Difference Between ViewResult() and ActionResult() in MVC ?

What is the difference between each version of MVC 2, 3, 4, 5 and 6? (MVC Interview Questions)

Learn ASP.NET MVC 5 Step by Step in 30 days – Day 1

Can we overload MVC controller action methods ? (MVC Polymorphism) 

Can we overload Actions / Controllers in MVC? (MVC Interview questions)

 


WCF Interview questions videos

 

overloading in WCF

WCF fault exceptions ?

 

 

 

 

WPF Interview question with answers videos

 

Why WPF and compare WPF with Winforms ?

 

 

C# Interview Questions & Answers Article

 

12 Important FAQ’s on VSTS Testing (Unit testing, load testing, automated testing, database testing and code coverage)

6 important use of Partial/Mock testing

6 important uses of Delegates and Events

7 Simple Steps to Run Your First Azure Blob Program

8 Steps to Create Workflows using SharePoint Designer

Azure FAQ Part 1

C# Code Reviews using StyleCop – Detailed Article

Four real world uses of Partial classes and Partial methods

SharePoint Quick Start FAQ Part 1

SharePoint Quick Start FAQ Part 6 – Workflows, Workflows and Workflows

SharePoint Workflow Basics

C# (Csharp) interview questions and answers: – What are indexers in .NET?

C# OOP interview questions and answers: - I do not want to implement all the interface methods?

C# design pattern (UNIT of Work Design Pattern)

C# design pattern interview questions – What is Dependency injection ?

C# interview questions and answers: - What is the difference between “==” and .Equals()?

How questions are asked in c# interviews?

C# design pattern interview question: - DI vs IOC

8 important C# Interview questions on IL code, JIT, CLR, CTS, CLS and CAS

What is the difference between Reflection and Dynamic in C#?

C# and .NET interview question: – When should we use Structure as compared to classes
?

C# REST interview questions with answers asked in Polaris Hydrebad

c# threading interview questions :- Parallel.ForEach vs Task.Factory.StartNew

C# circular dependency interview questions with answers.

C# Design pattern interview questions with answers: - How Singleton is different from Static class?

C# and .NET interview questions with answers: - How can we mark a method as deprecated?

C# INTERVIEW QUESTIONS WITH ANSWERS: - HOW TO ASSIGN MULTILINE STRING IN VISUAL STUDIO?

What is cyclomatic complexity (C# testing interview questions with answers)?

Define code coverage? (C# unit testing interview questions with answers)

Can you talk about Abstraction and Encapsulation in detail ? ( .NET, c# and OOP interview questions with answers )

Can you explain a practical example of virtual and Override? ( C# OOP interview questions with answers )

Can you explain class and object in real time scenario? ( C# and .NET OOP Interview questions with answers)

What is code digger ? ( C# visual studio interview questions with answers)

C# Lazy loading interview questions with answers

What is eager loading in c# ( C# eager loading interview questions with answers)?

Can you explain the term concurrency? (C# Interview questions with answers)

10 important C# Constructor and destructor interview questions

3 important c# Partial class interview questions with answers

Change Functionality without changing function( C# Architecture interview question with answers)?

What is ENUM and what are the benefits of using it (ENUM C# Interview Question 1)?

How can we loop through ENUM values( C# ENUM Interview questions with answers)?

What is the difference between Connection Timeout and Command Timeout?( C# ADO.NET Interview questions with answers)

How you differentiate Shadowing with Overriding? (C# overriding interview questions)

C# date and time interview question with answers

Explain the difference between early binding and late binding? ( C# interview questions with answers)

How can we restrict types in generics ?( C# generic interview questions)

What are generics, Delegates and Generic delegates ( C# interview questions)?

How can we convert JSON string in to c# object?(  C# JSON interview questions)

C# and .NET interview questions asked in TCSwalkin.

C# and .NET interview questions on Coalescing operator.

String vs string ( C# interview questions with answers)

Explain SOLID principles (C# Architecture interview questions)?

C# and .NET interview questions around Read only and Constant

C# Architecture interview questions with answers

C# Mock testing interview questions and answers: – What is Mock testing and how can we implement Mocking?

Write a simple regex for email validation? (C# interview questions with answers)


C#.NET interview questions: - What is the use of “Yield” keyword? Mention atleast one practical scenario where it can be used?

C#.NET interview questions: - What is the difference between Build Vs Rebuild Vs Clean solution menu? What is the difference “Rebuild” and if you do “Clean” + “Build”?

C# and .NET interview questions around JIT and NGEN


What is the difference between throw vs throw ex ?( C# Interview questions with answers)

C#/.NET interview questions: - What are the steps included to get a collection of records from database in C#?


Learn C# in Hindi video tutorials


QuestPond’s real life examples on Extension methods and nullable types in C#.NET


Why Microsoft has partial classes and Java does not?

 

 

 

WCF INTERVIEW QUESTIONS AND ANSWERS ARTICLE

 

 

WCF INTERVIEW QUESTIONS AND ANSWERS: - WHAT IS THE DIFFERENCE BETWEEN SERVICE ENDPOINT AND CLIENT ENDPOINT

 

WCF INTERVIEW QUESTIONS WITH ANSWERS: - WCF REST VS. WEB API

 

WCF INTERVIEW QUESTIONS WITH ANSWERS :- CAN WE HAVE METHOD OVERLOADING WHILE DEFINING WCF SERVICE OPERATIONS ?

 

WCF INTERVIEW QUESTIONS WITH ANSWERS :- WHAT IS DATACONTRACTSERIALIZER AND HOW IT’S DIFFERENT FROM XMLSERIALIZER 

What is SOA and what is WCF? ( WCF interview questions with answers)

Six important WCF interview questions with answers

6 important WCF Instancing interview questions with answers

WCF Service metadata interview questions with answers

7 WCF SOA interview questions with answers

What are the various ways of consuming WCF services?(WCF C# interview questions with answers)

What is the difference between Serialization and Encoding in WCF?( WCF interview questions with answers)

Why returning dataset or data table from WCF service is not a good practice?(WCF service interview questions with answers)

WCF transaction interview questions: - How transaction works in WCF?

WCF Transaction interview questions.

.NET WCF(Windows Communication Foundation) interview questions: - Distinguish between Web Services and Remoting | WCF and Web services

WCF interview questions: - What exactly do you mean by Single in WCF instancing? How to set and what is by default set value of instance context mode?

Explain WCF Duplex services? ( WCF Interview questions)

QuestPond: Interview Questions and Answers on learning WCF

WCF Interview Questions: - What are the different ways of doing WCF concurrency and WCF instancing?

QuestPond: Interview Questions and Answers on learning WCF (Windows Communication Foundation)

QuestPond: Interview Questions and Answers on learning WCF (Windows Communication Foundation)

QuestPond: Interview Questions and Answers on WCF(Windows Communication Foundation)

QuestPond: Interview Questions and Answers on learning WCF (Windows Communication Foundation)

QuestPond’s Interview Questions & Answers on learning data contract serializer and XML serializer

QuestPond’s Interview Questions & Answers on learning serialization events

QuestPond’s Interview Questions & Answers on learning WCF(Windows Communication Foundation)

QuestPond’s Interview Questions & Answers on WCF(Windows Communication Foundation)


QuestPond’s Interview Questions & Answers on WCF(Windows Communication Foundation)

QuestPond’s Interview Questions & Answers on WCF (Windows Communication Foundation)


QuestPond’s Interview Questions & Answers on WCF (Windows Communication Foundation)

 

 

 

WPF Interview Questions And Answers Article

 

 

6 IMPORTANT WPF AND SILVERLIGHT MULTI-THREADING INTERVIEW QUESTIONS WITH ANSWERS

 

C# WPF INTERVIEW QUESTIONS::- WHAT ARE DEPENDENCY PROPERTIES ?

 

WPF INTERVIEW QUESTIONS WITH ANSWERS: – WHAT ARE WPF CONVERTERS?

 

WPF INTERVIEW QUESTIONS ON EVENTS (TUNNELING, BUBBLING AND DIRECT)

 

What are the advantages of using WPF ( WPF interview questions with answers)?

 

Explain WPF bindings?( .Net WPF Binding interview questions)

 

WPF Interview questions with answers :-What is XAML in WPF and why do we need it?

 

What are the different kinds of controls in WPF?(C# WPF Interview questions with answers)

 

Can you explain the complete WPF object hierarchy?(WPF Interview questions with answers)

How does “UpdateSourceTrigger” affect bindings?( C# WPF interview questions with answers)

WPF Interview questions :- Which are the different namespaces and classes in WPF ?

What are resources in WPF? (C# WPF Interview questions with answers)

Explain multi binding and multivalue converters? (.NET WPF  Interview questions with answers)

Explain the difference between static and dynamicresource? (.NET WPF interview questions)

18 important WPF interview questions asked in WPF interviews.

.NET WPF(Windows Presentation Foundation) interview questions: - What is WPF? What are the advantages of WPF over Winforms?

Explain WPF relative binding / relative resource? (.NET WPF Interview questions with answers)

Explain Ancestor relative source binding in WPF ? ( WPF Interview questions with answers)

Explain the need of binding and commands?(WPF Interview questions)

Can you explain WPF command with an example? ( WPF Interview questions with answers)

Explain the need of “INotifyPropertyChanged” interface? ( C# WPF Interview questions with answers)

What is MVVM? (WPF MVVM Interview questions)

What is the importance of command and bindings in MVVM pattern? ( WPF MVVM Interview questions)

What is the difference between MVVM and 3 layer architecture? ( WPF  MVVM Interview questions with answers)

Explain delegate command? (WPF MVVM interview questions)

WPF Interview questions with answers

Explain WPF styles?(C# WPF Interview questions with answers)

Explain Multitrigger concept in WPF?( C# WPF Interview questions with answers)

How are WPF observable collections different from simple .NET collections? (.NET WPF Interview questions)

What is the difference between control templates and data templates? ( .NET WPF Interview questions)

What are various ways of doing alignment in WPF?( WPF Interview questions with answers)

 

Algorithm Interview Questions


Algorithm interview questions and answers: – Can you write code for bubble sort algorithm?

Algorithm interview questions and answers: – What is inserted sort algorithm?

SQL INTERVIEW QUESTIONS & ANSWERS ARTICLE

 

SQL Server Interview Questions & Answers Article

SQL Server interview questions and answers: - What is HID data type in SQL Server ?

SQL Server interview questions with answers: – How to get the top record without using max, top and order by keyword?

SQL Server interview questions with answers :- If you wish to store financial values which SQL Server data type is more suitable ?

SQL Server interview questions and answers: – What is the difference between Candidate Key, Primary Key, and Alternate Key

SQL Server interview questions with answers :- What are Indexes in Sql Server?

How to sort interactively using SSRS? (SQL Server reporting services interview questions)

How to do conditional formatting in SSRS? (SQL Server reporting services interview questions with answers)

WHAT IS NORMALIZATION AND EXPLAIN 1NF 2NF AND 3NF IN SIMPLE WORDS? SQL SERVER INTERVIEW QUESTIONS WITH ANSWERS

What is the difference between Stored Procedures and Function (SQL Server interview question with answers)?

 

When you will use inner join and when you will use outer join? SQL Server interview questions with answers

 

Do you know anything about Temporary procedures in SQL?( SQL Server interview questions with answers)

 

4 SQL Server interview questions with answers on TempTb

 

Are full outer join and Cross join are same? ( SQL Server interview questions with answers)

 

Delete duplicate records: - SQL Server interview questions with answers

 

4 most asked  SQL queries during SQL Serverinterview’s

 

How Temporary tables are different from normal tables and what are its types ?( SQL Server interview questions with answers)

 

SQL Server interview Questions on JOIN’s

 

SQL Server interview questions: - How can you increase SQL performance?

 

SQL Server interview questions: - What problem you face if locking is not implemented?

 

Can we insert NULL’s in to UNIQUE key ? ( SQL Server  interview questions with answers)

 

Explain Normalization?(SQL Server Interview questions with answers)

Temp variablesVS Temp tables(SQL Server interview questions)

 


 




.NET INTERVIEW QUESTIONS & ANSWERS ARTICLE

 

.NET interview questions and answers: - How to reverse a string in .NET ( DotNet)?

.NET interview questions and answers: - What is the use of Click Once?

.NET interview questions and answers: - Will the below codes create new instances?

C# and .NET interview questions with answers – What is Nuget?

Dependency injection (DI) VS Inversion of Control (IOC)

.NET interview questions with answers: - What is the difference between Reflection and Dynamic?

Five Great .NET Framework 4.5 Features

ASP.NET MVC 4 interview questions with answers: - What is the use of “AllowHTML” and “ValidateInput” attributes?

.NET interview questions 6th edition (Sixth edition) - By Shivprasad Koirala

.NET interview questions with answers: – Can we use events without delegates ?

.Net Interview question Edition 6 is available now.

.NET interview questions with answers: – What’s the difference between catch with parameter and catch without parameter?

.NET interview questions : - What is the use and difference between “IS” and “AS” keyword?

.NET interview questions with answers: - Build solution VS Rebuild solution VS Clean solution

HTML 5 interview questions with answers for LocalStorage and SessionStorage

.NET 4.0 interview questions with answers: – What are code contracts?

What are portable class libraries? ( .NET interview questions with answers)

How to loop through ENUM using C# (.NET interview questions with answers)?

What are transactions in C#? (.NET interview questions with answers)

What are ACID Properties( .NET Interview questions with answers)?

.NET interview questions: – What are the areas that need to be concentrated for senior(9+ years experience)persons in .NET technologies?

.NET interview questions: - Explain real time scenarios in Factory Pattern, Abstract Pattern, Singleton, WCF and REST services

What is the difference between IS A and Can a Relationship?( .NET Interview questions with answers)

What is the use of ENUM Flags(.NET Enum Interview question 2)?

What is the difference between .Net,C#, Asp.net, Asp.net Web Forms and Asp.net MVC and MVC?( C# and ASP.NET Interview questions)

ADO.NET interview questions: - Explain in detail the fundamental of connection pooling?

.NET interview questions: – Can you explain generics in .NET?

What are Properties and methods ? ( .NET OOP Interview questions with answers)

What’s the first step you take for implementing any of Design Pattern?( .NET  Design pattern interview questions with answers)

.NET interview questions: - What are different types of JIT?

ADO.NET Interview Question: - What are the major differences between classic ADO and ADO.NET?

.NET interview questions: – What is the difference between Reflection and Dynamic?

What is the Use of interfaces?( .NET Interview questions with answers)

.NET interview questions: - What role did you play in your project and company?

Visual studio 2012 Fakes

.NET interview questions: - So how can we clean unmanaged objects and also maintain performance?

ADO.NET Interview Questions: - What are basic methods of Data adapter?

.NET interview questions: - What are system level exceptions and application level exceptions?

.NET interview questions: - What is UML and which are the important diagrams?

.NET interview questions: - What is time out support in regex (regular expression)?

.NET interview questions: - How can we improve performance of .NET?

.NET interview questions: - Can you explain the concept of “Short Circuiting”?

.NET interview questions: - Can you explain Forms authentication in detail?

What is the difference between VAR and Dynamic keyword? ( .NET Interview questions with answers)

.NET interview questions: - What are similarities and difference between Class and structure?

Can you compare String.IsNullOrEmpty vs String.IsNullOrWhiteSpace ? ( .Net Interview questions with answers)

.NET interview questions: - Distinguish between Reflection and Dynamic?

.NET interview questions: - In which scenarios we can use serialization and when to use what binary serialization or XML serialization?

.NET interview questions: - Are there any readymade objects in .NET by which we can implement Lazy loading?

.NET interview questions: - What are different access modifiers?

ADO.NET interview questions: - Explain in detail the fundamental of connection pooling how to enable and disable connection pooling?

ADO.NET interview questions: - What is the namespace in which .NET has the data functionality class?

ADO.NET interview questions: - What are the different components in ADO.NET?

ADO.NET interview questions: - Show difference between “Optimistic” and “Pessimistic” locking and how many ways are there to implement optimistic locking in ADO.NET?

.NET interview questions: - Does code contract only do dynamic checks?

ADO.NET interview questions: - How can we fire a simple SQL Statement using ADO.NET?

.NET interview questions: - What basic steps are needed to display a simple report in crystal?

ADO.NET interview questions: - What are basic methods of Data adapter and mention the use of data adapter?

.NET interview questions: - What is UML? How many types of diagrams are there in UML?

.Net Interview Questions - What is MVC, MVP and MVVM pattern?

.NET interview questions: - How can you define a property read only for external world and writable in the same assembly?

Explain the implicit and explicit conversion of data types with examples?( .NET interview questions on data type)

.NET interview questions: - What is Reflection its implementation and practical uses?

What is downcasting and upcasting? (.NET interview questions with answers)

.NET interview questions: - How to decide on the design consideration to take a Data grid, data list or repeater?

.NET interview questions: - If we want to update interface with new methods, what is the best practice?

.NET interview questions: - How does selection sort algorithm works?

XML(.NET) interview questions: - What is XML?

.NET Interview questions: - If a validation is very complex what will you do?

.NET interview questions: - How can we stop the class from further inheriting?

XML (.NET) Interview questions :- Explain simple Walk through of XmlReader.

.NET interview questions : - How can we improve performance of .NET and show the difference between .NET 1.X, 2.0, 3.0, 3.5 and 4.0?

How to convert string to ENUM value ?( .NET interview questions with answers)

.NET architecture interview questions series: - What is mean by modeling language?

.NET architecture interview questions : - What are benefits and Limitation of using Viewstate, hidden frames and Cookies?

.NET interview questions: - What is GAC (Global Assembly Cache)?

.NET interview questions: - Explain Nuget?

.NET Testing interview questions: - What is the difference between Unit testing, Assembly testing and Regression testing?


.NET interview questions: - What is Code Access Security (CAS) and how does it work? Is CAS supported in .NET 4.0?


.NET interview questions: - What are the advantages /disadvantages of lazy loading?


.NET interview questions: - What is the use of DEBUG directive?


.NET testing interview questions: - What is Mock testing and how to implement it?


.NET interview questions: - What is the difference between DEBUG and Release?


.NET testing interview questions: - How can we UNIT test private methods using VSTS? Is it good to practice to UNIT test Private methods?


Explain 3 layer architecture ( .NET Interview questions)?


.NET interview questions : - What is a delegate and how can we create a delegate? What is a multicast delegate?


ADO.NET interview questions: - How to add/remove row is in “Data Table” object of “Dataset”? How to load multiple tables in a Dataset & adding relation between tables in a Dataset?


What is the difference between Array, ArrayList and List?( .Net Interview questions)

.NET interview questions: - How to implement DTC in .NET?
.NET interview questions: - What is an Interface and what are abstract classes

.NET interview questions: - Interface vs. abstract class

.NET interview questions: - How to implement practically Lazy loading in .NET?


.NET interview questions: - How can we handle exceptions in .NET? What if we do not catch the exception?

.NET interview questions based on Projects.


.NET interview questions: - What is shadowing? What is the difference between Shadowing and Overriding?

.NET interview questions: - All about Design Patterns in .NET


.NET interview questions: - How can we improve performance of .NET/ASP.NET/SQL Server?

.NET interview questions: - What benefits does sealed keyword provide?


.NET Architecture UML interview question


.NET interview questions: - How to maintain performance and can clean unmanaged objects?


.NET interview questions: - Explain ENUM and its benefits? What is the use of Flagsin ENUM?

.NET interview questions: - How to create a windows service using .NET?

.NET interview questions: - Explain in details about Indexer and can we have static indexer in C#?

.NET interview questions: - What is the difference between arraylist and list? Are Arraylist faster or Arrays?

.NET interview questions: - What is Native Image Generator (Ngen.exe)? Does NGEN.EXE always improve performance?

.NET OOPS interview questions: - What is OOP? What are different properties provided by Object-oriented systems?

.NET OOPS interview questions: - How abstract with only abstract method is it different from interfaces? Also mention best practice to update interface with new methods?

.NET interview questions: - What is the difference between delegate and events? Can we have return type, access modifiers and shared events?

.NET interview questions: - What is Manifest? Where is the version information stored of an assembly? Is versioning applicable to private assemblies?

.NET Generics interview questions: - Explain Generics and concept of Generic Collection in .NET?

How to learn .NET: - In parent-child relationship which constructor will fire first and in which instances you will declare a constructor private?

Basics of .NET and learning tutorials on CTS and CLS


Online resource to learn .NET on Reflection and Dynamic

Online guide to learn .NET for Object initializer in C#?

QuestPond for Freshers on IL code, JIT, CLR, CTS, CLS and CAS

QuestPond: Interview Questions and Answers on AJAX and how does it help?



ASP.NET Interview Questions & Answers Article










MVC Interview Questions And Answers Article

 

(MODEL VIEW CONTROLLER)MVC INTERVIEW QUESTIONS AND ANSWERS

 

MVC INTERVIEW QUESTIONS WITH ANSWERS VIDEO: – WHAT IS WEB API HOW TO IMPLEMENT THE SAME?

 

ASP.NET MVC  4 INTERVIEW QUESTIONS WITH ANSWERS: - WHAT IS BUNDLING AND MINIFICATION IN MODEL VIEW CONTROLLER ?

 

MVC INTERVIEW QUESTIONS WITH ANSWERS :- IS IT POSSIBLE TO RETURN VALUES INSTEAD OF ACTIONRESULTS?

 

MVC INTERVIEW QUESTIONS WITH ANSWERS :- WHAT ARE THE ACTIONRESULTS AVAILABLE IN MVC?

 

MVC INTERVIEW QUESTIONS WITH ANSWERS:-HTML.PARTIALVSHTML.RENDERPARTIALVSHTML.RENDERPAGE IN MVC

MVC VS ASP.NET ( MVC INTERVIEW QUESTION WITH ANSWERS )?

 

HOW CAN WE DETECT THAT A MVC CONTROLLER IS CALLED BY POST OR GET ? ( ASP.NET MVC INTERVIEW QUESTIONS WITH ANSWERS)

 

WHAT ARE THE DIFFERENT WAYS BY WHICH YOU WILL GET FORM DATA IN CONTROLLER? ( MVC INTERVIEW QUESTIONS WITH ANSWERS)

 

WHAT IS THE DIFFERENCE BETWEEN PRESENTER AND CONTROLLER IN MVC?(MVC INTERVIEW QUESTIONS WITH ANSWERS)

 

LEARN MVC (MODEL VIEW CONTROLLER) STEP BY STEP IN 7 DAYS – DAY 4

 

MVC Interview questions and answers PDF

 

MVC interview questions with answers

 

ActionResult vs. View() vs. ViewResult :- MVC interview questions with answers

Explain Areas in MVC?( MVC interview questions with answers)

 

Can you explain the purpose of ViewModel in MVC?( ASP.NET MVC Interview questions with answers)

ASP.NET MVC interview questions: - What are Filters in MVC?

What are areas in MVC?( MVC Interview questions with answers)

Explain the concept of View Model in MVC? 

Exception Handling in MVC

Explain MVC application life cycle?

100 MVC Interview question PDF download released , Enjoy

How can we use two (multiple) models with a single view?(MVC Interview questions)

MVC HTML.Form vs Ajax.Form – MVC interview questions with answers

Learn Microsoft Business intelligence step by step – Day 1

Can you create TempBag just like ViewBag?( MVC Interview questions)

MVC Unit Testing Unleashed

MVC and .NET learning tutorials for components of MVC and how do you perform unit testing in MVC?

Explain MVC model binders ? ( ASP.NET MVC interview questions)

Explain the difference between layout and master pages ? (MVC Razor interview questions) 


ENTITY FRAMEWORK INTERVIEW QUESTIONS ARTICLE


Windows Workflow Foundation(WWF) interview questions with answers Article

XML Interview Questions With Answers Article


Explain XML,DTD and XSL?(XML interview questions with answers)

HTML 5 Interview questions With Answers Article

HTML 5 interview questions with answers for LocalStorage and SessionStorage

 

How is the page structure of HTML 5 different from HTML 4?( HTML 5 Interview questions with answers)

 

What is datalist in HTML 5 ( ASP.NET HTML interview questions)?

 

What are the different new form element types in HTML 5?( ASP.NET HTML 5 interview questions with answers)

 

What is output element in HTML 5?( ASP.NET HTML 5 interview questions)

 

What is the difference between Canvas and SVG graphics?(ASP.NET HTML 5 interview questions with answers)

 

ASP.NET HTML 5 interview questions on SVG and Canvas

ASP.NET HTML5 interview questions with answers

What are web workers and why do we need them ?( ASP.NET HTML interview questions with answers)

 

Why do we need HTML 5 server-sent events? (ASP.NET HTML interview questions)

How can we add and remove data from local storage?(ASP.NET HTML 5 interview questions)

What is local storage concept in HTML 5? ( ASP.NET HTML 5 interview questions)

What is the difference between local storage and cookies? ( ASP.NET HTML 5 interview questions)

What is WebSQL?( ASP.Net HTML 5 interview questions)

 

What is session storage and how can you create one?( ASP.Net HTML 5 interview questions with answers)

 

What is application cache in HTML5?( ASP.NET HTML 5 interview questions with answers)

ASP.NET HTML 5 Application cache interview questions with answers

 

Explain the term cascading in style sheet ? ( CSS Interview questions)

What is difference between DIV vs SPAN in HTML ?( ASP.Net Interview questions)

HTML 5 Canvas Interview questions: - Canvas in HTML 5.

QuestPond’s interview questions and answers on HTML 5

 

Learn HTML 5 in 3 days – Day 1

 

 

 

Dotnetspider Questions And Answers Article

 

 

What is downcasting and upcasting ? ( .NET interview questions with videos)

 

What is the difference between String vs string? ( C# interview questions) ?

 

 

JAVASCRIPT INTERVIEW QUESTIONS WITH ANSWERS ARTICLE

 


3 IMPORTANT JAVASCRIPT IMPORTANT INTERVIEW QUESTION WITH ANSWERS