Exception Handling in LINQ

Question

Hi In below LINQ I wanted to filter the rows which has days value more than 90. But some row might have NULL value in days field. I wanted to handle those row which has NULL in days field and log the corresponding row details like name class birthday and skip that row and continue with next row. ( Similar to Continue statement in for each loop) Could you help to get a solution? var tempItems = (from tmp in dt.AsEnumerable() where tmp .Field (days) > 90 select new { Name= tmp[Name] class = tmp[class] birthdate = tmp[birthdate] days= tmp[days] amount = tmp[amount] }).GroupBy(n => new { n.Name n.class });

Uday Dodiya · Answer

you want which rows that has days > 90 and also skip that value that has days have NULL values. and you also want those record that days value have NULL values for log. var tempItems = (from tmp in dt.AsEnumerable() where tmp .Field int >( days ) > 90 && tmp.Field int >( days ) != null select new { Name= tmp[ Name ] class = tmp[ class ] birthdate = tmp[ birthdate ] days= tmp[ days ] amount = tmp[ amount ] }).GroupBy(n => new { n.Name n. class }); var logrecords= (from tmp in dt.AsEnumerable() where tmp.Field int >( days ) == null select new { Name= tmp[ Name ] class = tmp[ class ] birthdate = tmp[ birthdate ] days= tmp[ days ] amount = tmp[ amount ] }).GroupBy(n => new { n.Name n. class });

Farhan Ahmed · Answer

try { var tempItems = (from tmp in dt.AsEnumerable() where tmp.Field int >( days ) > 90 select new { Name = tmp[ Name ] class = tmp[ class ] birthdate = tmp[ birthdate ] days = tmp[ days ] amount = tmp[ amount ] }).GroupBy(n => new { n.Name n. class }); } catch (Exception) { throw ; }