/// <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);
}
}