POCO Class Generator (edit)
C# - Generate POCO from SQL Server
EntityFramework Reverse POCO Generator - Visual Studio Marketplace
POCO Generator - CodeProject (HAY HAY HAY)
How to create a poco class in entity framework (vkinfotek.com)
C# - Generate POCO from Oracle DB
shps951023/PocoClassGenerator: Mini POCO Class Generator (github.com) (HAY HAY HAY)
All Databases
shps951023/PocoClassGenerator: Mini POCO Class Generator (github.com) (HAY HAY HAY)
manhng83/PocoClassGenerator: Mini POCO Class Generator (github.com) (HAY HAY HAY)
Generating .NET POCO Classes for SQL Query Results -- Visual Studio Magazine (HAY HAY HAY)
CodVerter (SQL to Class)
visual studio 2010 - How to generate model from database using Dapper? - Stack Overflow
team.yudin: Database tables to C# POCO classes T4 template (teamyudin.blogspot.com)
T4 Template (SQL Server -> CSharp)
<#@ template language="C#" debug="True" #>
<#@ assembly name="System" #>
<#@ assembly name="System.Data" #>
<#@ assembly name="System.Core" #>
<#@ assembly name="System.Xml" #>
<#@ assembly name="Microsoft.SqlServer.ConnectionInfo" #>
<#@ assembly name="Microsoft.SqlServer.Management.Sdk.Sfc" #>
<#@ assembly name="Microsoft.SqlServer.Smo" #>
<#@ import namespace="System" #>
<#@ import namespace="System.Text" #>
<#@ import namespace="System.Xml" #>
<#@ import namespace="Microsoft.SqlServer.Management.Smo" #>
<#@ import namespace="System.Data.SqlClient" #>
<#@ import namespace="Microsoft.SqlServer.Management.Common" #>
namespace Namespace
{
<#
var databaseName = "testDb";
var serverConnection = new SqlConnection(
@"Data Source=.\SQLEXPRESS; Integrated Security=true; Initial Catalog=" + databaseName);
var svrConnection = new ServerConnection(serverConnection);
Server srv = new Server(svrConnection);
foreach (Table table in srv.Databases[databaseName].Tables)
{
#>
class <#= table.Name #>
{
<#
foreach (Column col in table.Columns)
{
#>
public <#= GetNetDataType(col.DataType.Name) #> <#= col.Name #> { get; set; }
<#
}
#>
}
<# }
#>
}
<#+
public static string GetNetDataType(string sqlDataTypeName)
{
switch (sqlDataTypeName.ToLower())
{
case "bigint":
return "Int64";
case "binary":
return "Byte[]";
case "bit":
return "bool";
case "char":
return "char";
case "cursor":
return string.Empty;
case "datetime":
return "DateTime";
case "decimal":
return "Decimal";
case "float":
return "Double";
case "int":
return "int";
case "money":
return "Decimal";
case "nchar":
return "string";
case "numeric":
return "Decimal";
case "nvarchar":
return "string";
case "real":
return "single";
case "smallint":
return "Int16";
case "text":
return "string";
case "tinyint":
return "Byte";
case "varbinary":
return "Byte[]";
case "xml":
return "string";
case "varchar":
return "string";
case "smalldatetime":
return "DateTime";
case "image":
return "byte[]";
default:
return string.Empty;
}
}
#>
AdminLTE
go2ismail/AdminLTE-ASP-NET-MVC: Asp.Net Example Version of Beautiful AdminLTE Template (github.com)
Dapper & Repository
Olek-HZQ/DapperRepository: Dapper and Repository Pattern in MVC (github.com)
