if (!String.IsNullOrEmpty(searchString))
{
    searchString = Methods.RemoveTurkish(searchString);
    bayiVM.JoinedTable = await _adb.CariUserJoin.FromSql("EXECUTE CariListeAra {0}", searchString).ToListAsync();
}
else
{
    bayiVM.JoinedTable = await _adb.CariUserJoin.FromSql("EXECUTE CariListeGetir").ToListAsync();
}

var count = bayiVM.JoinedTable.Count;
bayiVM.JoinedTable = bayiVM.JoinedTable.Skip((productPage - 1) * PageSize).Take(PageSize).ToList();

bayiVM.PagingInfo = new PagingInfo
{
    CurrentPage = productPage,
    ItemsPerPage = PageSize,
    TotalItems = count,
    urlParam = param.ToString()
};

return View(bayiVM);

ALTER PROCEDURE [dbo].[CariListeGetir]
AS
BEGIN

    SELECT [CARI_KOD], [CARI_ISIM], [LockoutEnd],[PlaKodu], [StockPermit] FROM YESLAS2018.dbo.TBLCASABIT
    left join b2byeslasDb.dbo.AspNetUsers on TBLCASABIT.CARI_KOD=AspNetUsers.UserName
    COLLATE DATABASE_DEFAULT
END

ALTER PROCEDURE [dbo].[CariListeAra] (@ad nvarchar(15))
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.

    -- Insert statements for procedure here
    SELECT [CARI_KOD], [CARI_ISIM], [LockoutEnd],[PlaKodu], [StockPermit] FROM YESLAS2018.dbo.TBLCASABIT
    left join b2byeslasDb.dbo.AspNetUsers on TBLCASABIT.CARI_KOD=AspNetUsers.UserName
    COLLATE DATABASE_DEFAULT
    where CARI_KOD like '%'+@ad+'%' or CARI_ISIM like '%'+@ad+'%'

END

public class BayiVewModel
    {
        public List<CariUserJoin> JoinedTable { get; set; }
        public PagingInfo PagingInfo { get; set; }
    }

public class CariUserJoin
    {
        [Key]
        public string CARI_KOD { get; set; }
        public string CARI_ISIM { get; set; }
        public DateTimeOffset? LockoutEnd { get; set; }
        public string PlaKodu { get; set; }
        public bool StockPermit { get;}

    }

public bool? StockPermit { get; set; }