[技术]-没有 ORM 的架构

USE [lysk2] GO /****** Object: StoredProcedure [dbo].[P_EvacuateNodes] Script Date: 2023/11/30 8:25:41 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER proc [dbo].[P_EvacuateNodes] @node int = 999 as begin truncate table CalStartTab; EXEC P_CalculateStartProc @node; truncate table CalEndTab; EXEC P_CalculateEndProc @node; truncate table EvacEvenNodesTab; insert into EvacEvenNodesTab SELECT tp.* FROM ( SELECT TOP 100 PERCENT ROW_NUMBER() OVER ( partition BY ddid ORDER BY wtime ) AS rowNum, sid, tid, ygid, wtime, ddid FROM WFRecord WHERE id IN ( SELECT id FROM WFRecord wf INNER JOIN CalStartTab s ON wf.ddid = s.ddid INNER JOIN CalEndTab e ON wf.ddid = e.ddid WHERE ( sid = @node OR tid = @node ) AND wtime >= s.minTime AND wtime <= e.maxTime GROUP BY wf.ddid, wf.id ) ORDER BY wtime ) tp WHERE tp.rowNum % 2 = 0 truncate table EvacOddNodesTab; insert into EvacOddNodesTab SELECT tp.* FROM ( SELECT TOP 100 PERCENT ROW_NUMBER() OVER ( partition BY ddid ORDER BY wtime ) AS rowNum, sid, tid, ygid, wtime, ddid FROM WFRecord WHERE id IN ( SELECT id FROM WFRecord wf INNER JOIN CalStartTab s ON wf.ddid = s.ddid INNER JOIN CalEndTab e ON wf.ddid = e.ddid WHERE ( sid = @node OR tid = @node ) AND wtime >= s.minTime AND wtime <= e.maxTime GROUP BY wf.ddid, wf.id ) ORDER BY wtime ) tp WHERE tp.rowNum % 2 = 1 end 

突然翻到之前自己写的存储过程 现在看看都是头皮发麻 公司框架用的还是 .Net Framework 4.5

直接用 CYQ.Data 和数据库交互 sql 中 order by 还失效 必须先查询加载到内存后再排序

之前一直用的是 EF 或者 EF Core 也用过 SqlSugar 这样的第三方框架