Tool to automatically implement Repository pattern from database

by Ish Thomas   Last Updated January 18, 2018 23:05 PM

I'm looking for some kinda of tool, that will help me to code DTOs based on my database. I know, there is an automatic tool, provided by VS I don't want to use it. I'm not a big fan of "auto-generated stuff" (I know! I just asked exactly for that), I don't like how auto generated models works.

I have already a pretty big database, I'm implementing EF, Repository/Unit of work pattern around it and it's pretty tedious job. If there is a helper tool that will automatically create at least DTOs that would be great.

This is how my DTO looks like:

[Table("students")]
public class StudentsDto
{
    [Key, Column("studentsId")]
    public int StudentId { get; set; }

    [Column("born")]
    public DateTime? Born { get; set; }
}

Entity framework's model:

public class students
{
    public int studentsId { get; set; }
    public Nullable<System.DateTime> born { get; set; }
}

I'd love to have at least keys.

Thanks for help!



Related Questions


Encrypted ID to 3rd party application

Updated July 10, 2018 08:05 AM

Read Only Generic data access layer Best practice

Updated January 27, 2018 03:05 AM

Best way to model "Composite Skus"?

Updated December 03, 2016 08:02 AM

Entity Framework Lookup Tables

Updated August 05, 2015 15:02 PM

Managing Database Access for MicroServices

Updated February 15, 2018 18:05 PM