C#

Can you explain the principle of operation and purpose of the Adapter pattern in programming?

Can Object be considered a type with strict typing restrictions?

What elements does the internal structure of the foreach operator in C# consist of?

Can you describe how you have used migration mechanisms to manage changes in the database during development?

Can you show an example of using the Builder pattern to create objects?

How can an optimistic locking mechanism be implemented?

Junior — Middle

Aston

From the perspective of metric visualization — custom or standard solution?

If a method run asynchronously executes synchronously, does the thread return to the thread pool after its completion?

What tools and libraries do you use when programming in Python?

How is the management of roles and rights of participants implemented in your project?

Junior — Middle

Aston

What steps would you take if a delay in receiving data from the database causes problems in the application?

Can you explain the concept of generic types in programming?

Can you explain the concept of parallel computing and its application in programming?

What does the letter L in the SOLID principles signify and how does it influence software system design?

Explain the principles underlying the SOLID concept and their impact on software system development.

What are the main difficulties encountered when working with databases and how do you solve them?

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

How does the index mechanism accelerate query execution in SQL databases?

How to distinguish between IEnumerable and IQueryable and in which cases each is used?

What is the number of stacks used in the program?