10+ TCS Interview Questions and Answers

Migration scripts help in updating the database schema when changes are made to the code first model.

• Migration scripts are used to update the database schema to match the code first model

• They help in keeping the database schema in sync with the code first model

• They are executed automatically when the application starts or manually using the Package Manager Console

• They can be used to add, modify or delete database objects like tables, columns, indexes, etc.

• They can be versione...read more

Dot net is a framework for building Windows applications while Dot net core is a cross-platform framework.

• Dot net is Windows-only while Dot net core is cross-platform

• Dot net core is open-source while Dot net is not

• Dot net core is modular while Dot net is monolithic

• Dot net core has better performance and scalability

• Dot net core supports microservices architecture

One to many relationship in SQL Server

• Create a foreign key in the child table referencing the primary key in the parent table

• Use JOIN to retrieve data from both tables

• Use GROUP BY to group data by the parent table's primary key

• Use COUNT to get the number of child records for each parent record

ORM stands for Object-Relational Mapping. It is a technique to map database tables to classes in object-oriented programming.

• ORM allows developers to work with databases using object-oriented programming concepts.

• ORM models I have worked on include Hibernate, Entity Framework, and Sequelize.

• ORM helps to reduce the amount of boilerplate code required to interact with databases.

• ORM provides a layer of abstraction between the application and the database, making it easier to swi...read more

To make an application scalable, consider factors like load balancing, caching, database optimization, and horizontal scaling.

• Use load balancers to distribute traffic evenly across multiple servers

• Implement caching to reduce the number of requests to the server

• Optimize database queries and indexes to improve performance

• Use horizontal scaling to add more servers as needed

• Design for fault tolerance and high availability

Mapping in code first is done using attributes or fluent API to map classes to database tables.

• Mapping can be done using attributes like [Table], [Column], [Key], etc.

• Fluent API can be used to configure mapping in OnModelCreating method of DbContext.

• Navigation properties can be mapped using [ForeignKey] attribute or fluent API.

• Mapping can also be done for complex types and inheritance hierarchies.

• Mapping can be customized using conventions or custom mapping.

• Example: [Table("C...read more

I have used multiple IOC containers including Unity, Autofac, and Ninject.

• I have used Unity for dependency injection in a .NET MVC project.

• I have used Autofac for dependency injection in a .NET Core project.

• I have used Ninject for dependency injection in a Xamarin.Forms project.

• I have also worked with Simple Injector and Castle Windsor.

We use a continuous integration and deployment pipeline to automatically deploy code changes to our production environment.

• We use Git for version control and have a separate branch for production-ready code.

• Our CI/CD pipeline is set up using Jenkins and Docker.

• Tests are run automatically before deployment to ensure code quality.

• Deployment is triggered automatically when changes are pushed to the production branch.

• We use Kubernetes for container orchestration and scaling.

• Rollb...read more

C# 9.0 introduces new features like records, init-only setters, and top-level programs.

• Records provide a concise syntax for defining immutable types.

• Init-only setters allow for setting properties only during initialization.

• Top-level programs allow for writing simple console applications without a class or Main method.

• Improved pattern matching with logical patterns and relational patterns.

• Function pointers and improved support for native interop.

• New target-typed expressions an...read more

Microservices architecture is a software development approach where a single application is broken down into smaller, independent services.

• Each service is responsible for a specific task or function

• Services communicate with each other through APIs

• Allows for greater flexibility, scalability, and easier maintenance

• Examples include Netflix, Amazon, and Uber