Databases
StackOverflow2013
Postsdbo
PO'Static/Constant' business objects
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO'Static/Constant' business objects
    primarykey
    data
    text
    <p>I don't quite know how to ask this question, so I'll phrase it as an example instead:</p> <p>Imagine in an application you have a <code>Country</code> object. There are two properties of this object: <code>Name</code>, and a '<code>Bordering Countries</code>' collection. More properties might be added later, but it will be the kind of information that would change very rarely (e.g. changes of country names/borders)</p> <p>Lets say this application needs to know about all of the countries in the world. <strong>Where would you store these object's state? How would you new them up?</strong> It seems silly to store all this state in the DB, since it won't change very often.</p> <p>One option might be to have an abstract 'country' base object, and have a class for each country inheriting from this with the details of each country. But this doesn't seem quite right to me.</p> <p><strong>What is the proper way of dealing with these kinds of objects?</strong></p> <p>UPDATES:</p> <p>Someone asked about language: C#</p> <p>Also, I'm coming at this from a web application perspective, so there wouldn't be multiple client installations where I'd have to worry about updating hard coded values.</p> <p>Most people have suggested not hardcoding the data, but using the DB or XML files to store the data. <strong>Could anyone provide an example of how this kind of object would be 'newed up' (from e.g. an XML file)? Would you use some kind of helper or factory method to obtain instance of a particular country?</strong></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPerception
    1. USUpTheCreek
    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. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PO'Static/Constant' business objects
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO'Static/Constant' business objects
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO'Static/Constant' business objects
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO"it won't change very often" - ever visited the Balkans?
      singulars
      1. PO'Static/Constant' business objects
      1. USDavid M
    2. COIndeed, but I would consider these changes to happen 'not very often'.
      singulars
      1. PO'Static/Constant' business objects
      1. USUpTheCreek
 

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