ESurveying Softech DOT NET Developer Interview Questions and Answers

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. 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. SOLID principles
Add your answer
Q2. Global and local temp tables
Add your answer
Q3. SQL QUERIES AND PALINDROME CODE
Add your answer

Q1. All technology questions on topics mentioned in resume
Add your answer

Mettl aptitude reasoning and technical MCQ

Q1. Can you explain how you would implement lazy loading?
Ans. 
Lazy loading is a design pattern where data is loaded only when it is needed, improving performance and reducing resource consumption.
• Lazy loading can be implemented by loading data on demand rather than loading all data at once.

• One common way to implement lazy loading is by using proxy objects that only load data when a property is accessed.

• Lazy loading can also be achieved using frameworks like Entity Framework in .N...read more
Answered by AI
Add your answer

Basic oops implementation.

Q1. Explain Millewares and DI ?
Ans. 
Middleware is software that acts as a bridge between an operating system or database and applications, while DI (Dependency Injection) is a design pattern used to increase flexibility and maintainability of code.
• Middleware is software that provides common services and capabilities to applications, such as authentication, logging, and routing.

• DI is a design pattern where the dependencies of a class are injected from the...read more
Answered by AI
Add your answer
Q2. How Authentication works in Web api ?
Ans. 
Authentication in Web API involves verifying the identity of a user or system before granting access to resources.
• Authentication headers like Authorization header are used to send credentials

• Web API can use various authentication methods like JWT, OAuth, Basic Authentication

• Authentication middleware is used to validate credentials and generate tokens

• Access control lists (ACLs) can be used to define permissions for diff
Answered by AI
Add your answer

Q1. Why Capgemini ?
Ans. 
Capgemini is a global leader in consulting, technology services and digital transformation, offering a wide range of opportunities for growth and development.
• Capgemini is a well-established global company with a strong reputation in the IT industry

• They offer a wide range of projects and opportunities for career growth

• Capgemini values innovation and provides a collaborative work environment

• The company has a strong focus...read more
Answered by AI
Add your answer
Q2. How early I can join ?
Add your answer