Typed DataSet and Linq Woes
-
Hello All, I love linq, I even love linq with typed datasets, but the isnull() functionality is driving me nuts. We are required to use a dataset in a product of ours, and although I can write slick joins with linq, everytime a come across a nullable column, i'm writing what seems like needless code, (well that's my attitude since nullable types surfaced). My question is two fold, 1., has anyone come up with an elegant way to convert or handle nullable columns in datasets as nullable types. 2. Can you do write a linq query with a multiple condition join, like this:
(from fm in _oRentCalcDataSet.FamilyMember
join f in _oRentCalcDataSet.Family
on !fm.IsfkFamilyNull() && fm.fkFamily equals f.PKI'm not having much luck. Thanks! Ryan
-
Hello All, I love linq, I even love linq with typed datasets, but the isnull() functionality is driving me nuts. We are required to use a dataset in a product of ours, and although I can write slick joins with linq, everytime a come across a nullable column, i'm writing what seems like needless code, (well that's my attitude since nullable types surfaced). My question is two fold, 1., has anyone come up with an elegant way to convert or handle nullable columns in datasets as nullable types. 2. Can you do write a linq query with a multiple condition join, like this:
(from fm in _oRentCalcDataSet.FamilyMember
join f in _oRentCalcDataSet.Family
on !fm.IsfkFamilyNull() && fm.fkFamily equals f.PKI'm not having much luck. Thanks! Ryan