Clover Infotech Senior .NET Developer Interview Questions, Process, and Tips

Middleware in .NET Core is software components that are assembled into an application pipeline to handle requests and responses.

• Middleware components are executed in the order they are added to the pipeline.

• Middleware can perform tasks like authentication, logging, error handling, etc.

• Examples of middleware in .NET Core include UseAuthentication, UseMvc, UseStaticFiles.

Dependency injection in .NET Core is a design pattern where a class receives its dependencies from external sources rather than creating them itself.

• Dependency injection helps in achieving loose coupling between classes.

• Types of dependency injection in .NET Core include constructor injection, property injection, and method injection.

• Example: Constructor injection involves injecting dependencies through a class's constr...read more

Yes, triggers can be rolled back in SQL Server.

• Triggers can be rolled back using the ROLLBACK statement in SQL Server.

• Rolling back a trigger will undo any changes made by the trigger.

• Example: ROLLBACK TRANSACTION;

Cursors are used in databases to retrieve and manipulate data, despite consuming memory.

• Cursors are used to iterate over a result set in a database query.

• They allow for sequential processing of query results.

• While they do consume memory, they are necessary for certain operations like updating rows in a specific order.

• Cursors should be used judiciously to avoid excessive memory consumption.