Entity Model Name  :

Thank you for reading this post, don't forget to subscribe!

TestLinqDataContext db = new TestLinqDataContext();
var result = (from p in db.TagMasters
join
t in db.TagRegistrations on p.ID equals t.TagId
group t by new { p.TagCode, t.DateCreated } into g
select new { g.Key.TagCode,g.Key.DateCreated}).Distinct();