Guest User

Untitled

a guest
Jan 23rd, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. select * from dbo."Batches" inner join dbo.StudentBatchRelation
  2. on dbo.Batches.Id = dbo.StudentBatchRelation.BatchId where
  3. dbo.StudentBatchRelation.StudentId = '3d980306-e36e-4581-8c98-219717cb1668'
  4.  
  5. var result = (from t1 in contBatch.GetallBatchList()
  6. join t2 in contStudent.getAllStudentBatchList()
  7. on t1.Id equals t2.batchId where t2.studentId == studentid
  8. select new { t1.Days, t1.BatchDate }).ToList();
Add Comment
Please, Sign In to add comment