I'm not very good at LINQ but am very good on old fashioned SQL. I'm using DevForce with Silverlight.

 

I have to implement the follwing SQL query in LINQ to Entities:

select max(geo_x), max(geo_y), min(geo_x), min(geo_y) from em_point where customer_id=39 and p_gr_id=1;

The Entity for the table em_point is EntPoint and the variablse are p_geoX, p_geoY, p_customerID, p_groupID;

So I try something like:

 

 

In Silverlight, where queries must be submitted asynchronously, you can use the AsScalarAsync() extension method to turn an immediate execution query into an asynchronously executed one.  So if you wanted to issue separate min and max queries you could do something like this:

 

  var op = p_manager.EntPointSet.Where(...).Select(p => p.p_geoX).AsScalarAsync().Max();

It's probably much easier to instead take advantage of grouping and anonymous projections, and do something like this instead:

 

      var query = p_manager.EntPointSet
                .Where(p => p.p_customerId = ...)
                .GroupBy(p => new { p.p_customerId, p.p_pointGrId })
                .Select(g => new {
                  Id = g.Key,
                  MaxGeoX = g.Max(p => p.p_geoX),
                  MinGeoX = g.Min(p => p.p_geoX),

                  .....
                });

This returns a query, which can  be executed synchronously or asynchronously.

  ERROR [42000] [IBM][IDS/NT32] A syntax error has occurred.
Can I somewhere se the SQL-query that is generated and run against the database?
Can I somehow influence the SQL-generation to avoid this syntax error?

Here is the LINQ query I'm running:

 var query = p_manager.EntPointSet
                    .Where(p => p.p_customerID == pg.p_customerID && p.p_pointGrID == pg.p_pointGrID)
                    .Where(p => !(p.p_geoX == 0 && p.p_geoY == 0))
                    .GroupBy(p => new { p.p_customerID, p.p_pointGrID })
                    .Select(g => new {
                                        m_id = g.Key,
                                        m_maxGeoX = g.Max(p => p.p_geoX),
                                        m_minGeoX = g.Min(p => p.p_geoX),
                                        m_maxGeoY = g.Max(p => p.p_geoY),
                                        m_minGeoY = g.Min(p => p.p_geoY)
                                    }
                        );
                Query(query, g =>
                {
                    var mapBoundaries = new MapBoundaries();
                    if(g != null)
                    {
                        var enumerator = g.GetEnumerator();
                        enumerator.MoveNext();
                        var p = enumerator.Current;
                        if (p != null)
                        {
                            mapBoundaries.p_leftTop = new Point(p.m_minGeoX, p.m_maxGeoY);
                            mapBoundaries.p_rightBottom = new Point(p.m_maxGeoX, p.m_minGeoY);
                        }
                    }
                    callback(mapBoundaries);
                });

Is that maybe supported in this new version 6.0.7?

If using SQL Server there's always SQL Profiler.   There are also 3rd party tools, such as EF Profiler. 

I'd prefer not to use the full DevForce trace logging - I'd just like to inspect an ocaissional query in the debugger.

Thanks.