Home

FreeSql

中文 | English

FreeSql is a powerful .NET ORM that supports all .NET Standard runtime platforms like .NET Framework 4.0+, .NET Core 2.1+, Xamarin and AOT, etc.

QQ Groups：4336577(full)、8578575(full)、52508226(full)

Features

• 🛠 Support CodeFirst data migration.
• 💻 Support DbFirst import entity class from database, or use Generation Tool.
• ⛳ Support advanced type mapping, such as PostgreSQL array type, etc.
• 🌲 Support expression functions, and customizable analysis.
• 🏁 Support one-to-many and many-to-many navigation properties, include and lazy loading.
• 📃 Support Read/Write separation, Splitting Table/Database, Global filters, Optimistic and pessimistic locker.
• 🌳 Support MySql/SqlServer/PostgreSQL/Oracle/Sqlite/Firebird/达梦/人大金仓/神舟通用/南大通用/虚谷/翰高/Access/ClickHouse/QuestDB, etc.

Guide

FreeSql supports basic CURD. In addition, it also supports creating models based on existing databases (DbFirst), and supports creating databases based on models (CodeFirst).

Getting Started

• 《FreeSql 101, Part 1: Insert Data》
• 《FreeSql 101, Part 2: Delete Data》
• 《FreeSql 101, Part 3: Update Data》
• 《FreeSql 101, Part 4: Query Data》
• 《Repository Layer》

Deep Learning

• 🚧 《Introduction to Codefirst Mode》
  • 🚧 《CodeFirst Mode, Part 1: Entity Attributes》
  • 🚧 《CodeFirst Mode, Part 2: FluentApi》
  • 🚧 《CodeFirst Mode, Part 3: Custom Attributes》
  • 🚧 《CodeFirst Mode, Part 4: Type Mapping》
  • 🚧 《CodeFirst Mode, Part 5: Entity Relationship》
  • 🚧 《CodeFirst Mode, Part 6: Migration Structure》
• 🚧 《Introduction to DbFirst Mode》

Advanced

• 🚧 《Database Transaction》
• 🚧 《Using Read/Write Separation》
• 🚧 《Sharding Tables and Database》
• 🚧 《Tenant》
• 🚧 《Return Data》
• 🚧 《FreeSql Optimization: Lazy Loading》
• 🚧 《FreeSql Optimization: Greed Loading》
• 🚧 《Expression Function》
• 🚧 《ADO》
• 🚧 《AOP》

WeChat

Welcome to follow on Wechat dotNET搬砖队, we will share information about .NET Core and FreeSql.