Devart Forums

Code: Select all

var q =
				from p in _dc.Profiles
				where p.Id == requestedProfileId
				select new ContactUsVO
				{
					Phones = ( from a in _dc.ProfilePhones
							   where a.FK_Profile_Id == p.Id
							   select a ).ToList(),
					ViewPhoneSetting = _dc.Privacysettings.Where( ps => ps.ProfileId == p.Id && ps.Setting == ( int )TribeWorx.Data.TribePrivacySettingsEnum.ViewTel ).FirstOrDefault(),
					Emails = ( from a in _dc.ProfileEmailAddress
							   where a.FK_Profile_Id.Equals( p.Id ) && a.Address != ""
							   select a ).ToList(),
					ViewEmailSetting = _dc.Privacysettings.Where( ps => ps.ProfileId == p.Id && ps.Setting == ( int )TribeWorx.Data.TribePrivacySettingsEnum.ViewEmail ).FirstOrDefault(),
					Addresses = ( from a in _dc.ProfileAddress
								  where a.FK_Profile_Id == p.Id
								  select a ).FirstOrDefault(),
					ViewAddressSetting = _dc.Privacysettings.Where( ps => ps.ProfileId == p.Id && ps.Setting == ( int )TribeWorx.Data.TribePrivacySettingsEnum.ViewAddress ).FirstOrDefault(),
					IsFollower = _dc.Followers.Count( e => e.FollowingProfile == activeProfileId && e.FollowedProfile == p.Id ) > 0
				};

Code: Select all

Addresses = ( from a in _dc.ProfileAddress
								  where a.FK_Profile_Id == p.Id
								  select a ).ToList(),

Code: Select all

public class ContactUsVO
	{
		
		public ProfileAddress Addresses
		{ get; set; }

		...
	}

Code: Select all

CREATE TABLE `profile` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `CreatedOn` datetime NOT NULL,
  `ModifiedOn` datetime NOT NULL,
  `ModifiedBy` varchar(255) DEFAULT NULL,
  `Type` int(11) NOT NULL,
  PRIMARY KEY (`Id`)
) 

CREATE TABLE `profileaddress` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `FK_Profile_Id` int(11) NOT NULL,
  `Address` varchar(255) NOT NULL,
  `City` varchar(64) NOT NULL,
  `Country` varchar(64) NOT NULL,
  `Neighbourhood` varchar(64) NOT NULL,
  `Zip` varchar(16) NOT NULL,
  PRIMARY KEY (`Id`,`FK_Profile_Id`),
  KEY `FK_ProfileAddress_Profile` (`FK_Profile_Id`),
  CONSTRAINT `FK_ProfileAddress_Profile` FOREIGN KEY (`FK_Profile_Id`) REFERENCES `profile` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION
)

Code: Select all

var q = 
            from p in _dc.Profiles 
            where p.Id == 1
            select new ContactUsVO 
            { 
               Addresses = ( from a in _dc.ProfileAddress 
                          where a.FK_Profile_Id == p.Id 
                          select a ).FirstOrDefault()
            };

ContactUsVO c = q.FirstOrDefault();

Code: Select all

q = from s in _dc.a
	where 1 == 1
				select new valueObjectX
				{
					ValueObjectYList = (1==1)?
								(from r in _dc.b 
								 where 2 == 2 
								 select new ValueObjectZ{
									RId= r.Id,
									PString = ( from a in _dc.c
												   where 1 == 1
												   orderby a.CreatedOn descending
												   select a.Url ).FirstOrDefault(),
								 }).Distinct().ToList():null
};