Sql sorgusunu Controllerde de yapabilirsiniz slider modülü eklemek istediğiniz yerde de. Eğer cshtml içiinde kullanacaksanız sql sorgusunu aşağıdaki gibi yazabilirsiniz.
var slider = new Slider.Models.SliderEntities().Slider.OrderBy(p => p.ID).ToList();
--------Views kısmı
<div class="sliders">
<div id="carouselExampleIndicators" class="carousel slide" data-ride="carousel">
<ol class="carousel-indicators">
@{int s = 0;}
@foreach (var item in slider)
{
s++;
var active = s == 1 ? "active" : "";
var indicator = s-1;
<li data-target="#carouselExampleIndicators" data-slide-to="@indicator" class="@active"></li>
}
</ol>
<div class="carousel-inner">
@{int i = 0;}
@foreach (var item in slider)
{
i++;
var active = i == 1 ? "active" : "";
<div class="carousel-item @active">
<img class="d-block w-100" src="~/images/@item.img" alt=""></div>
</div>
}
</div>
<a class="carousel-control-prev" href="#carouselExampleIndicators" role="button" data-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="sr-only">Geri</span>
</a>
<a class="carousel-control-next" href="#carouselExampleIndicators" role="button" data-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="sr-only">İleri</span>
</a>
</div>
</div>