|
Post by Paul on Jul 22, 2011 6:43:21 GMT -5
Hello,
i get the following Linqer result: From tblaz In db.tblaz _ Join tblf In db.tblf On New With { .Filiale = CInt(tblaz.F) } Equals New With { .Filiale = tblf.F } _ Join tblma In db.tblma On New With { .PLU = CInt(tblaz.p) } Equals New With { .PLU = tblma.p } _ Where _ CStr(tblaz.Tag) >= "01.01.2011" And _ CStr(tblaz.Tag) <= "31.01.2011" _ Group New With {tblma, tblf, tblaz} By _ tblma.ma, _ tblf.k _ Into g = Group _ Order By _ ma, _ k _ Select _ ma, _ k, _ z = CType(g.Sum(Function(p) p.tblaz.z),Int32?)
But I need this for an untyped Dataset. Like this: tblaz("Tag")
|
|
|
Post by Mikhail Oumantsev on Jul 23, 2011 1:51:59 GMT -5
Linqer doesn't support untyped datasets. You need to do the rest of the work manually.
|
|