Databases
StackOverflow2013
Postsdbo
PODTO Generator for EF 4 Entity model
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODTO Generator for EF 4 Entity model
    primarykey
    data
    text
    <p>Is it possible to write t4 template ( or if it already exists ) which will be able to generate DTO classes based on the data in the *.edmx file?</p> <p>I have to write DTO classes for the current project, and this process is kinda tiresome.</p> <p>What I trying to acquire is to get DTO classes which will have scalar properties defined as simple auto properties, and navigation parameters as incapsulated instances of other DTO classes.</p> <p>Example :</p> <pre><code>public class SomeClassDTO { public byte Id { get; set; } public string Description { get; set; } public OtherClassDTO SomeProperty {get;set;} public IList&lt;AnotherClassDTO&gt; Objects {get;set;} } </code></pre> <p>This is a good starting point, what is more desirable may look like following sample:</p> <pre><code>/// &lt;summary&gt; /// Employee details DTO. /// &lt;/summary&gt; public class EmployeeDetailsDTO { [Key] public long Id { get; set; } [Required] public string FirstName { get; set; } [Required] public string Surname { get; set; } ... public long? PhotoId { get; set; } // Home address properties. public string HomeAddressAddressLine1 { get; set; } // This is just name of field, not flattened list public string HomeAddressAddressLine2 { get; set; } public string HomeAddressAddressLine3 { get; set; } public string HomeAddressPostcode { get; set; } public short? HomeAddressCountryId { get; set; } public long? HomeAddressCountyId { get; set; } public long? HomeAddressTownId { get; set; } public short? HomeTelephoneCountryId { get; set; } public string HomeTelephoneNumber{ get; set; } public string HomeTelephoneExtension { get; set; } public short? PersonalMobileCountryId { get; set; } public string PersonalMobileNumber { get; set; } public string PersonalMobileExtension { get; set; } } </code></pre> <p>As you can see this is a flatten DTO which represent composite structure and may be injected back to entities through ValueInjector SameNameFlat/UnFlat injections.</p> <p>This is the ultimate goal, though any advices would be appreciated.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USv00d00
    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. PODTO Generator for EF 4 Entity model
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PODTO Generator for EF 4 Entity model
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PODTO Generator for EF 4 Entity model
      1. USSergey
      1. VTFavorite
    1. CODTO is specialized object for single purpose and in most cases its creation cannot be automatized because it usually contains additional properties or miss some properties from the entity (it is not 1:1 mapping of the entity) so creating DTOs which are just copy of your entities looks more like a problem in the architecture. Even your recursive T4 template can add properties which you do not need. DTO should pass only properties you need for the operation where DTO is used.
      singulars
      1. PODTO Generator for EF 4 Entity model
      1. USLadislav Mrnka
    2. COYes, sure, this t4 stuff just makes it easier. At least I don't have to write skeleton by hand for each dto that I creating. When I get scanned class, I can cut it in pieces as I want to.
      singulars
      1. PODTO Generator for EF 4 Entity model
      1. USv00d00
 

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