Linq is not null vb.net

Posted Jun am Nirav Prabtani. Add your solution here. OK Paste as. Treat my content as plain text, not as HTML. Existing Members Sign in to your account. This email is in use. Do you need your password? Submit your solution! When answering a question please: Read the question carefully.

Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome. Don't tell someone to read the manual. As you can see, I'm using VB. If I remove the c. So I thought perhaps I needed to do a select new, but I don't think I was doing that correctly either.

EDIT: you need to check c for null, specifically the c after your grouping. See my updates below. You need to do a null check on tClassCode c in your select statement. What type is tClassCode? You should be able to do a null check on the value c and if it's null cast a nullable of the respective type and returned it, otherwise return the actual value. Since I am not sure what tClassCode is let's assume it's an integer, in which case the cast would be to a nullable integer Integer?

With that in mind your select statement, to be added at the end of what you have so far, should resemble:. Depending on what you need to do if c is null you could return String.

Empty instead of Nothing :. Of course you are free to further expand the selection of "e" to project its specific columns by name. The important thing to realize is that you must check c for null before using any of its properties since it might be null depending on the left outer join result for a particular result row. Back to my earlier example, if you had another field named Priority that was an integer you would cast against a nullable:. Well, I got it working An object may not exist.

A reference may point to nothing. We use the literal Nothing to indicate a null, nil, nonexistent object. Nothing details. We assign to Nothing, test against it, and ponder nothingness. A NullReferenceException is caused by accessing something on a Nothing value. First example. This program assigns a String variable to Nothing. This is not an empty string. It is a String object that does not exist. We compare it to Nothing in an If-statement. Part 1 We use the "Is" operator for testing references against Nothing.

Part 2 We use the IsNothing function to see if a reference is equal to Nothing. The content you requested has been removed. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Sign in to vote. Hi All, I'm sure this is a pretty simple one, but I can't seem to find an answer anywhere I'd like to perform a simple sum in VB. Thursday, September 2, AM.