If you are a software developer, you must not be alien to the dependency injection design pattern. Dependency injection (long form for DI) design pattern is broadly used in applications to manage dependencies for different components, especially in enterprise level applications. Dependency injection is so useful that even in front end frameworks, like Angular, provides …
Interfaces is not an unknown concept in any object oriented programming language. But its often confusing that why is it even required when one can simply create classes, initialize the instances and invoke the required method. Also, it seems to be a very important question for interviewers while hiring for experienced software developers. Lets discuss …
Microsoft provides LINQ operators under the System.linq namespace. If fairly reduces the effort to manipulate collections. Let’s discuss below LINQ operators for changing the order of the list items. We will discuss about various scenarios of orderBy operator using query syntax and method syntax. We are considering that we have a list of product class …
LINQ OrderBy and OrderByDescending Operator (C#) Read More »
Scenarios in which visitor pattern is used: Engineers use Visitor pattern in scenarios in which we need to extend a functionality to classes that implement an interface. But we don’t want to make any modification to the classes. Creating extension method can be a solution to the same. But at intermediate level, the extension method …
CTEs (Common Table Expressions) are very useful in creating queries that need a recursion. CTEs are also very frequently asked interview questions for backend developers. Lets discuss a scenario and implement it using CTE to understand the same. Consider, we have a Person table which contains the Name, Age, and parent from the same table. …
Whenever there are some SQL related task with high performance requirements, it often takes a lot of research. Inserting data in SQL tables is a simple task, but when we have to insert millions of records with high performance, it might take a bit a research. Also we will discuss about inserting relational data too. …
Fastest way to insert millions of records in SQL Server Read More »
You may get this error once in a while when pushing the changes on your git branch. This is an uncommon issue and below are the domain of reasons due to which you might get this error: Case: when pushing local branch If your branch is a local branch, the most likely reason is that …