EFFC.Extends.LinqDLR2SQL
1.1.1
dotnet add package EFFC.Extends.LinqDLR2SQL --version 1.1.1
NuGet\Install-Package EFFC.Extends.LinqDLR2SQL -Version 1.1.1
<PackageReference Include="EFFC.Extends.LinqDLR2SQL" Version="1.1.1" />
paket add EFFC.Extends.LinqDLR2SQL --version 1.1.1
#r "nuget: EFFC.Extends.LinqDLR2SQL, 1.1.1"
// Install EFFC.Extends.LinqDLR2SQL as a Cake Addin #addin nuget:?package=EFFC.Extends.LinqDLR2SQL&version=1.1.1 // Install EFFC.Extends.LinqDLR2SQL as a Cake Tool #tool nuget:?package=EFFC.Extends.LinqDLR2SQL&version=1.1.1
E.F.F.C Extends Lib
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp2.1 is compatible. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
-
.NETCoreApp 2.1
- EFFC.Frame.Net.Base (>= 1.1.1)
NuGet packages (2)
Showing the top 2 NuGet packages that depend on EFFC.Extends.LinqDLR2SQL:
Package | Downloads |
---|---|
EFFC.Frame.Net.Unit.DB
E.F.F.C Frame Unit DB Lib |
|
EFFC.Frame.Net.Module.Business
E.F.F.C Frame Module Business Definition |
GitHub repositories
This package is not used by any popular GitHub repositories.
Efficiency Focus For Core(效率、专注为核心)框架应用于.Net Core第一版发布
本包为扩展库包含较为独立的工具使用扩展模块
1.0.0:本库用于实现将Lamda转为SQL,与Linq2SQL不同,该lib通过dynamic的虚拟方式实现lamda转为sql,不通过model的定义来实现,并且只实现转为sql但并不执行DB操作
1.0.0:通过dynamic技术,采用虚拟model方式将lamda表达式转化为sql的技术实现,于2017/12/28发布第一版
1.0.1:提供ILinqDLRSQLGenerator作为LinqDLR2SQL用于sql生成的扩展接口;新增Take、Count、Sum、Max、Min操作;
生成的sql的参数名称由原来的根据时间生成的唯一码改为通过4位随机数来替代,从而缩短sql的长度和可读性;
修正执行from t in DB.LamdaTable("a") where t.id==1 select t这种单表带where情况下无法生成sql的bug
1.0.2:新增新增对Oracle的支持
1.0.3:LinqDLRColumn新增concat的方法支持,可用于将本栏位与参数中的对象执行字符串拼接操作
1.0.4:OracleDLRColumn的栏位引用符号改为空,不需要栏位引用符号
1.0.5:OracleDLRColumn修正WhereIn的处理逻辑不正确的问题
引用库EFFC.Frame.Net.Base升级到1.0.6
LamdaSQLObject新增toFunction的方法,用于构造sql中的function表达式
1.1.0:升级.netcore到2.1.2
1.1.1:
Base库升级到1.1.1
重整LinqDRL2SQL的基础架构,增强扩展能力
添加Groupby的操作
ToSql后清除prefix和pearfix增加表达式的可以再次使用
解决join时候,多个同表名不同别名未join上的情况
LinqDLRColumn新增avg方法,LinqDLR2Sql新增avg方法,LinqDLR2SQLGenerator新增DoAvg方法