Databases

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the internet).

Azure SQL, a cloud-based database service by Microsoft, empowers our team to efficiently build, manage, and scale applications. Leveraging Microsoft’s cloud computing expertise, Azure SQL offers a wide range of features and supports open-source technologies, ensuring seamless operation across diverse environments.

PostgreSQL, known for its advanced features and extensibility, is an open-source relational database management system. It excels in handling complex queries and large datasets, making it a popular choice for applications with demanding data requirements.

MySQL, an open-source relational database management system, is valued for its speed, reliability, and ease of use. Widely used in web applications, it seamlessly integrates with various programming languages, making it a go-to option for developers.

Microsoft’s Cosmos DB is a globally distributed, multi-model database service tailored for mission-critical applications. It supports various data models including document, key-value, graph, and wide-column, ensuring optimal performance for a wide array of applications across a global scale. With its extensive capabilities, Cosmos DB is an excellent choice for enterprises with demanding and diverse data needs.

MongoDB, a widely adopted document-oriented NoSQL database, stands out for its scalability and flexibility. Designed to handle evolving data models, it’s a favored choice for applications with rapidly changing data requirements, making it highly suitable for modern development practices.

Redis is an in-memory data structure store, used as a distributed, in-memory key–value database, and cache and message broker. Redis supports a variety of abstract data structures, such as strings, lists, maps, sets, sorted sets, bitmaps, streams, and spatial indices. It has core capabilities that include in-memory data structures, server-side scripting and stored procedures, and a module API for building custom extensions in C, C++, and Rust.

Entity Framework Core (EF Core) is the object-relational mapper (ORM) for modern .NET. We use it to work with SQL Server, PostgreSQL, Cosmos DB, and other databases through LINQ queries, change tracking, and versioned schema migrations instead of hand-written data-access code.

Dapper is an open-source framework for mapping an object-oriented domain model to a traditional relational database that uses fewer lines of code, has speedy and high performance, and supports multiple queries. It provides object-relational mapping in the .NET platform. Dapper offers a choice of static/dynamic object binding and operates directly on IDbConnection interface.