Plug in Dapper

[SwissMaWi]

Fascinating work that I would like to leverage with Dapper as ORM.
Has anyone any hint about where or how I could the SQL generation part from the execution part and plug in Dapper as ORM?
Regards, Martin

[SwissMaWi]

Also I have ported this to .Net 8 already. I would like to use Dapper with this library in .Net 8

[mellamokb]

I was wondering the same thing and got insight from Issue #32. You can call provider.GetQueryText on your IQueryable.Expression to get the SQL code, and then run that directly with Dapper instead. For example:

// Write query expression (since no enumeration, this query hasn't run yet).
var query =
  from c in provider.GetTable<Customer>()
  where c.FirstName.Contains("Bob")
  select new { c.FirstName, c.LastName };

// Generate SQL code from the query expression without executing it.
var sql = provider.GetQueryText(query.Expression);

// use Dapper to perform the query.
myconnection.Query<MyType>(sql);

[SwissMaWi]

Hey that's great, I didn't know that. Does it work with LINQ? And we would need to convert the SQL string into a parameterized query to leverage SQL server near stored procedure performance.