/// <summary>
/// Libera los recursos del objeto
/// </summary>
public void Dispose()
{
db.Disposed += (s, e) =>
{
db = null;
if (Disposed != null)
{
Disposed(this, EventArgs.Empty);
}
};
db.Dispose();
}
public override string GetSqlText(DataAccessor accessor, BLToolkit.Data.DbManager dbManager)
{
switch (dbManager.DataProvider.Name)
{
case ProviderName.MsSql:
case ProviderName.SqlCe: return(SqlText);
case ProviderName.Access: return(AccessText ?? SqlText);
case "Oracle":
case ProviderName.Oracle: return(OracleText ?? SqlText);
case ProviderName.Firebird: return(FbText ?? SqlText);
case ProviderName.SQLite: return(SQLiteText ?? SqlText);
}
throw new ApplicationException(string.Format("Unknown data provider '{0}'", dbManager.DataProvider.Name));
}
static long BLToolkit_DB2(int mappingsCount)
{
BLToolkit.Data.DbManager.AddConnectionString("Data Source=acer\\sqlserver;Initial Catalog=Northwind;Persist Security Info=True;User Id=sa;Password=1");
var sw = new Stopwatch();
sw.Start();
for (var i = 0; i < mappingsCount; i++)
{
using (var db = new BLToolkit.Data.DbManager())
{
var list = db
.SetCommand("SELECT * FROM test")
.ExecuteList<test>();
}
}
sw.Stop();
return sw.ElapsedMilliseconds;
}
static long BLToolkit_DB2(int mappingsCount)
{
BLToolkit.Data.DbManager.AddConnectionString("Data Source=acer\\sqlserver;Initial Catalog=Northwind;Persist Security Info=True;User Id=sa;Password=1");
var sw = new Stopwatch();
sw.Start();
for (var i = 0; i < mappingsCount; i++)
{
using (var db = new BLToolkit.Data.DbManager())
{
var list = db
.SetCommand("SELECT * FROM test")
.ExecuteList <test>();
}
}
sw.Stop();
return(sw.ElapsedMilliseconds);
}
/// <summary>
/// Constructor
/// </summary>
public DataAccess()
{
db = new BLToolkit.Data.DbManager();
}
