join 2 columns strings on query sqlite c# code example

Example: concat sqlite

SELECT
    FirstName || ' ' || LastName AS FullName
FROM
    Employees
ORDER BY
    FullName;