InsertDictionary.tt

<#@ template language="C#" #>
<#@ output extension=".sql" #>
<#@ assembly name="$(ProjectDir)bin\Debug\SiepaczeKoduSample.Infrastructure.dll" #>
<#@ import namespace="System.Collections.Generic" #>
<#@ import namespace="SiepaczeKoduSample.Infrastructure" #>

<#
	IList<Dictionary> dictionary = TemplateHelper.GetDictionary(@"C:\Users\Zaba\Pictures\SiepaczeKodu\Dictionary.csv");
#>

<#foreach (var item in dictionary)
{
#>
IF NOT EXISTS (SELECT TOP 1 * FROM dbo.Dictionary WHERE [key] = '<#= item.Key #>')
	INSERT INTO dbo.Dictionary ([key], [value], [description]) VALUES ( '<#= item.Key #>', '<#= item.Value #>', '<#= item.Description #>')
GO

<#
}
#>

TemplateHelper.cs

public class TemplateHelper
{
    public static IList<Dictionary> GetDictionary(string filePath)
    {
        IList<Dictionary> dictionary;

        var csvConfiguration = new CsvConfiguration
        {
            Encoding = Encoding.UTF8,
            CultureInfo = new System.Globalization.CultureInfo("pl-PL")
        };

        using (StreamReader reader = File.OpenText(filePath))
        {
            using(var csv = new CsvReader(reader, csvConfiguration))
            {
                dictionary = csv.GetRecords<Dictionary>().ToList();
            }
        }
        return dictionary;
    }
}