System.Linq.Dynamic.Core 1.6.0
System.Linq.Dynamic.Core
This is a .NET Core / Standard port of the Microsoft assembly for the .Net 4.0 Dynamic language functionality.
Overview
With this library it's possible to write Dynamic LINQ queries (string based) on an IQueryable:
var query = db.Customers
.Where("City == @0 and Orders.Count >= @1", "London", 10)
.OrderBy("CompanyName")
.Select("new(CompanyName as Name, Phone)");
Useful links
Library Powered By
This library is powered by Entity Framework Extensions
Showing the top 20 packages that depend on System.Linq.Dynamic.Core.
| Packages | Downloads |
|---|---|
|
Elsa.Workflows.Management
Provides workflow management functionality.
|
11 |
|
Volo.Abp.Core
Package Description
|
9 |
|
Magicodes.IE.Excel
导入导出通用库。
官方网址：http://xin-lai.com
开源库地址:https://github.com/xin-lai
博客地址：http://www.cnblogs.com/codelove/
交流QQ群：85318032
小店地址：https://shop113059108.taobao.com/
|
9 |
|
Magicodes.IE.Excel
导入导出通用库，支持Dto导入导出、模板导出、花式导出以及动态导出，支持Excel、Csv、Word、Pdf和Html。Import and export general library, support Dto import and export, template export, fancy export and dynamic export, support Excel, Csv, Word, Pdf and Html.
开源库地址:https://github.com/xin-lai
博客地址：http://www.cnblogs.com/codelove/
公众号：麦扣聊技术
交流QQ群：85318032
**2021.01.02**
- 【Nuget】版本更新到2.5.1.3
- Add PDF support for paper size
- Add PDF support for margins [#223](https://github.com/dotnetcore/Magicodes.IE/issues/223)
**2020.12.21**
- 【Nuget】版本更新到2.5.1
- 导出支持使用ColumnIndex指定导出顺序，以导出时在某些情况下顺序不一致的问题（Export supports the use of ColumnIndex to specify the export order, so that the order is inconsistent in some cases when exporting） [#179](https://github.com/dotnetcore/Magicodes.IE/issues/179)
**2020.12.03**
- 【Nuget】版本更新到2.5.0
- Excel导出支持HeaderRowIndex [#164](https://github.com/dotnetcore/Magicodes.IE/issues/164)
- 增加Excel枚举导出对DescriptionAttribute的支持 [#168](https://github.com/dotnetcore/Magicodes.IE/issues/168)
- Excel生成导入模板支持内置数据验证[#167](https://github.com/dotnetcore/Magicodes.IE/issues/167)
- 支持数据验证
- 支持MaxLengthAttribute、MinLengthAttribute、StringLengthAttribute、RangeAttribute
- 支持输入提示
To fix The Mapping Values of The total length of a Data Validation list always exceed 255 characters (#196)(https://github.com/dotnetcore/Magicodes.IE/issues/196)
- Excel export List data type errors, and formatting issues.[#191](https://github.com/dotnetcore/Magicodes.IE/issues/191) [#193](https://github.com/dotnetcore/Magicodes.IE/issues/193)
- 导入Excel对Enum类型匹配值映射时，忽略值前后空格
- fix MappingValues The total length of a DataValidation list cannot exceed 255 characters [#196](https://github.com/dotnetcore/Magicodes.IE/issues/196)
- Excel导出List数据类型存在错误，以及格式化问题。 [#191](https://github.com/dotnetcore/Magicodes.IE/issues/191) [#193](https://github.com/dotnetcore/Magicodes.IE/issues/193)
- The ColumnIndex property does not appear to be valid in Excel import [#198](https://github.com/dotnetcore/Magicodes.IE/issues/198)
- TableStyle修改为枚举类型
|
9 |
|
Volo.Abp.Core
Package Description
|
8 |
|
Elsa.Workflows.Management
Provides workflow management functionality.
|
8 |
|
Volo.Abp.Core
Package Description
|
7 |
|
Elsa.Workflows.Management
Provides workflow management functionality.
|
7 |
|
Magicodes.IE.Excel
Import and export general library, support Dto import and export, template export, fancy export and dynamic export, support Excel, Csv, Word, Pdf and Html.
导入导出通用库，支持Dto导入导出、模板导出、花式导出以及动态导出，支持Excel、Csv、Word、Pdf和Html。
开源库地址:https://github.com/xin-lai
博客地址：http://www.cnblogs.com/codelove/
更新记录：https://github.com/dotnetcore/Magicodes.IE/blob/master/RELEASE.md
公众号：麦扣聊技术
交流QQ群：85318032
**2021.08.24**
- 添加对Abp模块的包装，具体见[#318](https://github.com/dotnetcore/Magicodes.IE/issues/318)。
**2021.08.07**
- 为了简化ASP.NET Core下的Excel导出，对Excel导出进行了进一步的封装
- 添加`Magicodes.IE.Excel.AspNetCore`工程，添加`XlsxFileResult`的Action Result，支持泛型集合、Bytes数组、Steam直接导出
- 修改部分命名和命名空间
**2021.07.23**
- 修复Excel合并行导入在存在空的合并单元格时可能的数据读取错误[#305](https://github.com/dotnetcore/Magicodes.IE/issues/305)
**2021.07.17**
- Magicodes.EPPlus回退到4.6.6，以修复格式错乱的问题
- 修复Excel仅导出错误数据时的Bug[#302](https://github.com/dotnetcore/Magicodes.IE/pull/302)
- 完善多语言[#298](https://github.com/dotnetcore/Magicodes.IE/pull/298)，以及完善单元测试
**2021.07.04**
- 模板导出支持一行多个表格[#296](https://github.com/dotnetcore/Magicodes.IE/issues/296)
|
7 |
|
Magicodes.IE.Excel
导入导出通用库。
官方网址：http://xin-lai.com
开源库地址:https://github.com/xin-lai
博客地址：http://www.cnblogs.com/codelove/
交流QQ群：85318032
小店地址：https://shop113059108.taobao.com/
|
7 |
|
Magicodes.IE.Excel
Import and export general library, support Dto import and export, template export, fancy export and dynamic export, support Excel, Csv, Word, Pdf and Html.
导入导出通用库，支持Dto导入导出、模板导出、花式导出以及动态导出，支持Excel、Csv、Word、Pdf和Html。
开源库地址:https://github.com/xin-lai
博客地址：http://www.cnblogs.com/codelove/
公众号：麦扣聊技术
交流QQ群：85318032
**2021.08.07**
- 为了简化ASP.NET Core下的Excel导出，对Excel导出进行了进一步的封装
- 添加`Magicodes.IE.Excel.AspNetCore`工程，添加`XlsxFileResult`的Action Result，支持泛型集合、Bytes数组、Steam直接导出
- 修改部分命名和命名空间
**2021.07.23**
- 修复Excel合并行导入在存在空的合并单元格时可能的数据读取错误[#305](https://github.com/dotnetcore/Magicodes.IE/issues/305)
**2021.07.17**
- Magicodes.EPPlus回退到4.6.6，以修复格式错乱的问题
- 修复Excel仅导出错误数据时的Bug[#302](https://github.com/dotnetcore/Magicodes.IE/pull/302)
- 完善多语言[#298](https://github.com/dotnetcore/Magicodes.IE/pull/298)，以及完善单元测试
**2021.07.04**
- 模板导出支持一行多个表格[#296](https://github.com/dotnetcore/Magicodes.IE/issues/296)
**2021.06.29**
- 合并PR[#295](https://github.com/dotnetcore/Magicodes.IE/pull/295),完善模板导出类型定义的问题
**2021.06.25**
- Fix only first [ColumnIndex] is valid exception[#289](https://github.com/dotnetcore/Magicodes.IE/issues/289)
**2021.06.18**
- Update ImportTestColumnIndex_Test
- Magicodes.EPPlus was upgraded to 4.6.7[#285](https://github.com/dotnetcore/Magicodes.IE/issues/285)
**2021.06.05**
- Fix ImporterHeader->ColumnIndex
- Utilize RecyclableMemoryStream instead of "new MemoryStream" all over
|
7 |
|
Magicodes.IE.Excel
导入导出通用库，通过导入导出DTO模型来控制导入和导出，支持Excel、Word、Pdf和Html。
开源库地址:https://github.com/xin-lai
博客地址：http://www.cnblogs.com/codelove/
交流QQ群：85318032
- **【Nuget】版本更新到2.2.0-beta4**
- **【Excel多Sheet导出】修复[#66](https://github.com/dotnetcore/Magicodes.IE/issues/66)，并添加单元测试**
|
7 |
|
Magicodes.IE.Excel
Import and export general library, support Dto import and export, template export, fancy export and dynamic export, support Excel, Csv, Word, Pdf and Html.
导入导出通用库，支持Dto导入导出、模板导出、花式导出以及动态导出，支持Excel、Csv、Word、Pdf和Html。
开源库地址:https://github.com/xin-lai
博客地址：http://www.cnblogs.com/codelove/
更新记录：https://github.com/dotnetcore/Magicodes.IE/blob/master/RELEASE.md
公众号：麦扣聊技术
交流QQ群：85318032
|
7 |
|
Magicodes.IE.Excel
导入导出通用库，通过导入导出DTO模型来控制导入和导出，支持Excel、Word、Csv、Pdf和Html以及动态导出。
开源库地址:https://github.com/xin-lai
博客地址：http://www.cnblogs.com/codelove/
交流QQ群：85318032
**2020.09.16**
- 【Nuget】版本更新到2.4.0-beta2
1、#152 筛选器支持依赖注入
2、#151 导出添加AutoFitMaxRows，超过指定行数则不启用AutoFit
3、添加全局IsDisableAllFilter属性，以通过特性禁用所有筛选器
**2020.09.14**
- 【Nuget】版本更新到2.4.0-beta1
1、支持单元格导出宽度设置
2、Excel导出支持对Enum的ValueMapping设置
3、Excel导出支持对bool类型的ValueMapping设置
|
7 |
|
Magicodes.IE.Excel
导入导出通用库，通过导入导出DTO模型来控制导入和导出，支持Excel、Word、Pdf和Html。
开源库地址:https://github.com/xin-lai
博客地址：http://www.cnblogs.com/codelove/
交流QQ群：85318032
|
7 |
Bugfixes and new Features. For details see CHANGELOG.md
.NET Framework 3.5
- NetLegacySupport.ConcurrentDictionary (>= 1.1.1)
.NET Standard 2.1
- No dependencies.
.NET Standard 2.0
- System.Reflection.Emit (>= 4.3.0)
.NET 9.0
- No dependencies.
.NET 7.0
- No dependencies.
.NET 6.0
- No dependencies.
.NET 5.0
- No dependencies.
.NET Core 3.1
- No dependencies.
.NET Core 2.1
- No dependencies.
UAP 10.0.10240
- System.Diagnostics.TraceSource (>= 4.0.0)
- System.ComponentModel.TypeConverter (>= 4.1.0)
- Microsoft.NETCore.UniversalWindowsPlatform (>= 6.0.10)
.NET 8.0
- No dependencies.
.NET Standard 1.3
- System.Reflection.Emit (>= 4.3.0)
- System.Reflection.TypeExtensions (>= 4.3.0)
- System.ComponentModel.TypeConverter (>= 4.3.0)
- System.Diagnostics.TraceSource (>= 4.3.0)
- System.Dynamic.Runtime (>= 4.3.0)
- System.Linq.Queryable (>= 4.3.0)
- NETStandard.Library (>= 1.6.1)
.NET Framework 4.0
- No dependencies.
.NET Framework 4.5.2
- No dependencies.
.NET Framework 4.6
- No dependencies.
.NET Framework 4.5
- No dependencies.
| Version | Downloads | Last updated |
|---|---|---|
| 1.6.6 | 0 | 2025/6/11 |
| 1.6.5 | 4 | 2025/5/29 |
| 1.6.4 | 4 | 2025/5/26 |
| 1.6.3 | 2 | 2025/6/2 |
| 1.6.2 | 2 | 2025/6/1 |
| 1.6.0.2 | 1 | 2025/6/3 |
| 1.6.0.1 | 1 | 2025/6/3 |
| 1.6.0 | 1 | 2025/6/3 |
| 1.6.0-preview-03 | 5 | 2025/5/27 |
| 1.6.0-preview-02 | 2 | 2025/5/28 |
| 1.6.0-preview-01 | 1 | 2025/5/27 |
| 1.5.1 | 2 | 2025/6/2 |
| 1.5.0 | 3 | 2025/6/3 |
| 1.4.9 | 7 | 2025/5/28 |
| 1.4.8 | 2 | 2025/5/28 |
| 1.4.7 | 1 | 2025/5/28 |
| 1.4.6 | 2 | 2025/5/28 |
| 1.4.5 | 2 | 2025/6/2 |
| 1.4.4 | 1 | 2025/5/28 |
| 1.4.3 | 1 | 2025/5/27 |
| 1.4.2 | 1 | 2025/5/28 |
| 1.4.1 | 3 | 2025/5/27 |
| 1.4.0 | 2 | 2025/5/28 |
| 1.3.14 | 2 | 2025/6/2 |
| 1.3.13 | 2 | 2025/6/2 |
| 1.3.12 | 1 | 2025/6/2 |
| 1.3.10 | 2 | 2025/6/2 |
| 1.3.9 | 2 | 2025/6/2 |
| 1.3.9-preview-02 | 1 | 2025/5/27 |
| 1.3.9-preview-01 | 2 | 2025/5/27 |
| 1.3.8 | 1 | 2025/6/2 |
| 1.3.7 | 1 | 2025/6/2 |
| 1.3.6 | 3 | 2025/6/2 |
| 1.3.5 | 1 | 2025/6/2 |
| 1.3.4 | 2 | 2025/5/28 |
| 1.3.3 | 1 | 2025/5/28 |
| 1.3.2 | 6 | 2025/5/28 |
| 1.3.1 | 2 | 2025/5/27 |
| 1.3.0 | 2 | 2025/6/2 |
| 1.2.25 | 1 | 2025/6/2 |
| 1.2.24 | 2 | 2025/6/2 |
| 1.2.23 | 2 | 2025/6/2 |
| 1.2.22 | 2 | 2025/6/2 |
| 1.2.21 | 1 | 2025/5/28 |
| 1.2.20 | 5 | 2025/5/27 |
| 1.2.20-preview-01 | 1 | 2025/5/27 |
| 1.2.19 | 7 | 2025/5/27 |
| 1.2.18 | 6 | 2025/6/2 |
| 1.2.17 | 2 | 2025/6/2 |
| 1.2.16 | 1 | 2025/5/28 |
| 1.2.15 | 2 | 2025/6/2 |
| 1.2.14 | 2 | 2025/5/28 |
| 1.2.13 | 2 | 2025/5/27 |
| 1.2.12 | 1 | 2025/5/28 |
| 1.2.11 | 1 | 2025/5/28 |
| 1.2.10 | 1 | 2025/6/2 |
| 1.2.9 | 2 | 2025/6/2 |
| 1.2.8 | 2 | 2025/5/27 |
| 1.2.7 | 6 | 2025/6/2 |
| 1.2.7-preview-03 | 1 | 2025/5/27 |
| 1.2.7-preview-02 | 2 | 2025/5/27 |
| 1.2.7-preview-01 | 2 | 2025/5/27 |
| 1.2.6 | 1 | 2025/6/2 |
| 1.2.6-preview-01 | 2 | 2025/5/28 |
| 1.2.5 | 1 | 2025/6/2 |
| 1.2.4 | 1 | 2025/5/28 |
| 1.2.3 | 2 | 2025/5/28 |
| 1.2.2 | 2 | 2025/5/28 |
| 1.2.1 | 2 | 2025/5/28 |
| 1.2.0 | 2 | 2025/6/2 |
| 1.1.8 | 3 | 2025/5/28 |
| 1.1.7 | 5 | 2025/5/28 |
| 1.1.6 | 7 | 2025/6/2 |
| 1.1.5 | 2 | 2025/6/2 |
| 1.1.4 | 1 | 2025/5/28 |
| 1.1.3 | 1 | 2025/5/28 |
| 1.1.2 | 1 | 2025/5/28 |
| 1.1.1 | 1 | 2025/5/28 |
| 1.1.0 | 1 | 2025/5/28 |
| 1.0.24 | 1 | 2025/6/2 |
| 1.0.23 | 2 | 2025/6/3 |
| 1.0.22 | 3 | 2025/6/2 |
| 1.0.21 | 1 | 2025/6/2 |
| 1.0.20 | 2 | 2025/5/28 |
| 1.0.19 | 3 | 2025/6/2 |
| 1.0.18 | 1 | 2025/6/2 |
| 1.0.17 | 8 | 2025/6/2 |
| 1.0.16 | 2 | 2025/6/2 |
| 1.0.15 | 2 | 2025/6/2 |
| 1.0.14 | 1 | 2025/6/2 |
| 1.0.13 | 5 | 2025/6/3 |
| 1.0.12 | 9 | 2025/6/2 |
| 1.0.11 | 2 | 2025/6/2 |
| 1.0.10 | 2 | 2025/6/2 |
| 1.0.9.2 | 2 | 2025/6/3 |
| 1.0.9.1 | 4 | 2025/6/3 |
| 1.0.9 | 1 | 2025/6/3 |
| 1.0.8.18 | 2 | 2025/6/3 |
| 1.0.8.17 | 2 | 2025/6/3 |
| 1.0.8.16 | 3 | 2025/6/3 |
| 1.0.8.15 | 1 | 2025/6/4 |
| 1.0.8.14 | 1 | 2025/6/3 |
| 1.0.8.13 | 2 | 2025/6/4 |
| 1.0.8.12 | 1 | 2025/6/3 |
| 1.0.8.11 | 1 | 2025/5/27 |
| 1.0.8.10 | 2 | 2025/6/3 |
| 1.0.8.9 | 1 | 2025/6/4 |
| 1.0.8.8 | 1 | 2025/6/3 |
| 1.0.8.7 | 1 | 2025/6/3 |
| 1.0.8.6 | 2 | 2025/6/4 |
| 1.0.8.5 | 2 | 2025/6/4 |
| 1.0.8.3 | 1 | 2025/6/3 |
| 1.0.8.2 | 2 | 2025/6/3 |
| 1.0.8.1 | 1 | 2025/5/27 |
| 1.0.8 | 2 | 2025/6/2 |
| 1.0.7.13 | 1 | 2025/6/4 |
| 1.0.7.12 | 2 | 2025/6/3 |
| 1.0.7.11 | 1 | 2025/6/3 |
| 1.0.7.10 | 1 | 2025/6/3 |
| 1.0.7.9 | 4 | 2025/6/4 |
| 1.0.7.7 | 1 | 2025/6/3 |
| 1.0.7.6 | 5 | 2025/6/4 |
| 1.0.7.5 | 2 | 2025/6/4 |
| 1.0.7.4 | 6 | 2025/6/2 |
| 1.0.7.3 | 1 | 2025/6/3 |
| 1.0.7.2 | 2 | 2025/6/3 |
| 1.0.7.1 | 7 | 2025/6/3 |
| 1.0.7 | 1 | 2025/6/2 |
| 1.0.6.13 | 1 | 2025/6/5 |
| 1.0.6.12 | 2 | 2025/6/4 |
| 1.0.6.11 | 2 | 2025/6/3 |
| 1.0.6.10 | 1 | 2025/6/4 |
| 1.0.6.9 | 1 | 2025/5/28 |
| 1.0.6.8 | 4 | 2025/6/4 |
| 1.0.6.7 | 2 | 2025/5/29 |
| 1.0.6.6 | 2 | 2025/6/4 |
| 1.0.6.5 | 1 | 2025/5/28 |
| 1.0.6.4 | 10 | 2025/6/3 |
| 1.0.6.3 | 2 | 2025/6/3 |
| 1.0.6.2 | 1 | 2025/5/28 |
| 1.0.6.1 | 1 | 2025/6/3 |
| 1.0.6 | 1 | 2025/6/2 |
| 1.0.5.4 | 1 | 2025/6/3 |
| 1.0.5.3 | 9 | 2025/6/4 |
| 1.0.5.2 | 2 | 2025/6/3 |
| 1.0.5.1 | 1 | 2025/6/3 |
| 1.0.5 | 1 | 2025/6/3 |
| 1.0.4 | 3 | 2025/5/27 |
| 1.0.3.4 | 0 | 2016/6/8 |
| 1.0.3.3 | 1 | 2025/6/3 |
| 1.0.3.2 | 1 | 2025/6/3 |
| 1.0.3.1 | 1 | 2025/6/2 |
| 1.0.3 | 1 | 2025/6/2 |
| 1.0.2.3 | 2 | 2025/6/2 |
| 1.0.2.2 | 7 | 2025/6/2 |
| 1.0.2 | 1 | 2025/5/27 |
| 1.0.1 | 1 | 2025/5/28 |
| 1.0.0 | 1 | 2025/6/2 |