I do not have duplicate records in my database however in my view. It shows duplicates. ClientId is a Guid which is passed on to each table in the join.
Please help
What I have tried:
public ActionResult ClientInfo(string ClientId)
{
var query = (from x in db.FinancialNeedsClients
join y in db.FinancialSpouseDetailss on x.ClientId equals y.ClientId into ylist from y in ylist.DefaultIfEmpty()
join z in db.FinancialSpouseDetailss on x.ClientId equals z.ClientId into zlist from z in zlist.DefaultIfEmpty()
join c in db.FinancialNeedsChildrens on x.ClientId equals c.ClientId into clist from c in clist.DefaultIfEmpty()
join d in db.FinancialNeedDependentss on x.ClientId equals d.ClientId into dlist from d in dlist.DefaultIfEmpty()
{
var query = (from x in db.FinancialNeedsClients
join y in db.FinancialSpouseDetailss on x.ClientId equals y.ClientId into ylist from y in ylist.DefaultIfEmpty()
join z in db.FinancialSpouseDetailss on x.ClientId equals z.ClientId into zlist from z in zlist.DefaultIfEmpty()
join c in db.FinancialNeedsChildrens on x.ClientId equals c.ClientId into clist from c in clist.DefaultIfEmpty()
join d in db.FinancialNeedDependentss on x.ClientId equals d.ClientId into dlist from d in dlist.DefaultIfEmpty()
join e in db.FinancialNeedContactDetailss on x.ClientId equals e.ClientId into elist from e in elist.DefaultIfEmpty()
where x.ClientId == ClientId
select new FinancialNeedClientInfoViewModel()
{
Id = x.Id,
ClientId = x.ClientId,
Surnname = x.Surnname,
FirstName = x.FirstName,
IDNumber = x.IDNumber,
DOB = x.DOB,
Age = (int?)x.Age ?? 0,
Nationality = x.Nationality,
Occupation = x.Occupation,
TaxRef = x.TaxRef,
EmailAddress = x.EmailAddress,
ContactNumber = x.ContactNumber,
MaritaStatus = x.MaritaStatus,
MaritalRegime = x.MaritalRegime,
YearOfMarriage = x.YearOfMarriage,
IfOther = x.IfOther,
SpouseId = (int?)y.Id ?? 0,
SpouseSurnname = y.Surnname,
SpouseFirstName = y.FirstName,
SpouseIDNumber = y.IDNumber,
SpouseDOB = y.DOB,
SpouseAge = (int?)y.Age ?? 0,
SpouseNationality = y.Nationality,
SpouseOccupation = y.Occupation,
SpouseTaxRef = y.TaxRef,
SpouseEmailAddress = y.EmailAddress,
SpouseContactNumber = y.ContactNumber,
ChildId = (int?)c.Id ?? 0,
ChildrenFIrst_Name = c.FIrst_Name,
ChildrenGender = c.Gender,
ChildrenAge = (int?)c.Age ?? 0,
ChildrenOccupation = c.Occupation,
ChildrenDOB = c.DOB,
DepId = (int?)d.Id ?? 0,
DepdendentFIrst_Name = d.FIrst_Name,
DepdendentAge = (int?)d.Age ?? 0,
DepdendentRelationship = d.Relationship,
ContactId = (int?)e.Id ?? 0,
MainMemberResedentialAddress = e.ResedentialAddress,
MainMemberPostalAddress = e.PostalAddress,
MainMemberBusinessAddress = e.BusinessAddress,
MainMemberMobileNumber = e.MobileNumber
}).Distinct().ToList();
where x.ClientId == ClientId
select new FinancialNeedClientInfoViewModel()
{
Id = x.Id,
ClientId = x.ClientId,
Surnname = x.Surnname,
FirstName = x.FirstName,
IDNumber = x.IDNumber,
DOB = x.DOB,
Age = (int?)x.Age ?? 0,
Nationality = x.Nationality,
Occupation = x.Occupation,
TaxRef = x.TaxRef,
EmailAddress = x.EmailAddress,
ContactNumber = x.ContactNumber,
MaritaStatus = x.MaritaStatus,
MaritalRegime = x.MaritalRegime,
YearOfMarriage = x.YearOfMarriage,
IfOther = x.IfOther,
SpouseId = (int?)y.Id ?? 0,
SpouseSurnname = y.Surnname,
SpouseFirstName = y.FirstName,
SpouseIDNumber = y.IDNumber,
SpouseDOB = y.DOB,
SpouseAge = (int?)y.Age ?? 0,
SpouseNationality = y.Nationality,
SpouseOccupation = y.Occupation,
SpouseTaxRef = y.TaxRef,
SpouseEmailAddress = y.EmailAddress,
SpouseContactNumber = y.ContactNumber,
ChildId = (int?)c.Id ?? 0,
ChildrenFIrst_Name = c.FIrst_Name,
ChildrenGender = c.Gender,
ChildrenAge = (int?)c.Age ?? 0,
ChildrenOccupation = c.Occupation,
ChildrenDOB = c.DOB,
DepId = (int?)d.Id ?? 0,
DepdendentFIrst_Name = d.FIrst_Name,
DepdendentAge = (int?)d.Age ?? 0,
DepdendentRelationship = d.Relationship,
ContactId = (int?)e.Id ?? 0,
MainMemberResedentialAddress = e.ResedentialAddress,
MainMemberPostalAddress = e.PostalAddress,
MainMemberBusinessAddress = e.BusinessAddress,
MainMemberMobileNumber = e.MobileNumber
}).Distinct().ToList();
3 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Laxmidhar SahooPosted Oct 5, 2018, 10:09 PM
Zain NabiPosted Oct 5, 2018, 8:19 AM
Laxmidhar SahooPosted Oct 5, 2018, 7:54 AM