/// <summary> /// Retorna um objeto DatabaseStructureDTO contendo o schema do Banco de dados. /// </summary> /// <param name="schema">Nome do schema representado no Banco de dados. Ex.: emp0001</param> public DatabaseStructureDTO GetSchema(string schema) { try { dbCommand = db.GetSqlStringCommand("SELECT nspname FROM pg_namespace" + " WHERE nspname = @schema;"); db.AddInParameter(dbCommand, "@schema", DbType.String, schema); using (IDataReader DR = db.ExecuteReader(dbCommand)) { DR.Read(); DatabaseStructureDTO tab = new DatabaseStructureDTO(); tab.Name = DR["nspname"].ToString(); return(tab); } } catch { throw; } }
public void CanDoExecuteDataReaderForGenericDatabaseForSqlProviderBug1836() { Database db = new GenericDatabase(@"server=(local)\SQLEXPRESS;database=Northwind;Integrated Security=true", SqlClientFactory.Instance); using (DbConnection connection = db.CreateConnection()) { connection.Open(); using (DbTransaction transaction = connection.BeginTransaction()) { using (IDataReader dataReader = db.ExecuteReader(transaction, CommandType.Text, "select * from [Order Details]")) {} transaction.Commit(); } } }
public void CanDoExecuteDataReaderForGenericDatabaseBug1836() { Database db = new GenericDatabase(@"Driver={Microsoft Access Driver (*.mdb)};Dbq=northwind.mdb;Uid=sa;Pwd=sa;", OdbcFactory.Instance); using (DbConnection connection = db.CreateConnection()) { connection.Open(); using (DbTransaction transaction = connection.BeginTransaction()) { using (IDataReader dataReader = db.ExecuteReader(transaction, CommandType.Text, "select * from [Order Details]")) {} transaction.Commit(); } } }
public void CanDoExecuteDataReaderForGenericDatabaseForSqlProviderBug1836() { Database db = new GenericDatabase(@"server=(localdb)\v11.0;database=Northwind;Integrated Security=true", SqlClientFactory.Instance); using (DbConnection connection = db.CreateConnection()) { connection.Open(); using (DbTransaction transaction = connection.BeginTransaction()) { using (IDataReader dataReader = db.ExecuteReader(transaction, CommandType.Text, "select * from [Order Details]")) { } transaction.Commit(); } } }
public void CanDoExecuteDataReaderForGenericDatabaseBug1836() { Database db = new GenericDatabase(@"Driver={Microsoft Access Driver (*.mdb)};Dbq=northwind.mdb;Uid=sa;Pwd=sa;", OdbcFactory.Instance); using (DbConnection connection = db.CreateConnection()) { connection.Open(); using (DbTransaction transaction = connection.BeginTransaction()) { using (IDataReader dataReader = db.ExecuteReader(transaction, CommandType.Text, "select * from [Order Details]")) { } transaction.Commit(); } } }
public void CanDoExecuteDataReaderForGenericDatabaseForSqlProviderBug1836() { Database db = new GenericDatabase(String.Format(@"server={0};database=Northwind;Integrated Security=true", ConfigurationManager.AppSettings["SqlServerDatabaseInstance"]), SqlClientFactory.Instance); using (DbConnection connection = db.CreateConnection()) { connection.Open(); using (DbTransaction transaction = connection.BeginTransaction()) { using (IDataReader dataReader = db.ExecuteReader(transaction, CommandType.Text, "select * from [Order Details]")) { } transaction.Commit(); } } }
public void CanDoExecuteDataReaderForGenericDatabaseBug1836() { Database db = new GenericDatabase($@"Driver={{Microsoft Access Driver (*.mdb, *.accdb)}};Dbq={Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location)}\Northwind.mdb;Uid=sa;Pwd=sa;", OdbcFactory.Instance); using (DbConnection connection = db.CreateConnection()) { connection.Open(); using (DbTransaction transaction = connection.BeginTransaction()) { using (IDataReader dataReader = db.ExecuteReader(transaction, CommandType.Text, "select * from [Order Details]")) { } transaction.Commit(); } } }
/// <summary> /// Verifica a existência de um Banco de dados específico no servidor. /// </summary> /// <param name="databasename">Nome do Banco de dados</param> /// <returns>VERDADEIRO caso já exista o Banco de dados</returns> public bool ExistsDatabase(string databasename) { try { dbCommand = db.GetSqlStringCommand("SELECT datname FROM pg_database" + " WHERE datname = @databasename;"); db.AddInParameter(dbCommand, "@databasename", DbType.String, databasename); using (IDataReader DR = db.ExecuteReader(dbCommand)) { DR.Read(); DR["datname"].ToString(); return(true); } } catch { return(false); } }