Linq.Extension 3.8.0

There is a newer version of this package available.
See the version list below for details.
dotnet add package Linq.Extension --version 3.8.0                
NuGet\Install-Package Linq.Extension -Version 3.8.0                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Linq.Extension" Version="3.8.0" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Linq.Extension --version 3.8.0                
#r "nuget: Linq.Extension, 3.8.0"                
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install Linq.Extension as a Cake Addin
#addin nuget:?package=Linq.Extension&version=3.8.0

// Install Linq.Extension as a Cake Tool
#tool nuget:?package=Linq.Extension&version=3.8.0                

3.8.0 Added Delimiter for field names and field values for DistinctBy, GroupBy, and GroupByOperationOn. Default value for delimiters will be comma (,) and these fields are string, so we can pass more than one character for delimiter, this is particularly helpful in field values as comma (,) can be in the values it self.

3.7.0.1 Changed parameters type to IDictionary in GetListOfGroupValuePair

3.7.0 Added GroupByOperationOn classes and methods. This will provide option to group by on multiple fields (, separated fields) and then perform an operation like count, sum, max or min on another field. Also provide option to apply where and pagination on group by.

3.6.5 Added overloaded methods for Where and WhereWithDistinctBy for RelationIds

3.6.4 Added overloaded methods for DistinctBySelect, DistinctBy, GetSearch, GetPagination, GetDistinctBy, and GetGroupBy methods.

3.6.3 Added GetSearch, GetPagination, GetDistinctBy, GetGroupBy methods.

3.6.2 Added overloaded extension method for DistinctBy which will take dictionary of objects with one of type DistinctByInput or pass DistinctByInput and if that object of DistinctByInput contains Search and Pagination properties then apply them. Also, applied search in GroupBy if groupby object contains Search property.

3.6.1 Added overloaded extension methods for GroupBy and fix error in DistinctIf to check if key is present in Dictionary

3.6.0 Added dynamic GroupBy which takes field names as list of string or delimited strings.

3.5.1 Added overloaded Extension methods for WhereWithDistinctBy, SortBy, Take, Skip and DisinctIf to take dictionary of string and object pair to get DistinctBy object or Pagination object instead of passing actual type.

3.5.0 Added Where Extension Methods. Added EF Core DistinctBy Extension Method which List of original type, also added WhereWithDistinctBy which will fetch list of data from distinct by and convert into where expression and then combine it with rest of where expression to make one combine where predicate.

3.4.0 Added DistinctBySelect which takes comma separted fieldnames as string or list of string for fieldnames and generate distinct select query on input fields only. Also, added distinct extension method which takes bool input distinct with default to true and generate distinct query. Aslo, added distinct bool input to Pagination extension method with default to false and it applies distinct if input is true before sort, take and skip.

3.3.1 Added Select extension methods for Dynamic Select Generator as actual type of Entity or Dynamic type.

3.3.0 Added Dynamic Select Generator expression which return actual type instead of Dynamic type, also added IEnumerable DistinctBy.

Updated Dynamic Where Predicate. Now generated sql will not have case statements in where condition.

Added Child Groups in FilterGroupInput this will allow to create nested 'Parenthesis' () in generated SQL queries. ChildGroups is type of List of FilterGroupInput so it'll generated 'Parenthesis' () with in 'Parenthesis' () recursively. Excluded the proprties which doesn't exists in the resultset in SortBy extension method. Also, in case of exception return the source. Fix the sort on nullable fields. Added dynamic Group By with list of strings as names of the fields Group By on. Major change. Added Filter Groups. This allow to create SQL queries with 'Parenthesis' () and separate And/Or groups with () in SQL.

Product Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
3.8.1 153 6/27/2024
3.8.0 101 6/26/2024
3.7.0.1 104 6/25/2024
3.7.0 101 6/25/2024
3.6.5 105 6/20/2024
3.6.4 123 6/16/2024
3.6.3 108 6/16/2024
3.6.2 120 6/16/2024
3.6.1 120 6/16/2024
3.6.0 122 6/16/2024
3.5.1 130 6/16/2024
3.5.0 112 6/15/2024
3.4.0 114 6/12/2024
3.3.1 106 6/12/2024
3.3.0 135 6/12/2024
3.2.0 282 7/12/2023
3.1.0 155 6/27/2023
3.0.2 157 6/24/2023
3.0.1 161 6/10/2023
3.0.0 249 3/5/2023
2.0.1.2 326 2/26/2023
2.0.1.1 335 2/23/2023
2.0.1 281 2/23/2023
2.0.0.1 305 1/19/2023
2.0.0 294 1/19/2023
1.0.0.9 340 11/27/2022
1.0.0.8 339 11/27/2022
1.0.0.7 510 10/4/2020
1.0.0.5 790 7/30/2020
1.0.0.4 460 7/29/2020
1.0.0.3 500 7/29/2020
1.0.0.2 466 7/28/2020
1.0.0.1 466 7/28/2020
1.0.0 485 7/27/2020

3.8.0 Added Delimiter for field names and field values for DistinctBy, GroupBy, and GroupByOperationOn. Default value for delimiters will be comma (,) and these fields are string, so we can pass more than one character for delimiter, this is particularly helpful in field values as comma (,) can be in the values it self.