public int Delete(GenericDatabase db, String conditions) { string sql = "DELETE FROM " + TableName + " WHERE " + conditions; DbCommand dbCommand = db.GetOpenedConnection().CreateCommand(); dbCommand.CommandText = sql; return dbCommand.ExecuteNonQuery(); }
public DataTable GetFields(GenericDatabase db, string columns, string condetions = null) { DbCommand dbCommand = db.GetOpenedConnection().CreateCommand(); dbCommand.CommandText = "SELECT " + columns + " FROM " + TableName; if (condetions != null) { dbCommand.CommandText += " WHERE " + condetions; } return GetDataTableFromCommand(dbCommand); }
public bool LoadWithPrimaryKey(GenericDatabase db, object primaryKeyValue) { DbCommand dbCommand = db.GetOpenedConnection().CreateCommand(); dbCommand.CommandText = "SELECT * FROM " + TableName + " WHERE " + PrimaryKey.Name + " = " + db.GetAsParameterName(PrimaryKey.Name); dbCommand.Parameters.Add(db.GetDBCellAsDBParameter(dbCommand, new DBCell(PrimaryKey.Name, PrimaryKey.Type, primaryKeyValue))); return FillObjectWithDataReader(dbCommand); }
public bool Load(GenericDatabase db, string conditions) { DbCommand dbCommand = db.GetOpenedConnection().CreateCommand(); dbCommand.CommandText = "SELECT * FROM " + TableName + " WHERE " + conditions; return FillObjectWithDataReader(dbCommand); }
public int Insert(GenericDatabase db) { DbCommand dbCommand = GetInsertCommand(db, db.GetOpenedConnection(), TableName, Values); return dbCommand.ExecuteNonQuery(); }
private bool isValueExistsWithColumns(GenericDatabase db, String[] keyNames) { bool exists = false; if (keyNames == null) { throw new NullReferenceException(); } else { if ((keyNames.Length <= 0) || (keyNames.Length > Values.Length)) { throw new ArgumentException(); } else { String sql = "Select TOP 1 * from " + TableName + " where "; DbCommand cmd = db.GetOpenedConnection().CreateCommand(); for (int i = 0; i < keyNames.Length; i++) { DBCell cell = this[keyNames[i]]; sql += " " + keyNames[i] + " = " + db.GetAsParameterName(keyNames[i]) + " and "; cmd.Parameters.Add(db.GetDBCellAsDBParameter(cmd, cell)); } sql += " 1=1"; cmd.CommandText = sql; exists = (GetDataTableFromCommand(cmd).Rows.Count > 0); } } return exists; }
public int Update(GenericDatabase db, String conditions) { DbCommand dbCommand = GetUpdateCommand(db, db.GetOpenedConnection(), TableName, Values); if (conditions != null) { dbCommand.CommandText += " WHERE " + conditions; } return dbCommand.ExecuteNonQuery(); }