How T4 generates multiple files

[Seanxwy]

No description provided.

[igor-tkachev]

Look at this example https://github.com/linq2db/linq2db/blob/master/Tests/T4.Model/MultipleFiles.tt

[Seanxwy]

This example is not a data-independent model file directly from the database

[igor-tkachev]

So, you need to generate a data model from database but every table should be in a separate file. Right?

[Seanxwy]

@igor-tkachev Yeah, that's it

[Drapondur]

So, you need to generate a data model from database but every table should be in a separate file. Right?

This is, although not too tough, not an entirely simple task, at least as far as I can see.
I came up with the following solution provided in the attached file MultiFileSupport.zip.
I made this for linq2db 2.9.5.

Put the file in your project directory (not the LinqToDB.Templates directory).

Then in your .tt-file:

<#@ template language="C#" debug="True" hostSpecific="True"                           #>
<#@ output extension=".generated.cs"                                                  #>

<#@ include file="$(LinqToDBT4SqlServerTemplatesDirectory)MultipleFiles.ttinclude" #>
<#@ include file="$(LinqToDBT4SqlServerTemplatesDirectory)LinqToDB.SqlServer.Tools.ttinclude" #>
<#@ include file="$(LinqToDBT4SqlServerTemplatesDirectory)PluralizationService.ttinclude"     #>

<#//@ include file="$(ProjectDir)LinqToDB.Templates\MultipleFiles.ttinclude" #>
<#//@ include file="$(ProjectDir)LinqToDB.Templates\LinqToDB.SqlServer.Tools.ttinclude" #>
<#//@ include file="$(ProjectDir)LinqToDB.Templates\PluralizationService.ttinclude"     #>

<#@ include file="$(ProjectDir)MultiFileSupport.ttinclude"     #>

//The usual stuff here like
//	LoadSqlServerMetadata("MyServer", "MyDatabase", "User", "Password");
//etc. up to

GenerateModel();

//and now
SyncProject();

There is room for improvement, but you get the gist.

[ademchenko]

@Drapondur , works awesome. Thanks a lot!

[Drapondur]

Thanks ademchenko. Yes it seems to work except for the case that files do not get deleted properly.
After having dropped a table the generated file for the table was still there.
I believe that is the case for SDK style projects only. I haven't used it for the old project style yet.
However, I added a workaround I uploaded to here: MultiFileSupport.zip
A new variable named ClearMultiFileDir (bool) is introduced which is false per default.
If set to true all files with the extension defined in MultiFileExtension will be deleted from the target directory before new files are generated.
Important: If you use the file I uploaded to this post you must replace SyncProject() at the end of your tt-file with FinalizeMultiFiles()

<#@ template language="C#" debug="True" hostSpecific="True"                           #>
<#@ output extension=".generated.cs"                                                  #>

<#@ include file="$(LinqToDBT4SqlServerTemplatesDirectory)MultipleFiles.ttinclude" #>
<#@ include file="$(LinqToDBT4SqlServerTemplatesDirectory)LinqToDB.SqlServer.Tools.ttinclude" #>
<#@ include file="$(LinqToDBT4SqlServerTemplatesDirectory)PluralizationService.ttinclude"     #>

<#//@ include file="$(ProjectDir)LinqToDB.Templates\MultipleFiles.ttinclude" #>
<#//@ include file="$(ProjectDir)LinqToDB.Templates\LinqToDB.SqlServer.Tools.ttinclude" #>
<#//@ include file="$(ProjectDir)LinqToDB.Templates\PluralizationService.ttinclude"     #>

<#@ include file="$(ProjectDir)MultiFileSupport.ttinclude"     #>

//The usual stuff here like
//	LoadSqlServerMetadata("MyServer", "MyDatabase", "User", "Password");
//etc. up to

GenerateModel();

//and now
FinalizeMultiFiles(); 

Have fun!

[emiletu]

FinalizeMultiFiles

I can't run with the latest one. Can you help me?