@{
    ElectroluxBursa.Models.ElectroluxBursaEntities db = new ElectroluxBursa.Models.ElectroluxBursaEntities();

     var kat = db.KategoriSet.ToList();

     var mus = db.BilgiSet.Where(x => x.TabloKodu == "Ss").OrderByDescending(x => x.IcerikId).ToList().Take(5);

     var hizdiger = db.BilgiSet.Where(x => x.TabloKodu == "Bb").OrderByDescending(x => x.IcerikId).ToList().Take(5); ;
    
    }
<aside id="sidebar" class="four columns">
				 
				
				<div class="widget widget_categories">
					<h3 class="widget-title">Servis Hizmetlerimiz</h3>
					<ul>
                          @{
                                       foreach (var item in kat)
                                       {
                                           var link = ElectroluxBursa.Models.Extension.ToSeoUrl(item.KategoriAd) + ".html";
                                           <li><a title="@item.KategoriAd" href="~/ServisHizmetleri/Index/electrolux-bursa-nilufer-servisi-@link">@item.KategoriAd</a></li>
									
                                       }
                                       } 
					</ul>
				</div>
				
				<!--/ .widget-->
				
				<div class="widget widget_toggle">
					<div class="acc-box row">
                         @{
                foreach (var item in hizdiger)
                {
                    var link = ElectroluxBursa.Models.Extension.ToSeoUrl(item.IcerikBaslik) + ".html";
                    
                    
                    <span data-mode="" class="acc-trigger"> <a title="@item.IcerikBaslik" href="~/ServisHizmetleri/ServisDetayi/@item.IcerikId/electrolux-bursa-nilufer-servisi-@link">@item.IcerikBaslik</a> </span>
						<div class="acc-container">
							<p> <a title="@item.IcerikBaslik" href="~/ServisHizmetleri/ServisDetayi/@item.IcerikId/electrolux-bursa-nilufer-servisi-@link">@item.IcerikOzet.ToString().PadRight(254).Substring(0,254) ... </a> </p>
						</div>
						<!--/ .acc-container--> 
              
                }                
                } 
						
					</div>
					<!--/ .acc-box--> 
					
				</div>
				<!--/ .widget-->
				
				<div class="widget quote-box">
					<ul class="testimonials">
                        @foreach (var item in mus)
                        {
                            <li>
							<div class="quote-text">@item.IcerikOzet.ToString().PadRight(220).Substring(0,220)... <a href="~/ServisHizmetleri/MusteriGorusleri/@item.IcerikId/electrolux-bursa-nilufer-servisi-musteri_gorusleri.html">detay</a></div>
							<div class="quote-author"><b>@item.IcerikBaslik,</b></div>
						    </li>
                            
                        }
						 
					</ul>
				</div>
				<!--/ .quote-box--> 
                <!--/ .widget-->
				
				 
				
				<div class="widget widget_tag_cloud">
					<h3 class="widget-title">Etiketler</h3>

                    	<div class="tagcloud">
                    @{
                        
                        var meta = db.SeoSet.ToList().Take(1);
                        if(meta.Count()!=0)
                        {
                            var katt = db.KategoriSet.ToList();
                            var kte = "";
                            if (katt.Count() != 0)
                            {
                                foreach (var item in katt)
                                {
                                    kte = kte + item.KategoriAd + ",";
                                }
                            }

                            foreach (var item in meta)
                            {
                                var UrunKodu = item.Keyword + kte;
                                UrunKodu = UrunKodu.ToLower().Trim();

                                bool virgul = UrunKodu.EndsWith(",");
                                if (virgul != false)
                                { UrunKodu = UrunKodu.Remove(UrunKodu.Length - 1, 1); }

                                string[] dizilis = UrunKodu.Split(',');

                                int j = 1;
                                for (int i = 0; i < dizilis.Length; i++)
                                {
                                    var dizi = dizilis[i].ToString();
                                    if (dizi != null | dizi != "")
                                    { 
                                    <a href="#">@dizilis[i].ToString()</a>
                                    }
                                }
                             }
                         }
                       }
				   </div>
					<!--/ .tagcloud--> 
					
				</div>
				
			</aside>
			<!--/ #sidebar-->