Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>For doing conversions between a model class and a DTO, my preference is to do one of four things:</p> <p>a. use an implicit conversion operator (especially when dealing json-to-dotnet transitions).</p> <pre><code>public class Car { public Color Color {get; set;} public int NumberOfDoors {get; set;} } public class CarJson { public string color {get; set;} public string numberOfDoors { get; set; } public static implicit operator Car(CarJson json) { return new Car { Color = (Color) Enum.Parse(typeof(Color), json.color), NumberOfDoors = Convert.ToInt32(json.numberOfDoors) }; } } </code></pre> <p>and then usage is</p> <pre><code> Car car = Json.Decode&lt;CarJson&gt;(inputString) </code></pre> <p>or more simply</p> <pre><code> var carJson = new CarJson {color = "red", numberOfDoors = "2"}; Car car = carJson; </code></pre> <p>voila, instant conversion :)</p> <p><a href="http://msdn.microsoft.com/en-us/library/z5z9kes2.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/z5z9kes2.aspx</a></p> <p>b. Use linq projection to change the shape of the data</p> <pre><code>IQueryable&lt;Car&gt; cars = CarRepository.GetCars(); cars.Select( car =&gt; new { numberOfDoors = car.NumberOfDoors.ToString(), color = car.Color.ToString() } ); </code></pre> <p>c. Use some combination of the two </p> <p>d. Define an extension method (that could also be used in the linq projection)</p> <pre><code>public static class ConversionExtensions { public static CarJson ToCarJson(this Car car) { return new CarJson {...}; } } CarRepository.GetCars().Select(car =&gt; car.ToCarJson()); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POConstructing an object graph from a flat DTO using visitor pattern
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJason
    1. USJason
    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
    1. COBoth good suggestions :) The implicit cast operator is nice but does require the DTO to have intimate knowledge of the domain model, which is a no-no for me. The linq projection idea is actually a really good idea which I'm going to use when dealing with collections of DTO's, although the linq expression will simply defer to the CustomerFactory to make the conversion...
      singulars
      1. PO
      1. USMattDavey
    2. COI hear you. Personally, I'm ok with a little more coupling since a DTO is so closely related to the model; also, the ability to add multiple two way conversions is nice. p.s., I added another option above that I use from time to time along w/ linq projection. G'luck!
      singulars
      1. PO
      1. USJason
 

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