Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- List<WorkerMove> Rank = new List<WorkerMove>();
- var idRank = (from rank1 in context.Worker select rank1.codeWorker);
- foreach (var read in idRank)
- {
- WorkerMove Rank3 = (from rank2 in context.WorkerMove
- where rank2.idWorker == read
- select rank2).FirstOrDefault();
- if(Rank3 != null) Rank.Add(Rank3);
- }
- var workerSurname = from worker in context.Worker
- join workMove in Rank on worker.codeWorker equals workMove.idWorker
- join workRank in context.Dol on workMove.idRank equals workRank.idDol
- select new
- {
- codeWork = worker.codeWorker,
- Fio = worker.Family+ " " + worker.Name.Remove(1) + "." + worker.Otch.Remove(1) + ".",
- Dol = workRank.Dol,
- };
Add Comment
Please, Sign In to add comment