SmartSql V3 Update

SmartSql V3 Update

The lightest ORM in history! 107kb

Update content

1. Remove Dapper dependency
2. Support stored procedures
3. Enhanced extensibility
4. Refactoring code
5. Optimal cache trigger strategy
6. Dynamic implementation of Repository interface
7. Support Parameter & Result Map & TypeHandler
8. High performance

Performance evaluation

BenchmarkDotNet=v0.10.14, OS=Windows 10.0.17134
Intel Core i7-6700K CPU 4.00GHz (Skylake), 1 CPU, 8 logical and 4 physical cores
.NET Core SDK=2.1.201
  [Host]     : .NET Core 2.0.7 (CoreCLR 4.6.26328.01, CoreFX 4.6.26403.03), 64bit RyuJIT
  DefaultJob : .NET Core 2.0.7 (CoreCLR 4.6.26328.01, CoreFX 4.6.26403.03), 64bit RyuJIT

ORM	Type	Method	Return	Mean	Error	StdDev	Rank	Gen 0	Gen 1	Gen 2	Allocated
Native	NativeBenchmarks	Query_GetValue_DbNull	IEnumerable`1	78.39 ms	0.8935 ms	0.7921 ms	1	3000.0000	1125.0000	500.0000	15.97 MB
SmartSql	SmartSqlBenchmarks	Query	IEnumerable`1	78.46 ms	0.2402 ms	0.1875 ms	1	2312.5000	1000.0000	312.5000	12.92 MB
SmartSqlDapper	SmartSqlDapperBenchmarks	Query	IEnumerable`1	78.65 ms	1.2094 ms	1.1312 ms	1	3687.5000	1437.5000	687.5000	19.03 MB
Native	NativeBenchmarks	Query_IsDBNull_GetValue	IEnumerable`1	78.84 ms	0.8984 ms	0.7502 ms	1	2312.5000	1000.0000	312.5000	12.92 MB
Dapper	DapperBenchmarks	Query	IEnumerable`1	79.00 ms	1.0949 ms	0.9706 ms	1	3312.5000	1312.5000	625.0000	17.19 MB
EF	EFBenchmarks	Query	IEnumerable`1	79.44 ms	1.6880 ms	1.5789 ms	1	6250.0000	-	-	26.05 MB
SqlSugar	SqlSugarBenchmarks	Query	IEnumerable`1	81.09 ms	0.8718 ms	0.7728 ms	2	2187.5000	875.0000	250.0000	12.64 MB
Chloe	ChloeBenchmarks	Query	IEnumerable`1	83.86 ms	1.2714 ms	1.1893 ms	3	2250.0000	937.5000	312.5000	12.62 MB
EF	EFBenchmarks	SqlQuery	IEnumerable`1	89.11 ms	0.7562 ms	0.6314 ms	4	8187.5000	125.0000	-	33.68 MB
EF	EFBenchmarks	Query_NoTracking	IEnumerable`1	93.13 ms	0.8458 ms	0.7912 ms	5	5875.0000	2250.0000	1062.5000	29.71 MB
EF	EFBenchmarks	SqlQuery_NoTracking	IEnumerable`1	106.89 ms	1.0998 ms	1.0288 ms	6	7437.5000	2875.0000	1312.5000	37.34 MB

v2.3.2

1. remove In Tag Attribute
2. add TransactionWrap Extend
3. fix cache bug
4. For tag support object instance.

v2.2.6

• add Placeholder Tag.
• add Set Tag.

v2.2.1

0. support Dynamic Tag nest Include Tag.
1. fixed [IsGreaterEqual/IsLessEqual/IsLessThan tag] null reference bug.
2. fixed [IsProperty tag] IsCondition bug .
3. fixed RequestContext.Request bug.

v2.2.0

0. add [For Tag] to support iterate.
1. add support global parameter prefix (defalut=$).
2. add [Env Tag] to support different DBProvider.
3. update Schemas to support above features.
4. fixed [IsGreaterEqual Tag] has childTag throw error

v2.2.0-preview

0. add [For Tag] to support iterate.
1. add support global parameter prefix (defalut=$).
2. add [Env Tag] to support different DBProvider.
3. update Schemas to support above features.

v2.0.18.8

• 1. add IsNotEmpty & IsEmpty Tag array judge
• 2. support DynamicParameters for RequestContext.Request .
• 3. fixed cache invalidation problem after used DynamicParameters for RequestContext.Request .

v2.0.18.2

1. remove RequestContext. Items & Response Property

v2.0.15

1. fixed cache (FIFO & LRU) no FlushInterval parameter throw exception.
2. add support for unlimited nesting of Include tags.
3. fixed the first Child Tag [Dynamic Tag] is [Include Tag] problem.
4. add support for Include tag Prepend properties.
5. fixed partial cache hit invalidation when requested include IEnumerable type parameters
6. fixed a problem with the SmartSql local file hot update in some scenes that could not get the configuration file.

v2.0.8

1. Fixed cache (FIFO & LRU) not removed after maximum size.

2. Optimizing lock related functions.