Photon Interactive Technical Lead Interview Questions, Process, and Tips

Solid principles are a set of design principles that help make software more maintainable, flexible, and scalable.

• Single Responsibility Principle (SRP) - A class should have only one reason to change.

• Open/Closed Principle (OCP) - Software entities should be open for extension but closed for modification.

• Liskov Substitution Principle (LSP) - Objects of a superclass should be replaceable with objects of its subclasses wi...read more

Code snippet for Entity Framework DB connection

• Install Entity Framework NuGet package

• Create a DbContext class

• Define DbSet properties for each entity

• Configure connection string in app.config/web.config

• Use DbContext to interact with the database

To get the 3rd highest salary, we can use a SQL query with the 'LIMIT' and 'OFFSET' keywords.

• Use a SQL query with 'ORDER BY salary DESC' to sort salaries in descending order.

• Use 'LIMIT 1 OFFSET 2' to skip the first two highest salaries and get the 3rd highest salary.

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;

Interfaces in C# provide a way to define a contract for classes to implement, promoting code reusability and flexibility.

• Interfaces allow for multiple inheritance in C# by allowing a class to implement multiple interfaces.

• Interfaces help in achieving loose coupling between classes, making the code more maintainable and testable.

• Interfaces are used to define common behavior that multiple classes can share, promoting cod...read more