public static List <Cars> getCars() { CarsDBEntities context = new CarsDBEntities(); var res = new List <Cars>(); var test = context.Cars .Where(e => e.Id != 0) .Select(e => new { name = e.Name, model = e.Model, transmission = e.Transmission, gaztype = e.GazType, enginelitres = e.EngineLitres, typeofcar = e.TypeOfCar, discount = e.Discount, photo1 = e.Photo1, price = e.Price, photo2 = e.Photo2, photo3 = e.Photo3 }); foreach (var item in test) { res.Add(new Cars { Name = item.name, Model = item.model, Transmission = item.transmission, GazType = item.gaztype, EngineLitres = item.enginelitres, TypeOfCar = item.typeofcar, Discount = item.discount, Photo1 = item.photo1, Price = item.price, Photo2 = item.photo2, Photo3 = item.photo3 }); } return(res); }
public static List <Accounts> GetAccounts() { CarsDBEntities context = new CarsDBEntities(); var res = new List <Accounts>(); var test = context.Accounts .Select(e => new { login = e.Login, password = e.Password, email = e.Email, isadmin = e.IsAdmin }); foreach (var item in test) { res.Add(new Accounts { Login = item.login, Password = item.password, Email = item.email, IsAdmin = item.isadmin }); } return(res); }