{Programming} & Life

Are you getting this? System.InvalidOperationException: The null value cannot be assigned to a member with type System.Int64 which is a non-nullable value type. On something like this? var totalSize = query.Sum(x => x.Size); This occurs because your LINQ property (in my case “Size”) is not nullable, and needs to be nullable because your Sum() operation [...]

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 [...]

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 [...]