public class WorkTable
        {
            public int TableID { get; set; }
            public short c1 { get; set; }
            public UInt16 c2 { get; set; }
            public Int16 c3 { get; set; }
            public Int16 c4 { get; set; }
            public UInt32 c5 { get; set; }
            public UInt64 c6 { get; set; }
            public Int64 c7 { get; set; }
            public Int16 c8 { get; set; }
            public Int16 c9 { get; set; }
            public Int16 c10 { get; set; }
            public Int16 c11 { get; set; }
            public Int16 c12 { get; set; }
            public Int16 c13 { get; set; }
            public Int16 c14 { get; set; }
            public Int16 c15 { get; set; }
            public Int16 c16 { get; set; }
            public Int16 c17 { get; set; }
            public Int16 c18 { get; set; }
            public Int16 c19 { get; set; }
            public Int16 c20 { get; set; }
            public Int16 c21 { get; set; }
            public Int16 c22 { get; set; }
            public Int16 c23 { get; set; }
            public int c24 { get; set; }
            public Int16 c25 { get; set; }
            public int c26 { get; set; }
            public Int16 c27 { get; set; }
            public Int16 c28 { get; set; }
            public Int16 c29 { get; set; }
            public Int16 c30 { get; set; }
            public Int16 c31 { get; set; }
            public int total { get; set; }
        }

            var returnVal = db.Database.SqlQuery<WorkTable>(
                "SELECT TableID, [1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12],[13],[14],[15],[16],[17], " +
                "                [18],[19],[20],[21],[22],[23],[24],[25],[26],[27],[28],[29],[30],[31],[Итого] " +
                "FROM(" +
                "    SELECT TableID " +
                "           , CASE WHEN [MonthDay] IS NULL THEN 'Итого' ELSE [MonthDay] END AS [MonthDay] " +
                "           , CASE WHEN [MonthDay] IS NULL THEN [AllSumm] ELSE [SumTime] END AS [SumTime] " +
                "    FROM(SELECT w.TableID " +
                "                 , [MonthDay] = DATENAME(DAY, DateTimeFrom) " +
                "                 , [SumTime] = CASE " +
                "                                    WHEN w.ContractID < 0 AND w.ContractID != -3 THEN w.ContractID " +
                "                                    ELSE DATEDIFF(MINUTE, DateTimeFrom, DateTimeTill) " +
                "                               END " +
                "                , [AllSumm] = SUM(DATEDIFF(MINUTE, DateTimeFrom, DateTimeTill)) " +
                "            FROM dbo.WorkTable w " +
                "                 INNER JOIN dbo.Employees e ON e.TableID = w.TableID " +
                "                 INNER JOIN dbo.Contracts c ON c.ContractID = w.contractID " +
                "                 INNER JOIN dbo.Departments d ON d.DepartmentID = e.DepartmentID " +
                "            WHERE w.TableID in(6426, 6554) " +
                "                  AND MONTH(DateTimeFrom) = 2 " +
                "                  AND YEAR(DateTimeFrom) = 2018 " +
                "                  AND(c.departmentID = d.DepartmentID OR c.departmentID = -1) " +
                "            GROUP BY w.TableID, GROUPING SETS((w.ContractID, DateTimeFrom, DateTimeTill), ()) " +
                "        ) b " +
                "    ) t " +
                " PIVOT(SUM([SumTime]) FOR [MonthDay] in ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12],[13],[14],[15],[16],[17], " +
                "                                         [18],[19],[20],[21],[22],[23],[24],[25],[26],[27],[28],[29],[30],[31], [Итого]) " +
                "       ) AS test_pivot; ").ToList();