89

Home

IGeekFan edited this page 2023-11-22 20:03:36 +08:00

Table of Contents

• FreeSql
• Features
• Guide
• Getting Started
• Deep Learning
• Advanced
• WeChat

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

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.

Basic

• 入门 Getting Started
• 安装 How to Install
• 添加 Insert Data
  • 单条 Single
  • 批量 Batch
• 删除 Delete Data
• 修改 Update Data
  • 更新实体 Entity
  • 更新指定列 Specified Columns
• 添加或修改 Insert or Update ✨
• 查询 Query Data
  • 分页 Pagination
  • 单表 Single Table
  • 多表 Multi Tables
  • 分组聚合 Group Aggregation
  • 嵌套查询 Nested Query ✨
  • 联合查询
  • 返回数据 Return Data ✨
  • 延时加载 Lazy Loading
  • 贪婪加载 Greed Loading ✨
  • LINQ 扩展 LinqToSql
  • 树型查询 Parent-Child Relp. ✨
• 仓储层 Repository Layer
  • 工作单元 Unit of Work
  • 联级保存 Cascade Saving
  • 联级删除 Cascade Deletion
  • 工作单元管理器 ✨
  • 聚合根（实验室）
• CodeFirst
  • 实体特性✨
  • FluentApi
  • 自定义特性
  • 类型映射
  • 导航属性 Entity Relationship ✨
  • 迁移结构
• DbFirst
• 表达式函数
  • 字符串
  • 日期/时间
  • 其他
  • 自定义函数
• 事务
• 过滤器
• ADO
• AOP✨
• 读写分离
• 分表分库
• 租户
• 性能
• 动态操作 Dynamic Operations
• 你不知道的功能✨
• API参考

使用指南

• Dapper比较
• EntityFramework比较

学习与交流

• 常见问题
• 提交Issues

信息

• 服务支持
• 更新日志