hi all,
i use latest llblgen pro, ef 4, vs 20120, ms sql server 2008 r2, all on w7/64.
actually, i have only one typed list in my project. it is a very simple inner join of 5 db tables using just attribs of one of these tables.
here is the code generated:
var current1 = from smc_Unit in current0
join smc_HardwarePlatform in this.HardwarePlatforms on smc_Unit.RowId equals smc_HardwarePlatform.Unit.RowId
join smc_HardwarePlatformApplication in this.HardwarePlatformApplications on [[smc_HardwarePlatform.HardwarePlatform_.HardwarePlatform]] equals smc_HardwarePlatformApplication.HardwarePlatform_.RowId
join smc_Application in this.Applications on smc_HardwarePlatformApplication.Application_.RowId equals smc_Application.RowId
join smc_Release in this.Releases on smc_Application.RowId equals smc_Release.Application.RowId
select new {smc_HardwarePlatform, smc_Unit, smc_HardwarePlatformApplication, smc_Application, smc_Release };
return current1.Select(v=>new FaxUnitsTypedListRow() { Name = v.smc_Unit.Name, RowId = v.smc_Unit.RowId, SerialNumber = v.smc_Unit.SerialNumber, UserdefinedName = v.smc_Unit.UserdefinedName } );
i put the error in [[ and ]]. this must be replaced by smc_HardwarePlatform.RowId. actually i have to change this every time, i generate the code.
can you provide me with a tip on how to define a typed list properly?
thank you in advance
regards
chris