Databases
StackOverflow2013
Postsdbo
POSystem.NullReferenceException - Help
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSystem.NullReferenceException - Help
    text
    copied!<p>I might be rusty on my .NET but i can't fingure out my problem here.</p> <p>I know it trows an error because i don't check for "null" exception, but i don't get why it is null.</p> <p>The tNewObjFolder.cmdSets is null, but is a ICollection, so i should be able to use Add to add the tNewObjCmdSet to that right?</p> <p>If i remove the foreach (var tCmdSets in <em>*</em>) it works (but the i'm ovisly don't run the second foreach and there for never try to add anything to the cmdSets.Add function...</p> <p>Any help is appriciated.</p> <pre><code>using System; using System.Collections.Generic; using System.Collections.ObjectModel; using System.ComponentModel.DataAnnotations; using System.Globalization; using System.Linq; using System.Web; using System.Web.Mvc; using System.Data; using System.Data.Entity; using System.Data.Objects; namespace imageController.Models { public class settingsModels { public class objFolder { public decimal id { get; set; } public string name { get; set; } public string description { get; set; } public string bulkDirectory { get; set; } public ICollection&lt;objCmdSet&gt; cmdSets { get; set; } } public class objCmdSet { public decimal id { get; set; } public string name { get; set; } public string command { get; set; } public string destination { get; set; } public string filetype { get; set; } public decimal? imageId { get; set; } public decimal? folderId { get; set; } } public interface ISettingsService { List&lt;objFolder&gt; getFolders(); } public class settingsServices : ISettingsService { private settingsEntities _entities = new settingsEntities(); public List&lt;objFolder&gt; getFolders() { ICollection&lt;objFolder&gt; tmpFolders = new Collection&lt;objFolder&gt;(); foreach (var tFolders in _entities.IMG_SETTINGS_FOLDERS) { objFolder tNewObjFolder = new objFolder(); tNewObjFolder.id = tFolders.SETTINGS_FOLDER_ID; tNewObjFolder.name = tFolders.SETTINGS_FOLDER_NAME; tNewObjFolder.description = tFolders.SETTINGS_FOLDER_DESCRIPTION; tNewObjFolder.bulkDirectory = tFolders.SETTINGS_FOLDER_BULK; foreach (var tCmdSets in _entities.IMG_SETTINGS_CMDSETS.Where("it.SETTINGS_FOLDER_ID = @folderid", new ObjectParameter("folderid",tFolders.SETTINGS_FOLDER_ID))) { objCmdSet tNewObjCmdSet = new objCmdSet(); tNewObjCmdSet.id = tCmdSets.SETTINGS_CMDSET_ID; tNewObjCmdSet.name = tCmdSets.SETTINGS_CMDSET_NAME; tNewObjCmdSet.command = tCmdSets.SETTINGS_CMDSET_COMMAND; tNewObjCmdSet.destination = tCmdSets.SETTINGS_CMDSET_DESTINATION; tNewObjCmdSet.filetype = tCmdSets.SETTINGS_CMDSET_FILETYPE; tNewObjCmdSet.imageId = tCmdSets.SETTINGS_IMAGETYPE_ID; tNewObjCmdSet.folderId = tCmdSets.SETTINGS_FOLDER_ID; tNewObjFolder.cmdSets.Add(tNewObjCmdSet); } tmpFolders.Add(tNewObjFolder); } return tmpFolders.ToList&lt;objFolder&gt;(); } } } </code></pre> <p>}</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload