EY Global Delivery Services ( EY GDS) DOT NET Developer Interview Questions, Process, and Tips

To return multiple data with different data types from a function in .c#, use Tuple or create a custom class with properties for each data type.

• Use Tuple to return multiple data with different data types. For example: Tuple

• Create a custom class with properties for each data type and return an instance of that class. For example: public class CustomData { public int Number { get; set; } public string

Optimizing stored procedures involves reducing execution time and resource usage.

• Use proper indexing on tables involved in the stored procedure

• Avoid using SELECT * and only fetch necessary columns

• Minimize the use of temporary tables and cursors

• Avoid using scalar functions in WHERE clauses

• Consider using table-valued functions instead of scalar functions

Azure Functions can be run locally using Azure Functions Core Tools

• Install Azure Functions Core Tools using npm

• Create a new Azure Functions project using func init command

• Run the Azure Functions project locally using func start command

Partial class is a class that allows splitting the definition of a class into multiple files.

• Partial classes are used to divide a large class into smaller, more manageable parts.

• Each part of a partial class must use the 'partial' keyword.

• All parts of a partial class must be in the same namespace and assembly.

• Partial classes are commonly used in code generation scenarios.

• Example: public partial class MyClass { }