/// <summary> /// Inserts the first and only row of this table. Bascially its set's the rowCOunt to 0. /// <para/> /// SQL query Example: <para/> /// insert into table1Count (rowCount) values (0); /// </summary> /// <param name="tableName">The name of the table.</param> /// <returns>The finished sql string.</returns> private string InsertStartValueTriggerTable(string tableName) { SQLQueryBuilder sqb = new SQLQueryBuilder(); string param = sqb.AddValue("id").Comma().AddValue("rowCount").Flush(); sqb.Insert().Or().Ignore().Into().AddValue(tableName + "_count").Brackets(param).Values().Brackets("1, 0"); return(sqb.ToString()); }