Guest User

Untitled

a guest
Apr 19th, 2018
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. SELECT [nu_ano]
  2. ,[nu_mes]
  3. ,[id_projeto]
  4. ,[id_fase]
  5. ,'Financial Progress ("Competência")' as ds_categoria
  6. ,'Baseline' as ds_curva
  7. FROM [Alvarez_Marsal].[dbo].[Schedule_Status]
  8. where nu_mes = 12
  9.  
  10. var result = (from l in db.Schedule_Status
  11. .Where(x => x.nu_mes == 12)
  12. .Select(x => new Schedule_Status
  13. {
  14. nu_ano = x.nu_ano,
  15. nu_mes = x.nu_mes,
  16. id_projeto = x.id_projeto,
  17. id_fase = x.id_fase
  18. })
  19. select l).ToList();
  20.  
  21. var result = (from l in db.Schedule_Status
  22. .Where(x => x.nu_mes == 12)
  23. .Select(x => new Schedule_Status {
  24. nu_ano = x.nu_ano,
  25. nu_mes = x.nu_mes,
  26. id_projeto = x.id_projeto,
  27. id_fase = x.id_fase,
  28. ds_categoria = "Financial Progress ("Competência")",
  29. ds_curva = "Baseline"
  30. })
  31. select l).ToList();
Add Comment
Please, Sign In to add comment