I want to create texttemplate(T4) which can generate POCOs from DB.

Hi platform-independent peeps, I want to ask a question I have a web API live project in dot net framework using repository pattern now I want to convert my project completely to dot net core 3 or later without using entity framework since we don't like it. Following are the things we use in the current project.

1) SQL server

2) PetaPoco library (Micro ORM)

3) T4 template for database generation (when I add a column in SQL and go to the template and just press ctrl + s it automatically generate the model fields in a respective table/class)

Now, I want to create that T4 template for dot net core 3 or later for database model auto-generation. Any help would be highly appreciated.

Ok,

you may use C# in your T4 template so this task is pretty simple:

1) include the namespaces you need for accessing your sqlserver ...

<#@ template debug="true" hostspecific="true" language="C#" #>
<#@ output extension=".cs" #>
<#@ assembly name="System.Core" #>
<#@ assembly name="System.Configuration" #>
<#@ assembly name="System.Data" #>
<#@ assembly name="System.Xml" #>
<#@ import namespace="System" #>
<#@ import namespace="System.IO" #>
<#@ import namespace="System.Linq" #>
<#@ import namespace="System.Text" #>
<#@ import namespace="System.Text.RegularExpressions" #>
<#@ import namespace="System.Data" #>
<#@ import namespace="System.Data.SqlClient" #>

You see the point ...

Now, use either a Datareader to retrieve the table structure or the MSSql Server selection :

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tableName'

When having your desired fields use WriteLine to write your files ...

<#+
public void WriteBurnJobTypes(string ns, List data)
{
WriteHeader();
WriteLine("namespace " + ns);
WriteLine("{");
WriteLine("\tusing System;");
WriteLine("");
WriteLine("\t///
");
WriteLine("\t/// Enumeration for all types of burnjobs defined");
WriteLine("\t/// ");
WriteLine("\t[Serializable]");
WriteLine("\tpublic enum BurnJobType");
WriteLine("\t{");
foreach (var jt in data)
{
WriteLine("\t\t///
");
WriteLine("\t\t/// " + jt.Name);
WriteLine("\t\t/// ");
WriteLine("\t\t" + jt.Name + " = " + jt.Id.ToString() + ",");
}
WriteLine("\t}");
WriteLine("}");
}
#>

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Mario Scheeren5y ago
Ok,
you may use C# in your T4 template so this task is pretty simple:
1) include the namespaces you need for accessing your sqlserver ...
<#@ template debug="true" hostspecific="true" language="C#" #>
<#@ output extension=".cs" #>

<#@ assembly name="System.Core" #>
<#@ assembly name="System.Configuration" #>
<#@ assembly name="System.Data" #>
<#@ assembly name="System.Xml" #>

<#@ import namespace="System" #>
<#@ import namespace="System.IO" #>
<#@ import namespace="System.Linq" #>
<#@ import namespace="System.Text" #>
<#@ import namespace="System.Text.RegularExpressions" #>
<#@ import namespace="System.Data" #>
<#@ import namespace="System.Data.SqlClient" #>
You see the point ...
Now, use either a Datareader to retrieve the table structure or the MSSql Server selection :
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tableName'
When having your desired fields use WriteLine to write your files ...
<#+

public void WriteBurnJobTypes(string ns, List data)
{
    WriteHeader();

    WriteLine("namespace " + ns);
    WriteLine("{");
    WriteLine("\tusing System;");
    WriteLine("");

    WriteLine("\t///
");
    WriteLine("\t/// Enumeration for all types of burnjobs defined");
    WriteLine("\t/// ");
    WriteLine("\t[Serializable]");
    WriteLine("\tpublic enum BurnJobType");
    WriteLine("\t{");

    foreach (var jt in data)
    {
        WriteLine("\t\t///
");
        WriteLine("\t\t/// " + jt.Name);
        WriteLine("\t\t/// ");
        WriteLine("\t\t" + jt.Name + " = " + jt.Id.ToString() + ",");
    }

    WriteLine("\t}");
    WriteLine("}");
}

#>
0