Dynamic Linq for SQL MIN() function

dynamic-linq linq sql

Question

Original SQL looks like:

SELECT MIN(ID) AS GeoID, MIN(PostalCode), PlaceName
    FROM GeoData_ALL
    GROUP BY CountryCode, PlaceName
    ORDER BY PlaceName

I need to translate it in Dynamic Linq, something like:

var searchResult = db.Set(GeoData)
    .AsQueryable()
    .OrderBy("PlaceName")
    .GroupBy("CountryCode", "PlaceName")
    .Select("new (MIN(ID) AS GeoID, MIN(PostalCode), PlaceName");

Unfortunately 'MIN' function doesn't seem applicable to Dynamic Linq

1
0
4/6/2017 10:38:53 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Following code can help, please check (this is a sample code only): 

var searchResult = db.Set(GeoData)
    .AsQueryable()
    .OrderBy("PlaceName")
    .GroupBy("CountryCode", "PlaceName")
    .Select(g => new { GeoID = g.Min(p => p.ID), PostalCode = g.Min(p => p.PostalCode), PlaceName = g.PlaceName });
0
4/6/2017 11:35:34 AM

Related Questions

SQL Convert Function in the Dynamic LINQ API

I'm trying to use a Dynamic LINQ Query to query a SQL database, and in the Where clause I need to evaluate an '=' condition with a field that is of type TEXT....Right now, I've got this:...var result = DBCon.PcInValue .Where(String.Format("InputName = @0 and InputValue) {0} @1", f.Condition), f.Field, f.Value) .Select("new(OrderNum, OrderLine...
c# dynamic-linq linq linq-to-sql
asked by Overhed

Using the System.Linq.Dynamic namespace, how to perform the following in Dynamic Linq

I just want to know how to do the following in Dynamic Linq using System.Linq.Dynamic namespace...var query2 = db.Customers.Select( cust => new Customer { FirstName = cust.FirstName, LastName = cust.LastName Tags="sampleTag,Tag" ...
dynamic-linq linq
asked by emem

Does dynamic GroupBy in dynamic LINQ work with dynamic Where?

I use this ...dynamic LINQ library... together with Linq-to-Entities.... I build query and after that iterate it with ...foreach(object e in query){}...query=db.Table1.Where("it.FieldA>10").Select("it.FieldB");... works....query=db.Table1.Where(e=>e.FieldA>10).GroupBy("it.FieldB", "it").Select("key")... works.... But ...query=db.Table1.Where("it.Fi...
.net dynamic dynamic-linq linq linq-to-entities
asked by alpav

LINQ-to-SQL dynamic table name LINQ-to-SQL

I want to construct my query dynamically based on the contents user has selected, and I want to do this in LINQ-t0-SQL. I have seen ...this..., but I don't want to use SQL statements with datacontext....On Googling a bit I have a feeling that this can be done using dynamic LINQ. Would someone provide an example of similar scenario with dynamic LINQ...
dynamic-linq linq-to-sql
asked by Muhammad Adeel Zahid

How can I utilize System.Linq.Dynamic for the LIKE operation?

Try using simply "CityName.Contains(@1)" this will convert to the proper lambda since its a method invocation on an accessible type....something like:...var query = db.Customers. Where("CityName.Contains(@0) or CityName.Contains(@1)", "London", "USA") ...Just tested it with the sample app that comes with the dynamic library and it generates the LIK...
asp.net c# dynamic-linq linq
asked by Jaime

Generic method for constructing a string Dynamic Linq query. includes strings that have been tokenized

Here's what I use to do this:...using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Linq.Expressions; using System.Collections.ObjectModel; namespace MyLibrary.Extensions { /// <summary>Defines extension methods for building and working with Expressions.</summary> public static class Expressio...
dynamic-linq linq
asked by Josh M.

OrderBy inside a GroupBy using dynamic LINQ?

I had the following query using normal linq and it was working great (using anonymous type),... var result = from s in Items group s by s.StartTime into groupedItems select new {groupedItems.Key, Items= groupedItems.OrderBy(x => x.Name) }; ...But using Dynamic Linq I cannot get it to order by within the groupby.... r...
dynamic-linq linq linq-to-objects
asked by Martin

Dynamic Linq Execute Functions inside of Select Statement

I'm trying to grab out formatted values from a project....I have a function declared:...public static string GetFormattedLink(string ExtTitleID) { return "Str_" + ExtTitleID; } ...How would I execute this statement from the Select Statement in Dynamic Linq I tried....using (var Model = new MK3Entities()) { var TOrigin = (Model.Titles.Where(...
c# dynamic-linq function
asked by johnny 5

System.Linq.Dynamic.Core vs System.Linq.Dynamic

What is the difference between System.Linq.Dynamic.Core and System.Linq.Dynamic? I am currently using System.Linq.Dynamic and it does not contain support for ...Select... and ...SelectMany... (among other extension methods). Does System.Linq.Dynamic.Core support these methods?
dynamic-linq
asked by jjf1978

Dynamic library (System.Linq.Dynamic) SQL LIKE Operator

Someone has posted a similar question here ...How Dynamic library (System.Linq.Dynamic) support LIKE Operator?...But it's not exactly what I want. The ...Contains... operator mentioned in that post only do this in SQL ..."%SOMETHING%".... But the ...LIKE... operator in SQL can do this ..."SOME%THING".... Is there a similar operator for Dynamic LINQ...
c# dynamic-linq linq sql
asked by Kevin Man

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow