Dr. Mehta's Hospitals Interview Questions and Answers

Generic collections are type-safe and can store any type of data. Non-generic collections can only store objects of type 'object'.

• Generic collections are preferred as they provide compile-time type safety.

• Non-generic collections are slower and can cause runtime errors if the wrong type is added.

• Examples of generic collections include List, Dictionary, and Queue.

• Examples of non-generic collections include

Triggers are database objects that automatically execute in response to certain events.

• Triggers can be used to enforce business rules or perform complex calculations.

• Types of triggers include DML triggers, DDL triggers, and logon triggers.

• DML triggers fire in response to data manipulation language (DML) events, such as INSERT, UPDATE, or DELETE statements.

• DDL triggers fire in response to data definition language (DDL) ...read more

Managed code is executed by the CLR while unmanaged code is executed by the operating system.

• Managed code is written in languages like C#, VB.NET, etc. and is compiled into Intermediate Language (IL) code.

• Unmanaged code is written in languages like C, C++, etc. and is compiled into machine code.

• Managed code is executed by the Common Language Runtime (CLR) while unmanaged code is executed by the operating system.

• Managed...read more

In, out and ref are parameter modifiers in C# used to pass arguments to a method.

• In parameters are read-only and used to pass values to a method.

• Out parameters are write-only and used to return values from a method.

• Ref parameters are read-write and used to pass values to and from a method.

• In parameters are passed by value, out and ref parameters are passed by reference.

• In parameters are optional, out and ref parameters

Difference between viewdata, viewbag and tempdata

• ViewData is used to pass data from controller to view

• ViewBag is a dynamic object used to pass data from controller to view

• TempData is used to pass data between controller actions or redirects

Ways to improve performance of stored procedures

• Use SET NOCOUNT ON to reduce network traffic

• Avoid using SELECT *

• Use table variables instead of temporary tables

• Avoid using cursors

• Use appropriate indexes

• Avoid using scalar functions

• Minimize the use of triggers

• Use stored procedures instead of ad hoc queries