Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You first need to layout your domain model. here's small example how it could be (warning sample code, just to show the principle)</p> <pre><code>public abstract class BaseSpell { public string Name { get; set; } //... all spell related stuff public abstract int CalculateDamage(BaseCharacter character); } public class FireballSpell : BaseSpell { public override int CalculateDamage(BaseCharacter character) { //return the number of damagepoints if (character is WizardCharacter) return 0; if (character is BarbarianCharacter) return 100; } } public abstract class BaseCharacter { public int HitPoints { get; set; } public int XP { get; set; } public int Mana { get; set; } public string DieQuote { get; set; } // add all character related properties // implemented by child classes public abstract void UnderSpell(BaseSpell spell); public abstract void UnderDamage(int damage); public abstract void Die(); //... } public class WizardCharacter : BaseCharacter { // implement wizard public override void UnderSpell(BaseSpell spell) { // wizards are immune to spells UnderDamage(spell.CalculateDamage(this)); } public override void UnderDamage(int damage) { HitPoints -= damage; if (HitPoints &lt;= 0) Die(); } public override void Die() { // do whatever necessary DieQuote = "All your base are belong to us!!!"; } } public class BarbarianCharacter : BaseCharacter { public override void UnderSpell(BaseSpell spell) { // barbarians are susceptible to spells UnderDamage(spell.CalculateDamage(this)); } public override void UnderDamage(int damage) { HitPoints -= damage; if (HitPoints &lt;= 0) Die(); } public override void Die() { // do whatever necessary DieQuote = "I'll be back baby!"; } } </code></pre> <p>Then you need to create a service layer that interacts with the different entities in the domain (characters, spells, ...) and presentation layer that extracts the data needed for representation on your webpage. For example you could have a partial view where your show the status of your character (hitpoints, mana, XP,...) This is where the Viewmodel comes into play:</p> <pre><code>// presenter public class CharacterPresenter { public CharacterViewModel MainCharacterViewModel(){ // fill model with main character data (ie Character class) } } // controller public class CharacterController : Controller { private readonly CharacterPresenter characterPresenter; public CharacterController () { characterPresenter = new CharacterPresenter; } public ActionResult Info() { var model = characterPresenter.MainCharacterViewModel(); return View(model); } // and so on... } </code></pre> <p>Viewmodels are used to convey data between your controller and service layer. Typically they don't expose behaviour, that's what domain models are for...</p>
    singulars
    1. This table or related slice is empty.
    1. PORelation to C# classes in asp.net mvc
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USwhosrdaddy
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PORelation to C# classes in asp.net mvc
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    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. COThank you, I just found out 2 hours ago that my understanding of the models where to narrow and that they can function as a class on its own completely.
      singulars
      1. PO
      1. USRobbingDaHood
 

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