CIYA Technologies DOT NET Developer Interview Questions, Process, and Tips

Q1. What is the repository design pattern?
Ans. 
Repository design pattern is a design pattern that separates the data access logic from the business logic in an application.
• It helps in achieving separation of concerns by isolating the data access code in a separate layer.

• It provides a centralized way to access data from various sources such as databases, web services, etc.

• It makes the codebase more maintainable and testable by abstracting the data access logic.

• Examp...read more
Answered by AI
Add your answer
Q2. What is the difference between IEnumerable and IQueryable?
Ans. 
IEnumerable is used for in-memory collection operations, while IQueryable is used for database query operations.
• IEnumerable is used for querying data from in-memory collections like arrays, lists, etc.

• IQueryable is used for querying data from a database using LINQ to SQL or Entity Framework.

• IEnumerable executes the query in-memory, while IQueryable executes the query on the database server.

• IEnumerable is suitable for L...read more
Answered by AI
Add your answer

Q1. How to call abstract constructor
Add your answer
Q2. Difference between generic list and list which is faster
Add your answer

Write prime number code

Q1. What's your experience
Add your answer
Q2. Whats your Qualifications
Add your answer

Q1. What are joins?
Add your answer
Q2. Oops concept and its implementation
Add your answer

Q1. Code excution of .net application?
Ans. 
The .NET application code is compiled into Intermediate Language (IL) which is then executed by the Common Language Runtime (CLR).
• Code is compiled into Intermediate Language (IL) by the compiler

• IL is then converted into machine code by the Just-In-Time (JIT) compiler

• The CLR manages memory, security, and other system resources during code execution
Answered by AI
Add your answer
Q2. Stored procedure vs function?
Ans. 
Stored procedures are precompiled SQL queries that can perform multiple operations, while functions are reusable code blocks that return a single value.
• Stored procedures can execute multiple SQL statements and can perform complex operations.

• Functions are reusable code blocks that return a single value and can be used in SQL queries.

• Stored procedures can be called independently, while functions are typically called with...read more
Answered by AI
Add your answer
Q3. What is CLR, Why its used?
Ans. 
CLR stands for Common Language Runtime, it is used to manage the execution of .NET programs.
• CLR is a part of the .NET framework responsible for managing the execution of .NET programs.

• It provides services such as memory management, exception handling, and security.

• CLR converts the Intermediate Language (IL) code into machine code during runtime.

• It allows for language interoperability, meaning different languages can be...read more
Answered by AI
Add your answer
Q4. What is GC, where you have used in the app?
Ans. 
GC stands for Garbage Collection, a process in .NET to automatically manage memory by reclaiming unused objects.
• GC is a feature in .NET that automatically manages memory by reclaiming unused objects.

• It helps in preventing memory leaks and improving application performance.

• GC can be used in .NET applications to free up memory occupied by objects that are no longer needed.
Answered by AI
Add your answer

Q1. General questions on ASP.NET, Projects
Add your answer
Q2. Questions from my resume and current project
Add your answer

Q1. It was a combination of two interviews in one. Technical and Managerial interview was taken in one call and it was 1.5 hr long. It consisted of some technical and managerial level questions and with the di...read more
Add your answer
Q2. Explain Solid Principles
Ans. 
Solid Principles are a set of five design principles for writing clean, maintainable, and scalable code.
• Single Responsibility Principle (SRP) - A class should have only one reason to change.

• Open/Closed Principle (OCP) - Classes 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 without affecting the ...read more
Answered by AI
Add your answer
Q3. Questions about scenarios in polymorphism
Add your answer
Q4. Dependency Injection and how to implement that.
Ans. 
Dependency Injection is a design pattern where dependencies are injected into a class rather than created within the class.
• Dependency Injection helps in achieving loose coupling between classes.

• It allows for easier testing by enabling mocking of dependencies.

• There are different ways to implement Dependency Injection such as constructor injection, property injection, and method injection.

• Popular DI containers/frameworks
Answered by AI
Add your answer
Q5. Configuration where do we store in application.
Ans. 
Configuration settings can be stored in various places such as appsettings.json, environment variables, database, or Azure Key Vault.
• appsettings.json file in ASP.NET Core projects

• Environment variables for sensitive data

• Database for dynamic configuration

• Azure Key Vault for secure storage
Answered by AI
Add your answer

Q1. Solid principle
Add your answer
Q2. Dependency injection
Add your answer

Q1. About the SQL server basic question
Add your answer
Q2. .net fundamentals
Add your answer