FreeSql is an object-relational mapper for .NET applications. It provides APIs for querying and modifying relational databases while mapping database records to C# objects.
The ORM supports .NET Core, .NET Framework, Xamarin, and ahead-of-time compilation scenarios. It offers several development models, including direct FreeSql access, DbContext with repositories and units of work, and a simplified BaseEntity approach.
This is free and open source software.
Key Features
- Supports Code First schema creation and database migrations.
- Generates entity classes from existing databases using DbFirst tools.
- Provides strongly typed queries using LINQ expression trees.
- Handles one-to-one, one-to-many, and many-to-many relationships.
- Offers eager loading, cascading operations, and lazy loading.
- Supports repositories, units of work, transactions, and dependency injection.
- Provides read/write separation, table partitioning, database sharding, and global filters.
- Supports optimistic and pessimistic locking.
- Works with MySQL, MariaDB, PostgreSQL, SQL Server, Oracle, SQLite, Firebird, ClickHouse, DuckDB, TDengine, QuestDB, Microsoft Access, and other databases.
- Allows custom data-type mappings and expression-function translation.
Website: github.com/dotnetcore/FreeSql
Support:
Developer: YeXiangQin
License: MIT License
FreeSql is written in C#. Learn C# with our recommended free books and free tutorials.
Related Software
| C# Object-Relational Mapping Software | |
|---|---|
| Entity Framework Core | Modern object-database mapper for .NET. |
| Dapper | Simple object mapper for .NET |
| NHibernate | Mature, open source object-relational mapper for .NET |
| LINQ to DB | LINQ database access library |
| SqlSugar | Fluent API for querying and modifying databases |
| FreeSql | Povides APIs for querying and modifying relational databases |
| RepoDB | Hybrid ORM library for .NET |
| Venflow | Fast and lightweight ORM for PostgreSQL |
Read our verdict in the software roundup.
 Explore our carefully curated directory of recommended free and open source software, covering every major software category.The directory forms part of our extensive collection of articles for Linux enthusiasts. It includes hundreds of detailed reviews, together with free and open source alternatives to proprietary software from companies such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. LinuxLinks also covers interesting projects worth exploring, Linux-compatible hardware, free programming books and tutorials, and much more. Know a useful free and open source Linux application that we haven’t covered? Tell us about it using our submission form. |
Please read our Comment Policy before commenting.