Month: January 2018

Let’s understand the Transact-SQL

T-SQL or Transact-SQL is a proprietary SQL extension (design query language). Additional features include high performance, maximum functionality, and greater globalization support. Transaction SQL is a Microsoft SQL Server process implemented. It is widely compatible […]

State design patterns, when to use, pros and cons

The state design scheme is used to model changes in the state or state of an object by delegating the rules for such changes to individual objects representing each possible state. When we should use […]

Few Tips to Secure your Servers

Regarding your infrastructure, your primary concern is usually to get and manage your applications. However, apps are not going to work properly without fulfilling the security requirements of your infrastructure. There may be serious consequences […]

Advantages of NoSQL Database over RDBMS

The NoSQL database is a data loading approach different from the relational database. NoSQL’s differences are considered as an additional chart and document, key-value, column, to name. MongoDB is schematic of less. It is a […]

SQL interview questions part 1

What is SQL function? SQL functions are methods which accept parameters and perform the action, such as a complex calculation and return the result of that action as a value.the return value can either be […]

MongoDB vs MySQL Comparison

Relational databases, and to a degree MySQL, have become the backbone of commercial organizations. Programmers and database developers have been engaged in a tug-of-war, deciding the best place to store and execute the business logic. […]

Domain model in Domain driven design

Hello everyone, In this article, we will focus on the Domain model an foundation of Domain Driven Design. Domain Model is a term you will hear a ton of Domain Driven Design. I think Domain […]

Alternatives ORM for Entity Framework

Entity Framework has come a long way since version 1. So much that it leapfrogged every other version up to version 7. With EF Core 2 out, I feel this gives us the performance and versatility […]

Multiple Ways to Build Routing in ASP.NET Core

Routing in Microsoft MVC or WebAPI applications serves as a map to define the routes for all incoming requests. There are three basic components of routing in MVC , WebAPI applications Controller, Action method, and parameters. […]

LINQ Standard Query Operators

LINQ standard query operators are the methods which help you to write LINQ query. Most of these query methods operate on sequences or collection whose implement the IEnumerable interface or the IQueryable interface. These operators […]