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

Thanks.

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

Is that maybe supported in this new version 6.0.7?

  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);
                });

 

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.

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: