public static void ClearTable(string tableName, DALISGDatabaseType databaseType)
{
var db = new DatabaseProviderFactory().Create(Database.GetDABConnectionKey(databaseType));
using (var cmd = db.GetSqlStringCommand(string.Format("DELETE FROM {0}", tableName)))
{
cmd.CommandTimeout = 3000;
db.ExecuteNonQuery(cmd);
}
}
public static long GetRowCount(string tableName, string filterQuery, DALISGDatabaseType databaseType)
{
long rowCount;
var db = new DatabaseProviderFactory().Create(Database.GetDABConnectionKey(databaseType));
using (var cmd = db.GetSqlStringCommand(string.Format("SELECT COUNT(*) FROM {0} {1}", tableName, filterQuery)))
{
rowCount = Convert.ToInt64(db.ExecuteScalar(cmd));
}
return rowCount;
}
