private static IEnumerable <Class> GenerateClasses(IList <Table> tables)
{
var fileNames = new List <string>();
return((
from table in tables
let uniqueName = GenerateUniqueTableName(fileNames, table.Name.LegalCsharpName)
let classTemplate = ClassTemplateGenerator.Generate(table, uniqueName)
let content = ClassRenderer.Render(classTemplate)
select new Class($"{uniqueName}.cs", $"Entities\\{table.SchemaName}", content, table)
).ToList());
}
public async Task StartAsync(CancellationToken cancellationToken)
{
Console.WriteLine("--------Class generator--------");
Console.WriteLine("Example connection string: Persist Security Info=False;User ID=MY_SQL_USER;Password=MY_SQL_PASSWORD;Server=localhost,1433; Initial Catalog=MY_CATALOG_NAME");
Console.Write("Enter connection string: ");
var cs = Console.ReadLine();
Console.Write("Enter namespace: ");
var namespaceName = Console.ReadLine();
Console.Write("Enter output path: ");
var outputPath = Console.ReadLine();
if (!Directory.Exists(outputPath))
{
Directory.CreateDirectory(outputPath);
}
var explorer = new SqlServerSchemaExplorer(cs);
var tables = await explorer.GetTablesAsync(CancellationToken.None);
var renderer = new ClassRenderer();
foreach (var table in tables)
{
Console.WriteLine("Class:");
var content = renderer.Render(new ClassTemplate
{
Namespace = namespaceName,
Properties = table.Columns,
TypeName = table.Name.LegalCsharpName
});
Console.WriteLine(content);
var fileName = Path.Join(outputPath, $"{table.Name.LegalCsharpName}.cs");
Console.WriteLine($"Saving it to disk, see {fileName}");
File.WriteAllLines(fileName, content.Split(Environment.NewLine));
}
Console.WriteLine("Done.");
_applicationLifetime.StopApplication();
}