public List <GetModelNameForSearchResult> GetModelNameForSearch(string modelName, long brandID) { try { brandID = 1; return(_dbContext.GetModelNameForSearch(brandID, modelName).Take(10).ToList()); //List<Model> modList = new List<Model>(); //if (brandID == 0) //{ // var modellist = db.Models.Where(x => x.Name.Contains(modelName)).Take(15).ToList(); // modList = modellist; // return modList; //} //var modelList = db.Models.Where(x => x.BrandID == brandID && x.Name.Contains(modelName) && x.IsRemoved == false).Take(10).ToList(); //modList = modelList; //db.Dispose(); //return modList; } catch (Exception ex) { throw new Exception(ex.Message, ex); } }