thnk2wn

System.Data.SqlTypes.SqlNullValueException was unhandled by user code
  HResult=-2146232015
  Message=Data is Null. This method or property cannot be called on Null values.
  Source=System.Data
  StackTrace:
       at System.Data.SqlClient.SqlBuffer.get_Int32()
       at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
       at HibernatingRhinos.Profiler.Appender.ProfiledDataAccess.ProfiledDataReader.GetInt32(Int32 ordinal)
       at System.Data.Entity.Core.Objects.Internal.ShapedBufferedDataRecord.ReadInt(DbDataReader reader, Int32 ordinal)
       at System.Data.Entity.Core.Objects.Internal.ShapedBufferedDataRecord.Initialize(DbDataReader reader, DbSpatialDataReader spatialDataReader, Type[] columnTypes, Boolean[] nullableColumns)

thnk2wn

// left join as a safety precaution
jobAdPosts = (from b in SqlContext.JobBoards
				join jap in SqlContext.JobAdPosts on new { JobBoardId = b.Id, JobAdId = vm.JobAd.Id } equals new { jap.JobBoardId, jap.JobAdId } into j1
				from jap in j1.DefaultIfEmpty()
				where b.IsActive
				orderby b.SortOrder ascending
				select jap).ToList();

thnk2wn

{
  "AppStatus": "Enabled",
  "ImageDeleteAfterTimeSpan": "7.00:00:00",
  "WallpaperOverrideUrl": "",
  "Search": {
    "DefaultOptions": {
      "Filters": "Size:Large",
      "Adult": "Moderate",
      "MinWidth": 1920,
      "MinHeight": 1080,