dotnetcore / dotnetcore/FreeSql
CodeFirst 添加对分区表的支持
- Dominant language
- C#
- Stars
- 4.4k
- Forks
- 910
- PR merge metrics
- No merged PRs in 30d
Description
数据库对分区表的支持情况:
| 数据库类型 | 支持分区类型 | 版本支持情况 | 说明 |
| :-------------------------------------------------------------------------------------------------------------------------------------- | :---------------------------------------- | :--------------------------- | :--------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [MySQL](https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html) | `RANGE`、`KEY`、`HASH`、`LIST`、`COLUMNS` | `v5.1` 开始支持,`v5.7` 增强 | `LIST`、`RANGE` 在 `v5.5` 版本支持 |
| [SQL Server](https://docs.microsoft.com/zh-cn/sql/relational-databases/partitions/partitioned-tables-and-indexes?view=sql-server-ver16) | `RANGE` | 所有版本 | 比较特殊的 `RANGE` 支持,参考 [PARTITION FUNCTION](https://docs.microsoft.com/zh-cn/sql/t-sql/statements/create-partition-function-transact-sql?view=sql-server-ver16) |
| [Oracle](https://docs.oracle.com/cd/E18283_01/server.112/e16541/part_admin001.htm) | `RANGE`、`LIST`、`HASH` | `9i`版本开始有限支持 | 现在主要应用的版本是`11g+`,完全支持 |
| [PostgreSQL](https://www.postgresql.org/docs/current/ddl-partitioning.html) | `RANGE`、`LIST`、`HASH` | `v10.x` | 更早的版本也可以使用 `pg_pathman` |
| `达梦` | `RANGE`、`LIST`、`HASH` | 支持 | |
| `神通` | `RANGE`、`LIST`、`HASH` | 支持 | |
| `人大金仓` | `RANGE`、`LIST`、`HASH` | 支持 | |
| `SQLite` | 不支持 | `/` | `/` |
| `Access` | 不支持 | `/` | `/` |
| `Firebird` | 不支持 | `/` | `/` |
后续补充各数据库类型创建或修改 `RANGE` 等分区的 SQL 脚本。
Contributor guide
No contributing guide indexed for this repository
Research direction
The issue names no files, tests, or entry points. Begin by locating the CodeFirst paths for the listed database providers and their schema-generation tests; the issue's stated scope is support for creating or modifying RANGE and other partition types, but it does not define provider-specific acceptance criteria.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp, mysql, postgresql, sqlite
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100