title: How can I handle a NULLable Int column returned from a stored procedure in LINQ to SQL
body: <p>I have a stored procedure that returns two int Values.  The first can not be null but the second can actually return a null value.  When I try to execute my stored procedure using LINQ to SQL it fails with the statement:</p>
  
  <blockquote>
    <p>The null value cannot be assigned to a member with type System.Int32 which is a non-nullable value type.</p>
  </blockquote>
  
  <p>I tried to change my designer file in my DBML and add in:  <code>CanBeNull= true</code>  to the Column mapping of the Stored Procedures Result.</p>
  
  <p>I'm can seem to figure out the correct way to handle this, not sure if I can change my LINQ/C# code to account for the null (which would be preferable) or if I will have to update my Stored Procedure in some fashion.</p>