/// <summary> /// Makes a shallow copy of the current DbContentCommentCollection. /// as the parent object. /// </summary> /// <returns>DbContentCommentCollection</returns> public DbContentCommentCollection Clone() { DbContentCommentCollection clonedDbContentComment = new DbContentCommentCollection(count); lock (this) { foreach (DbContentComment item in this) { clonedDbContentComment.Add(item); } } return(clonedDbContentComment); }
/// <summary> /// Makes a deep copy of the current DbContentComment. /// </summary> /// <param name="isolation">Placeholders are used to isolate the /// items in the DbContentCommentCollection from their children.</param> public DbContentCommentCollection Copy(bool isolated) { DbContentCommentCollection isolatedCollection = new DbContentCommentCollection(count); lock (this) { if (isolated) { for (int i = 0; i < count; i++) { isolatedCollection.Add(DbContentCommentArray[i].NewPlaceHolder()); } } else { for (int i = 0; i < count; i++) { isolatedCollection.Add(DbContentCommentArray[i].Copy()); } } } return(isolatedCollection); }
public DbContentCommentCollection GetCollection(int topCount, string whereClause, string sortClause) { StringBuilder query; Database database; DbCommand dbCommand; IDataReader r; DbContentCommentCollection dbContentCommentCollection; query = new StringBuilder("SELECT "); if (topCount > 0) { query.Append("TOP "); query.Append(topCount); query.Append(" "); } foreach (string columnName in InnerJoinFields) { query.Append("DbContentComment."); query.Append(columnName); query.Append(","); } // // Remove trailing comma // query.Length--; query.Append(" FROM kitCms_Comments AS DbContentComment"); // // Render where clause // if (whereClause != string.Empty) { query.Append(" WHERE "); query.Append(whereClause); } // // Render sort clause // if (sortClause != string.Empty) { query.Append(" ORDER BY "); query.Append(sortClause); } // // Render final semicolon // query.Append(";"); database = DatabaseFactory.CreateDatabase(); dbCommand = database.GetSqlStringCommand(query.ToString()); #if DEBUG try { r = database.ExecuteReader(dbCommand); } catch (Exception e) { string msg = e.Message; throw(new Exception(msg + " --- Query: " + query.ToString())); } #else r = database.ExecuteReader(dbCommand); #endif dbContentCommentCollection = new DbContentCommentCollection(); while (r.Read()) { DbContentComment dbContentComment = ParseFromReader(r, 0, 1); dbContentCommentCollection.Add(dbContentComment); } return(dbContentCommentCollection); }