Hello Team,
Am created repository for my Entity data and this the error I get when I run the code.
Additional information: LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression.
CLASS
public partial class tblCustomer { public int CustomerId { get; set; } public string CustomerName { get; set; } }
REPOSITORIES CLASS
namespace SmartRestaurantManagement.Repositories { public class CustomerRepository { private readonly RestaurantDBEntities objRestaurantDBEntities; public CustomerRepository() { objRestaurantDBEntities = new RestaurantDBEntities(); }
public IEnumerable<SelectListItem> GetAllCustomer() { IEnumerable<SelectListItem> objSelectListItems = new List<SelectListItem>(); objSelectListItems = ( from obj in objRestaurantDBEntities.tblCustomers select new SelectListItem { Text = obj.CustomerName, Value = obj.CustomerId.ToString(), Selected = true }).ToList(); return objSelectListItems; } } }