Get SQL string from Linqkit

Question

how can I return the SQL from a LinqKit.ExpandableQuery<T>?
I'm using the code from stevefenton.co.uk but it seems to fail at

private static System.Data.Entity.Core.Objects.ObjectQuery<T> GetQueryFromQueryable<T>(IQueryable<T> query)
        {
            var internalQueryField = query.GetType().GetFields(System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance).Where(f => f.Name.Equals("_internalQuery")).FirstOrDefault();
            var internalQuery = internalQueryField.GetValue(query);
            var objectQueryField = internalQuery.GetType().GetFields(System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance).Where(f => f.Name.Equals("_objectQuery")).FirstOrDefault();
            return objectQueryField.GetValue(internalQuery) as System.Data.Entity.Core.Objects.ObjectQuery<T>;
        }

with the internalQueryField being null.

It has something to do with the inheritance tree (LinqKit + Linq), but I can't get my head around it.. :(

Ashkan Mobayen Khiabani · Accepted Answer · 2016-02-26 13:57:27Z

4

string sql = query.ToString();

answered Feb 26, 2016 at 13:57

Ashkan Mobayen Khiabani

34.4k35 gold badges111 silver badges187 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ashkan Mobayen Khiabani Over a year ago

when a programmer brain hangs he/she would do strange things, I have done it many times, no worry ;)

ʃʈɑɲ Over a year ago

i was so convinced it would not work that I didn't even try :)

The Joy Of code Over a year ago

This does not seem to work in .Net core 2.2. You just get a reflection string i.e. "value(Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1[my.object.typehere])"

Collectives™ on Stack Overflow

Get SQL string from Linqkit

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related