Tool for generating POCO/DTO from database (SQL Server)

What free tools can generate simple POCO/DTO classes from MS SQL Server database? With Properties and fields, but nothing more.

Answers


Have a look at MyGeneration - it's a free code generation tool for SQL Server that lets you define templates that will be driven by the database structure.

You decide what will come out on the other side.


Found nothing suitable so created a very simple TSQL script. Here is the gist.

Sample output:

public class EmployeeDto
{
        public int Id { get; set; }
        public int AccountId { get; set; }
        public string ExternalId { get; set; }
        public string EmailAddress { get; set; }
        public bool IsActive { get; set; }
        public string UniqueId { get; set; }
        public bool IsBuiltIn { get; set; }
        public string LastName { get; set; }
        public string FirstName { get; set; }
        public string MiddleName { get; set; }
        public bool IsAuthorizedOnAllDepartments { get; set; }
}

Need Your Help

JavaPOS - Epson TM-T88IV - UnsatisfiedLinkError in Eclipse

eclipse printing unsatisfiedlinkerror epson javapos

I bought an Epson TM-T88IV Thermal printer. I installed the Epson JavaPOS ADK by using the install manual.

Conditional in makefile that redefines variable?

bash unix build makefile sh

I have a variable in my makefile I would like to either unset or redefine, so that targets a, b and c use the correct value of MY_VARIABLE (or none at all) within their respective makefiles.