Devart Forums

Code: Select all

Devart.Data.Linq.DataLoadOptions dataLoadOptions = new Devart.Data.Linq.DataLoadOptions();
dataLoadOptions.LoadWith(c => c.CountryTranslations);
dataLoadOptions.AssociateWith(c => c.CountryTranslations.Where(ct => ct.LanguageId == (int)Language));
MyDataContext.LoadOptions = dataLoadOptions;
MyDataContext.DeferredLoadingEnabled = false;

var recordSet = from c in MyDataContext.Countries
				join ct in MyDataContext.CountryTranslations on c.CountryId equals ct.CountryId
				where ct.LanguageId == (int)Language
				orderby ct.CountryName
				select c;

List countries = recordSet.ToList();

Code: Select all

SELECT t1.`CountryId`, t1.`CountryCode`, t1.ts
FROM tbl_countries t1
INNER JOIN tbl_country_translations t2 ON t1.`CountryId` = t2.`CountryId`
WHERE t2.`LanguageId` = 2
ORDER BY t2.`CountryName`

SELECT t1.`CountryTranslationId`, t1.`CountryId`, t1.`LanguageId`, t1.`CountryName`, t1.ts
FROM tbl_country_translations t1
WHERE (t1.`LanguageId` = 2) AND (3 = t1.`CountryId`)

SELECT t1.`CountryTranslationId`, t1.`CountryId`, t1.`LanguageId`, t1.`CountryName`, t1.ts
FROM tbl_country_translations t1
WHERE (t1.`LanguageId` = 2) AND (6 = t1.`CountryId`)

SELECT t1.`CountryTranslationId`, t1.`CountryId`, t1.`LanguageId`, t1.`CountryName`, t1.ts
FROM tbl_country_translations t1
WHERE (t1.`LanguageId` = 2) AND (59 = t1.`CountryId`)

SELECT t1.`CountryTranslationId`, t1.`CountryId`, t1.`LanguageId`, t1.`CountryName`, t1.ts
FROM tbl_country_translations t1
WHERE (t1.`LanguageId` = 2) AND (12 = t1.`CountryId`)

Code: Select all

SELECT t1.`SiteId`, t1.`SkinId`, t1.`Name`, t1.`Title`, t1.`ScriptSource`, t1.ts
FROM tbl_sites t1
WHERE t1.`Name` = :p0
ORDER BY t1.`Name`

Code: Select all

SELECT t1.`SkinId`, t1.`Name`, t1.`HtmlSource`, t1.`CssSource`, t1.ts
FROM tbl_skins t1
WHERE :np0 = t1.`SkinId`

Code: Select all

MyDataContext.Skins.Attach(skin, true);
MyDataContext.SubmitChanges();
return skin;

Code: Select all

SELECT ts FROM tbl_skins WHERE `SkinId` = :key1, ts = :key2

Code: Select all

PPGlobal.DeferredLoadingEnabled = false;

Code: Select all

var recordSet = from c in PPGlobal.Countries
				join ct in PPGlobal.CountryTranslations on c.CountryId equals ct.CountryId
				join l in PPGlobal.Languages on ct.LanguageId equals l.LanguageId
				where l.Abbreviation.ToLower() == "en"
				select new { CountryTranslation = ct, Country = c };


List countries = new List();
foreach (var record in recordSet)
{
	record.Country.CountryTranslations.Add(record.CountryTranslation);
	countries.Add(record.Country);
}