View Complete Post
I created one simple list and added one column - lookup - I've chosen some source list and field, then marked "Allow multiple choice". I created new item in that list, by adding more than one valie to that coulm.
The problem is, when I use CAML query, that column has such values:
and it's suppose to be like this:
do You have any idea, why it doesn't query first ID?
I am using a LINQ query with multiple joins, the last join does not return any values even though values exist in the database. Below is my code.
when the query returns suiteNameTrg and SuiteTypeTrg are empty, all other values are returned correctly.
string suiteNameTrg = string.Empty;
string suiteTypeTrg = string.Empty;
using (DataClassesDataContext db = new DataClassesDataContext())
var productQuery = from assets in db.ASSETs
join relocatableUnits in db.RELOCATABLE_UNITs on assets.RUID equals relocatableUnits.RUID into assets_units
from relocatableUnits in assets_units.DefaultIfEmpty()
join build in db.BUILDINGs on assets.BUILDING_ID equals build.BUILDING_ID into assets_bins
from build in assets_bins.DefaultIfEmpty()
join test in db.TEST_SUITEs on assets.TEST_SUITE_ID equals test.TEST_SUITE_ID into test_bins
from test in test_bins.DefaultIfEmpty()
join testTrgt in db.TEST_SUITEs on assets.TARGET_TEST_SUITE_ID equals testTrgt.TEST_SUITE_ID into testTrgt_bins
from testTrgt in testTrgt_bins.DefaultIfEmpty()