When running for example the following LINQ query:
Code: Select all
var orders = ctx.Orders.Select(o => new { joined = Devart.Data.MySql.Entity.MySqlFunctions.Concat(o.Notes, o.Name) });
The generated SQL looks like this:
Code: Select all
SELECT
1 AS C1,
(Extent1.Notes, Extent1.Name) AS C2
FROM `Order` AS Extent1
The more correct and working SQL should be:
Code: Select all
SELECT
1 AS C1,
CONCAT(Extent1.Notes, Extent1.Name) AS C2
FROM `Order` AS Extent1
dotConnect for MySQL 7.6.217
Entity Framework 5.0.0
MariaDB 5.5.33
Is this a bug in dotConnect or are we doing things wrong?
Regards
Andreas