Sql.Expression attribute not working from MyExtensions in LINQPad about linq2db.linqpad HOT 10 CLOSED

I think here is collision with linq2db's IsNullOrEmpty function. We already have this extension function but not mapped to SQL https://github.com/linq2db/linq2db/blob/master/Source/LinqToDB/Common/Tools.cs#L42

from linq2db.linqpad.

Tried it with linqpad 5.40.0 - still works for me.
Only possible fail point I can see now - you load diffrerent version of linq2db for My Extensions compared to version, used by linqpad provider. Try to reload it using F4 in My extensions file (extension use linq2db v2.9.1, if you have latest version).

from linq2db.linqpad.

Well, yep that was it! My Extensions was using 2.9.1, but the connection was using 2.7.0. I updated the connection driver to 2.9.1 and now it works perfectly. Thank you so much! Can't believe I didn't check that before.

from linq2db.linqpad.

Not sure what's going on, but it sounds strange - this error means that your query compiled successfully (found extension properly) and then linq2db wasn't able to handle it.

I've tried your extension with My Extensions file and it worked fine for me.

from linq2db.linqpad.

Could you post your query code?

from linq2db.linqpad.

Also linqpad version. I use v4.59.0 free for testing.

from linq2db.linqpad.

LinqPad version 5.4
Here is the query:

Projects.Select(p => new { p.ProjectID, p.ProjectManager })
    .Where(p => !p.ProjectManager.IsNullOrEmpty())

I don't have a using for LinqToDb nor LinqToDb.Tools in either the query or the extension, so it wouldn't be a collision right?

For reference, this works of course:

Projects.Select(p => new { p.ProjectID, p.ProjectManager })
    .Where(p => !string.IsNullOrEmpty(p.ProjectManager))

from linq2db.linqpad.

Just for clarifying. Could you please rename method to IsNullOrEmptySql? If problem still exists we will dig here more deeply.

from linq2db.linqpad.

Renamed it, but still getting the same error :(.
Tried both IsNullOrEmptySql and IsNullOrEmptySqlasdfdsfasdfdsfa juuust in case.

from linq2db.linqpad.

I'm not so familiar with LINQPad.
How do you define extension method in script? Screenshot can be enough.
Also which type of Driver do you use? Dynamic or using existing model?

from linq2db.linqpad.