i want implement like search

Hello Sandip,

you can use the Contains method in LINQ to check if the FacultyName property contains the search term.

Example:

string searchTerm = "your search term here";

var result = from ContentDetails in _dbContext.ContentDetails
             join VersionDetails in _dbContext.VersionDetails on ContentDetails.Id equals VersionDetails.ContentId
             join MstStage in _dbContext.MstStage on ContentDetails.Status equals MstStage.Id
             where ContentDetails.FacultyName.Contains(searchTerm)
             select new
             {
                 VersionDetails.ContentId,
                 ContentDetails.Id,
                 ContentDetails.DeptId,
                 ContentDetails.DeptName,
                 ContentDetails.CourseId,
                 ContentDetails.CourseName,
                 ContentDetails.Semester,
                 ContentDetails.PaperId,
                 ContentDetails.PaperName,
                 ContentDetails.ContentTypeId,
                 ContentDetails.ContenType,
                 ContentDetails.FacultyId,
                 ContentDetails.FacultyName,
                 ContentDetails.Topic,
                 ContentDetails.LanguageId,
                 ContentDetails.LanguageName,
                 MstStage.Mode,
                 VersionDetails.VersionId,
                 VersionDetails.VersionName,
                 VersionDetails.VersionNote,
                 ContentDetails.CreatedBy,
                 ContentDetails.CreatedOn,
                 ContentDetails.ModifiedBy,
                 ContentDetails.ModifiedOn
             };

 

Thanks

Naimish Makwana