C# · SQL

Dapper

Dapper is one of the ORM tools that allows to manipulate data easily and with high performance. It extends IDbConnection interface by introducing couple of extension methods used to query tables in database. Dapper supports static as well as dynamic object binding. It also provides bulk insert functionality and can handle transactions and stored procedures.… Continue reading Dapper

SQL

Types of Relationships in Relational Database

Relationships are an established connection between different tables that are based on common fields from these tables. They allow to split data by storing them in various tables, while associating miscellaneous data items. There are three types of relationships: One-to-One One-to-One relation is defined as a connection between tables that are related to each other… Continue reading Types of Relationships in Relational Database