public static List<SubCategoryInfo> GetPageByCategorySEOName(string PageName, string SubPageName) { return (from p in GetAllPageByCategorySEOName() where (p.CategorySEOName.Equals(PageName, StringComparison.OrdinalIgnoreCase) || p.SubCategorySEOName.Equals(SubPageName, StringComparison.OrdinalIgnoreCase)) && (p.CategorySEOName.Equals(PageName, StringComparison.OrdinalIgnoreCase) || p.SubCategorySEOName.Equals(SubPageName, StringComparison.OrdinalIgnoreCase)) select p).Distinct().ToList(); }
select distinct c.CategorySEOName from [dbo].[SubCategory] Sc inner join [dbo].[Category] C on C.CategoryId = Sc.CategoryId where (c.categorySEOName in('aboutus') or Sc.SubcategorySEOName in('""')) and ( c.categorySEOName in('aboutus') or Sc.SubcategorySEOName in('Our-values'))
List<Person> distinctPeople = allPeople .GroupBy(p => p.PersonId) .Select(g => g.First()) .ToList();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)