{Programming} & Life

Hey Ya’ll,
Well I was thinking of an ill-tricky way to append a string to the beginning of each list item in ASP.NET MVC’s SelectList collection, after thinking:

new SelectList(ViewData.Model.Formats.ForEach(x => x.Name = index + ” – ” + x.Name), “ID”, “Name”);

pausing (doh! – and not to mention not knowing how I would have gotten index incrementing..)
“Argument [...]

Another “gotcha” using LINQ to SQL that I’ve found if you wish to test for “null” on a nullable column in SQL Server using the “IS NULL” clause. See below, this C# statement does not return the results you would expect (Assume “ReadMessageTypeFields()” simply returns an IQueryable result):

return messageTypeFieldRepository.ReadMessageTypeFields().Where(x => x.MessageTypeID == messageTypeID).ToList();

Results undesired SQL [...]