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.. :(

score 4 · Accepted Answer · answered Feb 26 '16 at 13:57

4

string sql = query.ToString();

answered Feb 26 '16 at 13:57

Ashkan Mobayen Khiabani

33,575
33
102
171

when a programmer brain hangs he/she would do strange things, I have done it many times, no worry ;) – Ashkan Mobayen Khiabani Feb 26 '16 at 14:00
i was so convinced it would not work that I didn't even try :) – grmbl Feb 26 '16 at 14:01
1

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])" – Microsoft Developer Apr 11 '19 at 14:14

Get SQL string from Linqkit

1 Answers1