public DataTable ExecuteQuery(IDbCommand cmd, string rdbName) { IPersistenceProvider rdb = null; if (rdbName == "") { rdb = GetDatabase().GetCopy(); } else { rdb = GetDatabase(rdbName).GetCopy(); } try { rdb.Open(); DataTable dt = rdb.AsDataTable(cmd); return(dt); } catch (Exception ex) { this.ErrorHandle(ex, null, cmd.CommandText.ToString()); } finally { rdb.Close(); } return(null); }
public void SaveObject(PersistentObject obj) { ClassMap cm = this.GetClassMap(obj.GetClassName()); IPersistenceProvider rdb = cm.PersistenceProvider.GetCopy(); try { rdb.Open(); SaveObjectPrivate(obj, cm, rdb); } catch (Exception ex) { ErrorHandle(ex, obj); } finally { rdb.Close(); } }
public int Execute(IDbCommand cmd, string rdbName) { IPersistenceProvider rdb = null; if (rdbName == "") { rdb = GetDatabase().GetCopy(); } else { rdb = GetDatabase(rdbName).GetCopy(); } rdb.Open(); int intReturn = rdb.DoCommand(cmd); rdb.Close(); return(intReturn); }
public bool RetrieveObject(PersistentObject obj) { ClassMap clsMap = GetClassMap(obj.GetClassName()); IPersistenceProvider rdb = clsMap.PersistenceProvider.GetCopy(); bool blnResult = true; try { rdb.Open(); blnResult = RetrieveObjectPrivate(obj, clsMap, rdb); } catch (Exception ex) { ErrorHandle(ex, obj); } finally { rdb.Close(); } return(blnResult); }
public void DeleteObject(PersistentObject obj) { ClassMap clsMap = GetClassMap(obj.GetClassName()); IDbCommand cmd = clsMap.GetDeleteSqlFor(obj); IPersistenceProvider rdb = clsMap.PersistenceProvider.GetCopy(); try { rdb.Open(); if (rdb.DoCommand(clsMap.GetDeleteSqlFor(obj)) > 0) { obj.IsPersistent = false; } } catch (Exception ex) { this.ErrorHandle(ex, obj); } finally { rdb.Close(); } }