Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>A private setter for a List, Collection, etc. means that the entire list cannot be replaced by consumers, but it does nothing to protect the public members of the list.</p> <p>For example:</p> <pre><code>public class MyClass { public IList&lt;string&gt; MyList {get; private set;} public MyClass() { MyList = new List&lt;string&gt;(){"One","Two", "Three"}; } } public class Consumer { public void DoSomething() { MyClass myClass = new MyClass(); myClass.MyList = new List&lt;string&gt;(); // This would not be allowed, // due to the private setter myClass.MyList.Add("new string"); // This would be allowed, because it's // calling a method on the existing // list--not replacing the list itself } } </code></pre> <p>In order to prevent consumers from altering the members of the list you could expose it as a Read-only interface, such as <code>IEnumerable&lt;string&gt;</code>, <code>ReadOnlyCollection&lt;string&gt;</code>, or by calling <code>List.AsReadOnly()</code> within the declaring class.</p> <pre><code>public class MyClass { public IList&lt;string&gt; MyList {get; private set;} public MyClass() { MyList = new List&lt;string&gt;(){"One","Two", "Three"}.AsReadOnly(); } } public class Consumer { public void DoSomething() { MyClass myClass = new MyClass(); myClass.MyList = new List&lt;string&gt;(); // This would not be allowed, // due to the private setter myClass.MyList.Add("new string"); // This would not be allowed, the // ReadOnlyCollection&lt;string&gt; would throw // a NotSupportedException } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow to make a readonly C# List by non declaring its set attribute
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USPeter Mortensen
    1. USSTW
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COJust a note: exposing it as `IEnumerable<string>` will _not_ prevent modifications to the underlying list. Users can still cast to `List<string>` and make changes. (but it's easy enough to change it so instead of directly returning it to use `yield return`, or as you suggest, `List.AsReadOnly()`)
      singulars
      1. PO
      1. USChris Sinclair
    2. CO@ChrisSinclair true, `AsReadOnly()` is the better of the options
      singulars
      1. PO
      1. USSTW
    3. COI think you may need to take a second pass on your code. I think you got some type declarations/initializations mixed up and won't compile. And likely `MyClass` will want to privately make modifications to `MyList` in your second example.
      singulars
      1. PO
      1. USChris Sinclair
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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