Linq.Extension 3.5.1

• net6.0

  • Microsoft.EntityFrameworkCore (>= 6.0.31)
  • Newtonsoft.Json (>= 13.0.2)

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.