Skip to content

Changelog ​

v3 — .NET 6+ ​

v8.0.0.2 — 2026-01-22 ​

Deprecated

  • useEnityAnalyser → use useEntityAnalyser.
  • BatchSQL.DBInstance → use DBLive; rows removed.

SQLBuilder

  • findIsExist (existence by key).
  • queryRowT aligned with queryUnique.
  • update / insert / save extensions use isolated context.
  • sinkNot, sinkNotOR for negated groups.
  • Nullable-friendly helpers: whereNotLikeOrNull, whereNotLikeLeftOrNull, whereNotInOrNull, whereIsOrNull, whereVsOrNull, etc.

Other

  • BatchSQL.print, broader transaction bridging.
  • ClientBuilder.useDialect for quick dialect registration.
  • BaseClientBuilder.useEntityTranslate — order-independent secondary registration.
  • Repository custom filters: op supports not in, is null, not null, between.
  • EntityTranslator hooks around insert/update/delete SQL.
  • DataTable groupBy overload — two-level dictionary aggregation.

v8.0.0.1 — 2026-01-08 ​

Fixes

  • Bulk write edge case under heavy loops.
  • Auth: empty-permission handling; hierarchy binding fixes.

Features

  • Expression field-name cache; translator improvements.
  • Navigation load/save, includeHis, includeNav.
  • Driver: batched commands; DBLive ExeNonQuery overloads.
  • SaveRange on repository.
  • Collection helpers: groupByKV, writeTo, string.formatSQL, DataTable getFieldValues / groupBy, reduce / sum.
  • Entity: save/toSave batch, removeByIds, findList overloads, findTreeParentOIDs.
  • SQLBuilder: selectFormat, fromFormat, joinFormat, countLong, whereNotLikeLeft.
  • Para.toRawSQL.
  • SQLClip: distinct.
  • Excel import: better boolean columns.
  • TreeSQLBuilder: auth hooks.

2025-11-26 ​

Fixes

  • Fast LINQ variable capture.

Features

  • Custom table names (repo + Clip).
  • Connection slot version for entity mapping.
  • Import history hook.
  • find paging / field-value extensions.
  • BatchSQL + Clip helpers.
  • DB command parameter hooks.
  • Slow-SQL monitoring (config + listeners + multi-event registration on client build).

Improvements

  • DBNull ↔ SQL NULL.
  • Excel merged cells / formulas.

2025-10-23 — Entity SQL ​

Fixes

  • SQL Server bulk + transaction.

SQLBuilder

  • EntitySaveBase family (vs updatable()).
  • updatable / insertable / deleteable.
  • Unified client config under Client.
  • SQLBuilder.ifs extended.

2025-10-18 — Bulk ​

  • Entity bulk insert via BulkBase.addList.
  • Bulk + transactions.
  • useBulk factory.
  • SQLBuilder.insertList.
  • groupBy extensions.
  • containSetColumn.

2025-09-15 ​

  • Entity ordering attributes.
  • SQLClip join subqueries; where extensions.
  • Repository OnBuildSQL hook.
  • Default TreeSQLBuilder.
  • SQLBuilder.configClear().
  • Keyword column quoting for entities.
  • whereNotBetween.

2025-08-31 ​

  • find / modify / remove SQLClip shortcuts.
  • Join subqueries in SQLClip.
  • Anonymous type projection.
  • withSelect for CTEs.

2025-08-20 ​

  • MERGE improvements; MySQL fallback to insert/update.
  • Dedicated MERGE builder.
  • UPDATE FROM construction for MySQL.
  • pivot — multiple pivot calls.

2025-08-08 ​

  • Paging SQL tuned by DB version (MySQL / SQL Server / PostgreSQL).

2025-07-31 ​

  • Parameter templates: #{id} style; heterogeneous parameter prefixes.

2025-07-28 ​

  • SQLClip field resolution cache (~10× faster in typical cases).

2025-07-15 ​

  • Executor-level transactions; DBExecutor.
  • SQLBuilder: beginTransaction, commit, rollback.

2025-07-07 — breaking ​

  • ICache → SooCache.
  • LogLevel → LogLv.
  • SooLink foreign-key metadata.
  • Repository + Clip API expansion (GetTreeList, GetChildList, …).

2025-06-15 ​

  • Client factory for SQLBuilder / repo / Clip.

2025-06-02 ​

  • LINQ extension cleanup.

2025-05-22 ​

  • SQLClip released.

2025-01-03 ​

  • SooRepository, SooUnitOfWork, DbBus (fast LINQ).

2024-11-12 ​

-Queryable expressions.

2024-10-16 ​

  • Primary/replica, auth improvements, entity parsing.

2024-09-21 ​

  • Entity parsing + query executor; SqlSugar attribute compatibility.

2024-07-10 ​

  • CTEs; LINQ work started.

2024-04-20 ​

  • WHERE enhancements; generic auth (words, resources, visitors); fluent config.

2023-12-29 ​

  • queryT entity mapping; DialectSentence.

2023-11-30 ​

  • whereIn, addPara, merge fixes, SQLCreator, whereInGuid, whereNotExist, whereGuid, whereBetween, whereOR, withAs, onParaValueCheck, TypeAs, DataTable/DataRow helpers, MooClient + events.

2023-09-22 ​

  • Pivot EXISTS; where delegates; removed Newtonsoft from core; import refactor.

2023-07-31 ​

  • Dialect bulk insert; mergeInto; MatchBulk fixes; BulkBase / EditTable.

2023-07-03 ​

  • mooSQL generalization started.

v2 — framework U7 ​

  • Core executor, dialect architecture, SQLBuilder core.

v1 — transition ​

Replaced strSQLMaker (weak transactions, SQL Server–centric).

v0 — strSQLMaker ​

Legacy change log (2021) — existence checks, MatchBulk, ModifyHelper, pooling, transactions, etc.