SubSonic-3.0
SubSonic-3.0 copied to clipboard
subsonic
string array in linq-expression
DOESN'T work: string[] splitByDot = inKey.Split('.'); Tim.Data.TimLanguageTranslation translation = mRepo.Single<Tim.Data.TimLanguageTranslation>(x => x.Group == splitByDot[0] && x.Title == splitByDot[1] && x.IsTrash == false && x.Language == mLanguage);
because it generates the following query:
SELECT
Language,
Group,
Title,
Text,
Id,
CreationDate,
ModificationDate,
CreatedBy,
ModifiedBy,
Revision,
RevisionRelatedToId,
IsTrash FROM
TimLanguageTranslations
WHERE splitByDot = '' AND
splitByDot = @1 AND
IsTrash = @2 AND
Language = @3
this however works: string[] splitByDot = inKey.Split('.'); string group = splitByDot[0]; string title = splitByDot[1]; Tim.Data.TimLanguageTranslation translation = mRepo.Single<Tim.Data.TimLanguageTranslation>(x => x.Group == group && x.Title == title && x.IsTrash == false && x.Language == mLanguage);
Is it because string-arrays isn't supported as comparison-parameter or something like that?
