Devart Forums

Code: Select all

var recordSet = (from m in PPCustomer.Mailings.LoadWith(m => m.MailingRecipients.LoadWith(mr => mr.MailingDownloads.LoadWith(md => md.Mailing2Asset))).LoadWith(m => m.User)
							 join mr in PPCustomer.MailingRecipients on m.MailingId equals mr.MailingId
							 join sq in PPCustomer.MailingDownloads on mr.MailingRecipientId equals sq.MailingRecipientId into lj
							 from md in lj.DefaultIfEmpty()
							 join sq2 in PPCustomer.Mailing2Assets on m.MailingId equals sq2.MailingId into lj2
							 from ma in lj2.DefaultIfEmpty()
							 where m.MailingId == mailingId
								&& ((mr.MailingRecipientId == mailingRecipientId && m.Password == password)
									|| mr.UserId == CoreInfo.User.UserId
									|| editAllMailings)
							 select new { Mailing = m, Mailing2Asset = ma }).Distinct(); 

var mailing = recordSet.First().Mailing;

Code: Select all

SELECT DISTINCT t1.`MailingId`, t1.`State`, t1.`CreationDate`, t1.`CreatedByUserId`, t1.`Subject`, t1.`Message`, t1.`Password`, t1.`ExpirationDate`, t1.ts, t4.`Mailing2AssetId`, t4.`MailingId` AS MailingId1, t4.`AssetId`, t4.`ImageFormatId`, t4.`LanguageVersion`, t4.ts AS ts1
FROM tbl_mailings t1
INNER JOIN tbl_mailing_recipients t2 ON t1.`MailingId` = t2.`MailingId`
LEFT OUTER JOIN tbl_mailing_downloads t3 ON t2.`MailingRecipientId` = t3.`MailingRecipientId`
LEFT OUTER JOIN tbl_mailings2assets t4 ON t1.`MailingId` = t4.`MailingId`
WHERE (t1.`MailingId` = :p0) AND (((t2.`MailingRecipientId` IS NULL) AND (t1.`Password` IS NULL)) OR (t2.`UserId` = :p1) OR :p2) LIMIT 1
ParameterName = p0
DbType = Int32
Value = 153
ParameterName = p1
DbType = Int32
Value = 2
ParameterName = p2
DbType = Int64
Value = True

SELECT t1.`MailingRecipientId`, t1.`MailingId`, t1.`UserId`, t1.`EmailAddress`, t1.`RecipientType`, t1.`ReadReceiptTime`, t1.ts, t3.`MailingDownloadId`, t3.`MailingRecipientId` AS MailingRecipientId1, t3.`Mailing2AssetId`, t3.`DownloadTime`, t3.ts AS ts1
FROM (
    SELECT t2.`MailingRecipientId`, t2.`MailingId`, t2.`UserId`, t2.`EmailAddress`, t2.`RecipientType`, t2.`ReadReceiptTime`, t2.ts
    FROM tbl_mailing_recipients t2
    WHERE :np0 = t2.`MailingId`
    ) t1
LEFT OUTER JOIN tbl_mailing_downloads t3 ON t1.`MailingRecipientId` = t3.`MailingRecipientId`
ORDER BY t1.`MailingRecipientId`
ParameterName = np0
DbType = Int32
Value = 153

SELECT t1.UserId, t1.Lastname, t1.Firstname, t1.Tel, t1.Company, t1.Street, t1.Address2, t1.Zip, t1.City, t1.Country, t1.Password, t1.Department, t1.CreationDate, t1.LastLogin, t1.InvalidLoginAttempts, t1.ExpirationDate, t1.EmailAddress, t1.Language, t1.AllowUpdate, t1.UseLDAP, t1.LoginOnlyWithSecurityToken, t1.hideIconShowMore, t1.InternalContactUserId, t1.Comment, t1.State, t1.CDF1, t1.CDF2, t1.CDF3
FROM tbl_users t1
WHERE :np0 = t1.UserId
ParameterName = np0
DbType = Int32
Value = 2

Code: Select all

from m in PPCustomer.Mailings.LoadWith(m => m.MailingRecipients)
join mr in PPCustomer.MailingRecipients.LoadWith(mr => mr.MailingDownloads) on m.MailingId equals mr.MailingId
select m

Code: Select all

 (from m in PPCustomer.Mailings
where m.Subject.Contains("test") 
select m).Count();

Code: Select all

SELECT COUNT(*) AS C1
FROM tbl_mailings t1
WHERE  BINARY t1.`Subject` LIKE '%test%'

Code: Select all

SELECT COUNT(*) AS C1
FROM tbl_mailings t1
WHERE  t1.`Subject` LIKE '%test%'

Code: Select all

 (from m in PPCustomer.Mailings
where m.Subject.Contains("test", StringComparer.CurrentCultureIgnoreCase) 
select m).Count();

Code: Select all

			string searchString = null;

			if (true || "test".Contains(searchString))
				searchString = "";

Code: Select all

			string searchString = null;
			var recordSet = (from m in PPCustomer.Mailings
							 where String.IsNullOrEmpty(searchString) || m.Subject.Contains(searchString)
							 select m);

Code: Select all

var recordSet = (from m in PPCustomer.Mailings
                         select m);

int totalMailings = recordSet.Count();

Code: Select all

var recordSet = (from m in PPCustomer.Mailings
                         join mr in PPCustomer.MailingRecipients on m.MailingId equals mr.MailingId
                         select m);

int totalMailings = recordSet.Count();

Code: Select all

var recordSet = from l in PPCustomer.LoginInfos.LoadWith(l => l.LoginInfoHistories)
where l.CookieGuid == guid.ToString()
select l;

return recordSet.Single();

Code: Select all

var recordSet = from l in PPCustomer.LoginInfos.Include(l => l.LoginInfoHistories)
where l.CookieGuid == guid.ToString()
select l;

return recordSet.Single();

Code: Select all

Customer.LoginInfos.DeleteAllOnSubmit(Customer.LoginInfos.Where(l => l.LoginTime.AddDays(days) (l => l.LoginInfoHistories);
Customer.LoadOptions = dataLoadOptions;

var recordSet = from l in Customer.LoginInfos				select l;

Code: Select all

[MySqlException (0x80004005): Lost connection to MySQL server during query]
   Devart.Common.Web.Providers.DbSessionStateStore.a(Boolean A_0, HttpContext A_1, String A_2, Boolean& A_3, TimeSpan& A_4, Object& A_5, SessionStateActions& A_6) +3114
   Devart.Common.Web.Providers.DbSessionStateStore.GetItemExclusive(HttpContext context, String id, Boolean& locked, TimeSpan& lockAge, Object& lockId, SessionStateActions& actionFlags) +57
   System.Web.SessionState.SessionStateModule.GetSessionStateItem() +117
   System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData) +487
   System.Web.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +66
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155