20+ Interview Questions and Answers

WPF provides better UI design and development options than Windows Forms.

• WPF allows for more flexible and customizable UI design.

• WPF supports vector graphics and animations.

• WPF has better data binding capabilities.

• WPF is more modern and actively developed than Windows Forms.

• WPF is better suited for creating modern desktop applications.

Procedures and triggers are database objects used to automate tasks and enforce rules.

• Procedures are a set of SQL statements that can be executed repeatedly.

• Triggers are special types of procedures that are automatically executed in response to certain events.

• Triggers can be used to enforce business rules, audit changes, or replicate data.

• Procedures and triggers can be written in various programming languages such as SQL, PL/SQL, T-SQL, etc.

Singleton design pattern restricts the instantiation of a class to a single instance.

• Ensures only one instance of a class exists

• Provides a global point of access to that instance

• Used when only one object is needed to coordinate actions across the system

• Example: Database connection manager

LINQ (Language Integrated Query) is a Microsoft technology that allows querying data from different sources using a common syntax.

• LINQ provides a unified way to query data from different sources such as databases, XML documents, and collections.

• It allows developers to write queries using a common syntax regardless of the data source.

• LINQ queries are strongly typed and can be checked at compile time.

• Examples of LINQ providers include LINQ to SQL, LINQ to XML, and LINQ to Objec...read more

Encapsulation is hiding implementation details while abstraction is showing only necessary details.

• Encapsulation is achieved through access modifiers like private, protected, and public.

• Abstraction is achieved through abstract classes and interfaces.

• Encapsulation provides data security and prevents unauthorized access.

• Abstraction helps in reducing complexity and improves maintainability.

• Example of encapsulation: Class with private variables and public methods.

• Example of abstr...read more

MVC life cycle is a series of steps that occur when a request is made to an MVC application.

• Request is received by the routing engine

• Routing engine determines the controller and action to handle the request

• Controller is instantiated and action method is called

• Action method returns a view

• View is rendered and returned as a response

An abstract class is a class that cannot be instantiated and is used as a base class for other classes.

• An abstract class can have abstract and non-abstract methods.

• Abstract methods have no implementation and must be implemented by the derived class.

• An abstract class can have constructors and fields.

• An abstract class can be used to define a common interface for a group of related classes.

• Example: Animal is an abstract class and Dog, Cat, and Bird are derived classes.

ADO.NET is a data access technology used to connect applications to databases.

• ADO.NET provides a set of classes to interact with databases.

• It supports disconnected data architecture.

• It uses Data Providers to connect to different databases.

• It supports LINQ to SQL for querying databases.

• Examples of Data Providers are SQL Server, Oracle, MySQL, etc.