Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT [nu_ano]
- ,[nu_mes]
- ,[id_projeto]
- ,[id_fase]
- ,'Financial Progress ("Competência")' as ds_categoria
- ,'Baseline' as ds_curva
- FROM [Alvarez_Marsal].[dbo].[Schedule_Status]
- where nu_mes = 12
- var result = (from l in db.Schedule_Status
- .Where(x => x.nu_mes == 12)
- .Select(x => new Schedule_Status
- {
- nu_ano = x.nu_ano,
- nu_mes = x.nu_mes,
- id_projeto = x.id_projeto,
- id_fase = x.id_fase
- })
- select l).ToList();
- var result = (from l in db.Schedule_Status
- .Where(x => x.nu_mes == 12)
- .Select(x => new Schedule_Status {
- nu_ano = x.nu_ano,
- nu_mes = x.nu_mes,
- id_projeto = x.id_projeto,
- id_fase = x.id_fase,
- ds_categoria = "Financial Progress ("Competência")",
- ds_curva = "Baseline"
- })
- select l).ToList();
Add Comment
Please, Sign In to add comment