Is it possible to use EF Core's DbSet<>.FromSqlRaw along with ToLinqToDB()?

[linq2db]

Is it possible to use EF Core's DbSet<>.FromSqlRaw along with ToLinqToDB()?

[sdanyliv]

Will find time to convert FromSqlRaw. We have our own FromSql method. Just forgot to create transformation.

[djkunkel]

Thank you for this guidance. I was able to make my change in a custom override of TransformExpression!

[djkunkel]

I have a patch for this against version 2.0.5, do you accept pull requests? Also, I'm new to expression parsing and this project, so I may have done something terribly wrong, but I thought it might be helpful.

0001-Support-FromSql-when-using-FromRawSql-from-EF.txt

[sdanyliv]

Which version of EF do you use?

[djkunkel]

3.1.3

[sdanyliv]

I suggest to update to linq2db.EntityFrameworkCore 3.0 - it has a lot of improvements, especially Eager Loading.

Anyway, you can customize current integration before I fix that without changing library code:
Implement your new class MyImplementation derived from LinqToDBForEFToolsImplDefault and override TransformExpression method.
And assign it to LinqToDBForEFTools.Implementation = new MyImplementation()

Sorry a little bit busy now, I'll update library in several days. Your changes looks good, but I need to verify and create tests.

[djkunkel]

Thanks for your feedback. I initially tried to override the implementation as suggested, but the changes were to an inline method (LocalTransform) inside the TransformExpression method.

[sdanyliv]

Hmm, strange, I thought that I have opened everything for customising. It should be easy, something like this:

public override Expression TransformExpression(Expression expression, IDataContext dc, DbContext ctx, IModel model)
{
   var expr = base.TransfromExpression(expression, dc, ctx, model);
   var expr = expr.Transform(e => {
      if ( e is MethodCallExpression and ... bla, bla is FromSqlRaw )
      {
         // your replace code
        return replaced;
      }
      return e;
   });

   return expr;
}

Anyway, will find a time to update library.

[sdanyliv]

Released in 3.1.0