I applied through a staffing agency. I interviewed at Mindfire Solutions in June 2024
Interview
The interview primarily focused on .NET Entity Framework, SQL Server, and had a significant emphasis on LINQ (Language Integrated Query). It also included questions related to Angular, particularly Reactive Forms. Added detailed breakdown of the topics and questions discussed during the interview.
Interview questions [3]
Question 1
To Make you comfortable basic question -
WAP in C# to print odd numbers upto 100.
Angular
- Reactive Forms in Angular
- Write a form to take First Name, Last Name, Email and Password. All are required field, First Name and Last Name of 20 characters long, Valid Email and password of min 6 length. Add Reset button to reset and submit is disabled if form is invalid.
- Pipes - Types - Pure & Impure
.NET
- Write a http call to Display the Title of all the Completed TODOs in Sorted order from the following URL https://jsonplaceholder.typicode.com/todos
- Http Get vs Http Post
- How to pass data from View to Controller?
- Create Instance of Employee class in Main Function
public class Employee{
private Employee(){}
}
- What is Dependency Injection?
- What would happen if we directly create object in constructor?
- Design a database with Table Employee and Department where Employee can have multiple departments.
- What is Composite Key?
- Write a query to print Department Name where No. of Employee is more than 10.
- Write/Represent above thing in Code First Approach. (migrations & DbSet).
- Write Linq for above query.
- How to restrict max length of Employee to 22 characters.
- How to restrict all strings of a DB sets to 22 characters