Sql query using linq

sankeerth m

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
test this
var result = from DataSet  in _context.Datasets.Where(x => x.IsActive)
                   join auth in _context.Authorizations
                  on DataSet.DatasetId equals auth.DatasetID into eGroup
                   from e in eGroup.DefaultIfEmpty()
                               select new
                               {
                                   DataSet= DataSet,
Auth = auth
                               };
Now you can loop through the result
-1
Rijwan Ansari5y ago
Hi,

You can do:
var dataSetsResult = (from DataSet in _context.Datasets.Where(x => x.IsActive)
                                       join auth in _context.Authorizations on DataSet.DatasetId equals auth.DatasetID
select DataSet).ToList(); // for selecting Dataset
If you want to select column from both table then
var dataSetProjects = (from DataSet in _context.Datasets.Where(x => x.IsActive)
                      join auth in _context.Authorizations on DataSet.DatasetId equals auth.DatasetID
select new {
                        DataSet.ColumnName1 // one by one columns
                        DataSet.ColumnName2 // one by one columns
                        auth.ColumnName1 // one by one columns
                        auth.ColumnName2 // one by one columns
                      }).ToList()
+1