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

Question

What free tools can generate simple POCO / DTO classes from the MS SQL Server database? Using properties and fields, but nothing else .

Answer 1

Take a look MyGeneration is a free code generation tool for SQL Server that allows you to define patterns that will be driven by the database structure.

You decide what will come out on the other side.

Answer 2

I did not find anything suitable, so I created a very simple TSQL script. Here is the gist .

Output Example:

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; } }