Saviant Consulting Interview Questions, Process, and Tips

I am a DOT NET Developer with expertise in C#, ASP.NET, MVC, SQL Server, and Entity Framework.

• Proficient in C# programming language

• Experience with ASP.NET and MVC frameworks

• Skilled in working with SQL Server and Entity Framework

Use recursion to print numbers from 100 to 1 without using loops.

• Create a recursive function that prints the number and calls itself with the next number until reaching 1.

• Base case should be when the number is 1, then stop recursion.

• Example: void printNumbers(int n) { if(n == 0) return; print(n); printNumbers(n-1); }

Reverse words in a given string

• Split the string into an array of words

• Reverse each word in the array

• Join the reversed words back into a string

LEFT Join example in LINQ and SQL

• In LINQ, use the 'DefaultIfEmpty' method to perform a LEFT JOIN

• In SQL, use the 'LEFT JOIN' keyword to combine rows from two tables based on a related column

Abstraction focuses on hiding complex implementation details, while encapsulation bundles data and methods into a single unit.

• Abstraction allows us to focus on the essential features of an object while hiding unnecessary details. For example, a car can be abstracted as a vehicle with properties like speed and color.

• Encapsulation involves bundling data and methods that operate on the data into a single unit. For example...read more

Filters in MVC are used to perform logic before or after an action method is executed.

• Filters can be used for authentication, authorization, logging, exception handling, etc.

• Examples include Authorize filter for restricting access to certain actions, HandleError filter for handling exceptions, etc.

There are multiple ways to send data from View to controller in ASP.NET MVC, including form submission, AJAX calls, query strings, and model binding.

• Form submission using HTML forms

• AJAX calls using jQuery or other JavaScript libraries

• Query strings in the URL

• Model binding in ASP.NET MVC

Clustered indexes physically reorder the data in the table, while non-clustered indexes create a separate structure.

• Clustered indexes determine the physical order of data rows in a table.

• Non-clustered indexes create a separate structure that contains a copy of the indexed columns and a pointer to the actual data rows.

• Tables can have only one clustered index, but multiple non-clustered indexes.

• Clustered indexes are fast...read more

ACID is a set of properties that guarantee database transactions are processed reliably.

• ACID stands for Atomicity, Consistency, Isolation, Durability.

• Atomicity ensures that all operations in a transaction are completed successfully or none at all.

• Consistency ensures that the database remains in a consistent state before and after the transaction.

• Isolation ensures that transactions are executed independently without int...read more

Implementing a new feature to automate data migration process

• Developing a custom data migration tool using C# and SQL Server

• Creating scripts to extract data from legacy system and load into new system

• Testing the tool with sample data to ensure accuracy and efficiency

I test features after implementation by conducting unit tests, integration tests, regression tests, and user acceptance tests.

• Conduct unit tests to ensure individual components work correctly

• Perform integration tests to check interactions between components

• Run regression tests to verify that new features do not break existing functionality

• Conduct user acceptance tests to ensure the feature meets user requirements

I follow OOPS concepts by using inheritance, encapsulation, polymorphism, and abstraction in my code.

• I use classes and objects to encapsulate data and behavior.

• I utilize inheritance to create a hierarchy of classes with shared attributes and methods.

• I implement polymorphism by overriding methods in derived classes.

• I apply abstraction to hide complex implementation details from the user.

Database is connected using Entity Framework in current project. Yes, we can update multiple databases using DbSet.

• Database is connected using Entity Framework which provides a data access layer for interacting with the database.

• DbSet is a collection of entities that can be queried, updated, inserted, and deleted in the database.

• By using DbSet, we can update multiple databases by specifying the database context for eac...read more