Issue is i want to get all the records of dataset as well as mapped records in Authorization table
var dataSetProjects = (from DataSet in _context.Datasets.Where(x => x.IsActive) join auth in _context.Authorizations on DataSet.DatasetId equals auth.DatasetID