Devart Forums

Code: Select all

from s in ctx.Semanas
orderby s.DtFimSemana descending
select new Semana
{
    DtInicial = s.DtInicioSemana,
    DtFinal = s.DtFimSemana,
    LogDtEnvio = s.LogDtEnvio,
    LogCdUsuario = s.LogCdUsuario,
    LogNmUsuario = s.Usuario.NmUsuario
};

Code: Select all

SELECT 
"Project1".C1 AS C1, 
"Project1".DTINICIOSEMANA AS DTINICIOSEMANA, 
"Project1".DTFIMSEMANA AS DTFIMSEMANA, 
"Project1".LOGDTENVIO AS LOGDTENVIO, 
"Project1".LOGCDUSUARIO AS LOGCDUSUARIO, 
"Project1".NMUSUARIO AS NMUSUARIO
FROM ( SELECT 
	"Extent1".DTINICIOSEMANA AS DTINICIOSEMANA, 
	"Extent1".DTFIMSEMANA AS DTFIMSEMANA, 
	"Extent1".LOGDTENVIO AS LOGDTENVIO, 
	"Extent1".LOGCDUSUARIO AS LOGCDUSUARIO, 
	"Extent2".NMUSUARIO AS NMUSUARIO, 
	1 AS C1
	FROM  SBLOGS.SEMANA "Extent1"
	LEFT OUTER JOIN SBLOGS.USUARIO "Extent2" ON "Extent1".LOGCDUSUARIO = "Extent2".CDUSUARIO
)  "Project1"
ORDER BY "Project1".DTFIMSEMANA DESC