public ActionResult Create()
        {

            using (var ctx = new HotelEntities())
            {

                var quarto = ctx.Database.SqlQuery<int>("SELECT DISTINCT Quarto.ID_Quarto FROM Quarto LEFT JOIN Reserva ON Quarto.ID_Quarto = Reserva.ID_Quarto WHERE Reserva.ID_Quarto IS NULL OR NOT EXISTS(SELECT 1 FROM Quarto Q2 LEFT JOIN Reserva R2 ON Q2.ID_Quarto = R2.ID_Quarto WHERE Quarto.ID_Quarto = Q2.ID_Quarto AND R2.DataEntrada <= GETDATE() AND(R2.DataSaida IS NULL OR R2.DataSaida > GETDATE()))").ToList();
                ViewBag.ID_Quarto = new SelectList(quarto, "ID_Quarto", "ID_Quarto");
            }

            return View();
        }

<div class="col-sm-6">
                <div class="inputBox ">
                    <div class="inputText">ID Quarto</div>
                    @Html.DropDownList("ID_Quarto", null,"", htmlAttributes: new { @class = "input" })
                </div>
            </div>