Primyer/Sqlist.NETv2.1.1
.NET 8.0
Advanced Object/Relational Mapping (O/RM) framework designed to streamline the interaction between .NET applications and relational databases.
Get Started
$ dotnet add package Sqlist.NETReadme
Introduction
Project Overview
Sqlist.NET is an advanced Object/Relational Mapping (O/RM) framework designed to streamline the interaction between .NET applications and relational databases. Built on the robust foundations of ADO.NET, it provides an abstraction API that allows developers to perform database operations without writing raw SQL queries, thereby simplifying the development process. The framework is built to support future integrations with various RDBMS providers, ensuring extensibility and flexibility. As of now, PostgreSQL is the officially supported database, with plans to integrate more RDBMS providers in the future.
Purpose
The primary purpose of Sqlist.NET is to offer a robust and scalable O/RM solution that abstracts the complexities of database interactions. This framework aims to:
- Simplify CRUD (Create, Read, Update, Delete) operations by providing a high-level API.
- Enhance productivity by reducing the amount of boilerplate code needed for database interactions.
- Enable seamless database migrations through a combination of SQL scripts and schema mapping written in YAML.
- Support dynamic database schema changes and versioning to accommodate evolving application requirements.
- Provide a dotnet CLI tool for managing database migrations directly from the project's directory, akin to Entity Framework Core Migration Tools.
- Facilitate the integration of multiple database providers, starting with PostgreSQL, to cater to diverse application needs.
- Ensure high performance and reliability for enterprise-level applications.
By leveraging Sqlist.NET, developers can focus more on business logic and less on the intricacies of database management, leading to faster development cycles and more maintainable codebases.
Key Features
- Abstraction API: Provides a simplified interface for interacting with databases.
- Provider Support: Official integration with PostgreSQL, with the potential for more RDBMS integrations.
- Database Migrations: Combines SQL scripts and YAML-based schema mappings for robust migration support.
- Dotnet CLI Tool: Facilitates migrations and other database operations directly from the project directory.
- Modular Architecture: Organized into multiple assemblies, each responsible for specific functionalities, promoting maintainability and scalability.
- Extensibility: Designed to accommodate additional RDBMS providers and extend core functionalities as needed.