Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <h2>The Service Layer is your most important Contract</h2> <p>The most important interface that you can ever create in your entire system is your external facing service contract, this is what consumers of your service or application will bind to, i.e. the existing call-sites that often won't get updated along with your code-base - every other model is secondary. </p> <h3>DTOs are Best practices for remote services</h3> <p>In following of <a href="http://martinfowler.com/eaaCatalog/dataTransferObject.html">Martin Fowler's recommendation for using DTOs</a> (Data Transfer Objects) for remote services (<a href="http://msdn.microsoft.com/en-us/library/ff649585.aspx">MSDN</a>), <a href="http://www.palmmedia.de/Blog/2011/8/30/ioc-container-benchmark-performance-comparison">ServiceStack</a> encourages the use of clean, untainted POCOs to define a well-defined contract with that should kept in a largely implementation and dependency-free .dll. The benefits of this allows you to be able to re-use typed DTOs used to define your services with, as-is, in your <a href="https://github.com/ServiceStack/ServiceStack/wiki/Clients-overview">C#/.NET clients</a> - providing an end-to-end typed API without the use of any code-gen or other artificial machinery.</p> <h3>DRY vs Intent</h3> <p>Keeping things DRY should not be confused with clearly stating of intent, which you should avoid trying to DRY or <a href="http://ayende.com/blog/4769/code-review-guidelines-avoid-inheritance-for-properties">hide behind inheritance</a>, magic properties or any other mechanism. Having clean, well-defined DTOs provides a single source of reference that anyone can look at to see what each service accepts and returns, it allows your client and server developers to start their work straight away and bind to the external service models without the implementation having been written. </p> <p>Keeping the DTOs separated also gives you the freedom to re-factor the implementation from within without breaking external clients, i.e. your service starts to cache responses or leverages a NoSQL solution to populate your responses with.</p> <p>It's also provides the authoritative source (that's not leaked or coupled inside your app logic) that's used to create the auto-generated metadata pages, example responses, Swagger support, XSDs, WSDLs, etc. </p> <h3><a href="https://github.com/ServiceStack/ServiceStack/wiki/Auto-mapping">Using ServiceStack's Built-in auto-mapping</a></h3> <p>Whilst we encourage keeping separate DTO models, you don't need to maintain your own manual mapping as you can use a mapper like <a href="https://github.com/AutoMapper/AutoMapper">AutoMapper</a> or using ServiceStack's built-in Auto Mapping support, e.g:</p> <p>Create a new DTO instance, populated with matching properties on viewModel:</p> <pre><code>var dto = viewModel.ConvertTo&lt;MyDto&gt;(); </code></pre> <p>Initialize DTO and populate it with matching properties on a view model:</p> <pre><code>var dto = new MyDto { A = 1, B = 2 }.PopulateWith(viewModel); </code></pre> <p>Initialize DTO and populate it with <strong>non-default</strong> matching properties on a view model:</p> <pre><code>var dto = new MyDto { A = 1, B = 2 }.PopulateWithNonDefaultValues(viewModel); </code></pre> <p>Initialize DTO and populate it with matching properties that are annotated with the <strong>Attr</strong> Attribute on a view model:</p> <pre><code>var dto = new MyDto { A=1 }.PopulateFromPropertiesWithAttribute&lt;Attr&gt;(viewModel); </code></pre> <p>When mapping logic becomes more complicated we like to use extension methods to keep code DRY and maintain the mapping in one place that's easily consumable from within your application, e.g:</p> <pre><code>public static class MappingExtensions { public static MyDto ToDto(this MyViewModel viewModel) { var dto = viewModel.ConvertTo&lt;MyDto&gt;(); dto.Items = viewModel.Items.ConvertAll(x =&gt; x.ToDto()); dto.CalculatedProperty = Calculate(viewModel.Seed); return dto; } } </code></pre> <p>Which is now easily consumable with just:</p> <pre><code>var dto = viewModel.ToDto(); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POServiceStack new service side by side ASP.NET MVC website
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USmythz
    1. USmythz
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POServiceStack new service side by side ASP.NET MVC website
      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. 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. COthank you for providing me with something to show people when I try to explain this.
      singulars
      1. PO
      1. USmsarchet
    2. COI wish there were more details (code) about how to start writing a new service when we have a working site with Models and ViewModels. I tried to be specific with the Product example and this response goes more in trying to explain the theory and unrelated mapping functionality (which we rely on SimpleInjector for it).
      singulars
      1. PO
      1. USmare
    3. COi added some code for you to better understand what we want to RE-USE
      singulars
      1. PO
      1. USmare
 

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