public static void CreateDatabase()
{
var conn = new SqlConnectionStringBuilder(Configuration.GetConnectionString("DefaultConnection"));
var rootDir = Path.GetFullPath(Path.Combine(Directory.GetCurrentDirectory(), "..", "..", "..", "..", ".."));
var dbName = conn.InitialCatalog;
var dbServer = conn.DataSource;
var dbTrusted = conn.IntegratedSecurity;
using (var ps = PowerShell.Create())
{
ps.AddScript($@"if (!(Test-Path ""{rootDir}\Database"")) {{
mkdir ""{rootDir}\Database""
}}");
var script = $@"
IF EXISTS(SELECT * FROM sys.databases WHERE name='{dbName}')
BEGIN
ALTER DATABASE [{dbName}] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE [{dbName}];
END
CREATE DATABASE [{dbName}] On (NAME = '{dbName}', FILENAME = '{rootDir}\Database\{dbName}.mdf') COLLATE SQL_Latin1_General_CP1_CI_AI;
";
var exec = $@"sqlcmd -S ""{dbServer}"" $(&{{ If({dbTrusted}) {{ ""-E"" }} }}) -Q ""{script}"" ";
ps.AddScript(exec);
var results = ps.Invoke();
foreach (var result in results)
{
Debug.Write(result.ToString());
ConsoleWrite.Color(result.ToString());
}
}
}
public static async Task ConnectionAnimal()
{
var connectionString = Configuration.GetConnectionString("DefaultConnection");
using (var db = new SessionHelper(connectionString))
{
var cachorro = new Cachorro();
await db.Session.SaveOrUpdateAsync(cachorro.New());
var papagaio = new Papagaio();
await db.Session.SaveOrUpdateAsync(papagaio.New());
await db.Session.FlushAsync();
var animais = db.Session.Query <Animal>().Count();
ConsoleWrite.Color($"Quantidade de entidades do tipo Animal: {animais}", ConsoleColor.Green);
var cachorros = db.Session.Query <Cachorro>().Count();
ConsoleWrite.Color($"Quantidade de entidades do tipo Cachorros: {cachorros}", ConsoleColor.Green);
var papagaios = db.Session.Query <Papagaio>().Count();
ConsoleWrite.Color($"Quantidade de entidades do tipo Papagaios: {papagaios}", ConsoleColor.Green);
}
}
public static async Task ConnectionPessoa()
{
var connectionString = Configuration.GetConnectionString("DefaultConnection");
using (var db = new SessionHelper(connectionString))
{
var pessoaFisica = new PessoaFisica();
await db.Session.SaveOrUpdateAsync(pessoaFisica.New());
var pessoaJuridica = new PessoaJuridica();
await db.Session.SaveOrUpdateAsync(pessoaJuridica.New());
await db.Session.FlushAsync();
var pessoas = db.Session.Query <Pessoa>().Count();
ConsoleWrite.Color($"Quantidade de entidades do tipo Pessoa: {pessoas}", ConsoleColor.Green);
var pessoasFisicas = db.Session.Query <PessoaFisica>().Count();
ConsoleWrite.Color($"Quantidade de entidades do tipo PessoaFisica: {pessoasFisicas}", ConsoleColor.Green);
var pessoasJuridicas = db.Session.Query <PessoaJuridica>().Count();
ConsoleWrite.Color($"Quantidade de entidades do tipo PessoaJuridica: {pessoasJuridicas}", ConsoleColor.Green);
}
}
static async Task Main(string[] args)
{
Console.ForegroundColor = ConsoleColor.Yellow;
ConsoleWrite.Color("======================================================================================================", ConsoleColor.Yellow);
ConsoleWrite.Color("Configurando Nhibernate com FluentNHibernate, Teste de Mapeamento do FluentNhibernate e FluentMigrator", ConsoleColor.Yellow);
ConsoleWrite.Color("======================================================================================================", ConsoleColor.Yellow);
var builder = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true);
Configuration = builder.Build();
CreateDatabase();
var serviceProvider = CreateServices();
using (var scope = serviceProvider.CreateScope())
{
UpdateDatabase(scope.ServiceProvider);
}
await ConnectionPessoa();
await ConnectionAnimal();
}
