C#

How does ORM affect the optimization of executed SQL queries and what does it generate as output?

Describe the stages and features of the software development process at your last place of employment.

What tools or methods do you use for deploying applications or services?

How is the List data structure implemented in memory and what mechanisms underlie its operation?

How do you analyze and review query execution plans in MS SQL Server?

What are the advantages and disadvantages of using the result via 'result' for data processing?

In what cases and with which objects is the 'using' directive used in C++?

If we use the ref and out keywords in C#, does the structure become a reference type?

Can you list and explain the main collections intended for use in a multithreaded environment?

How do reference data types behave in C#?

Can you explain what common table expressions (CTE) are in SQL and what they are used for?

Explain the differences between HTTP PUT and PATCH methods when updating resources.

Junior — Middle

Aston

Explain the differences between lock, Semaphore, and Mutex locking mechanisms.

How is data storage organized in Redis?

What is abstraction?

Does a class or a struct occupy less memory?

What is an Action filter and what functions does it perform?

How can a property change notification mechanism be implemented in data models in .NET?

Is it possible to use async/await inside a lock? Why?

How is ThreadPool used in the context of async/await? Is it possible to guarantee the same thread after await?