search

dotnetcore / sharding-core

high performance lightweight solution for efcore sharding table and sharding database support read-write-separation .一款ef-core下高性能、轻量级针对分表分库读写分离的解决方案，具有零依赖、零学习成本、零业务代码入侵
https://xuejmnet.github.io/sharding-core-doc/
Apache License 2.0
1.17k stars 171 forks source link

SqlServer 创建Sequence 导致建库时分表无法创建 #274

Closed 519711862 closed 2 months ago

519711862 commented 3 months ago

企业微信截图_17248147058492

xuejmnet commented 2 months ago

经测试发现Wafer_Id_Sque序列会在多个dbcontext中不断创建,所以目前来讲没有好的办法来处理,建议这边单独执行数据库脚本

 CREATE SEQUENCE [My_Id_Sque] START WITH 0 INCREMENT BY 1 NO MINVALUE NO MAXVALUE NO CYCLE;
519711862 commented 2 months ago

好的，非常感谢