Cacher is the code snippet organizer for pro developers

 var dersteki_ogrenciler = context.Database.SqlQuery<Sinif>(
          String.Format(@"select * From Sinif 
                  Where Name = @LessonName 
                  AND UserId = @UserId 
                  AND LessonID in ({0})", String.Join(",",new int[] {1,2,3,4,5,6} )),
              new SqlParameter[]{ 
                  new SqlParameter("LessonName", "asdas"),
                  new SqlParameter("UserId", 5)}
               ).ToList();
               
               
var siniftaki_dersler = from c in (context.Database.SqlQuery<Sinif>(
       String.Format(@"select * From Sinif 
               Where Name = @LessonName 
               AND UserId = @UserId 
               AND LessonID in ({0})", String.Join(",", new int[] { 1 })),
           new SqlParameter[]{ 
               new SqlParameter("LessonName", "asdas"),
               new SqlParameter("UserId", 5)}
            ).ToList())
                       join ff in (context.Dersler.Select(t => new { t.Text , t.LevelId, t.Name, t.Id})) on c.LessonID equals ff.LevelId
                       select ff;