public void Main() { Director director = new Director(); Console.WriteLine("Cadena de conexión del SQL Server"); SQLServerBuilder CadenaBuilder = new SQLServerBuilder(); director.CrearConexion(CadenaBuilder); SQLServer sQLServer = CadenaBuilder.GetResult(); sQLServer.Imprimir(); Console.WriteLine("\nCadena de conexión del MySQL "); MySQLBuilder CadenaMySQLBuilder = new MySQLBuilder(); director.CrearConexion(CadenaMySQLBuilder); MySQL mySQL = CadenaMySQLBuilder.GetResult(); mySQL.Imprimir(); Console.WriteLine("\n Cadena de conexión del Access"); AccessBuilder CadenaAccessBuilder = new AccessBuilder(); director.CrearConexion(CadenaAccessBuilder); Access Access = CadenaAccessBuilder.GetResult(); Access.Imprimir(); Console.ReadLine(); }
public void DeveGerarScriptSelecao() { //Arrange var builder = new SQLServerBuilder <PessoaMock>(); //Act var select = builder.BuildSelect(); //Assert Assert.AreEqual("select id, nome, datanascimento from pessoa", select.ToLower()); }
public void DeveGerarScriptInsert() { //Arrange var builder = new SQLServerBuilder <PessoaMock>(); var pessoa = new PessoaMock() { Id = 1, Nome = "João", DataNascimento = new DateTime(2000, 01, 01) }; IDictionary <string, object> parametros = new Dictionary <string, object>(); //Act var insert = builder.BuildInsert(pessoa, out parametros); //Assert Assert.AreEqual(@"insert into pessoa values(1, 'João', '2000-01-01'", insert.ToLower()); }