public virtual string InsertQuery(InsertQuery query) { StringBuilder str = new StringBuilder(); str.Append(query.replace ? "REPLACE" : "INSERT"); str.Append(" "); str.Append(ModifiersQueryPart(query, true, !query.replace)); str.Append("\n"); str.Append("INTO "); str.Append(query.table); str.Append("\n"); str.AppendFormat("({0})", query.columns.ToString()); str.Append("\n"); str.Append("VALUES "); str.AppendFormat("({0})", query.values.ToString()); str.Append("\n"); return str.ToString(); }
/// <summary> /// Insert the given serializable object into the DB. /// </summary> /// <typeparam name="T"></typeparam> /// <param name="obj"></param> /// <returns>The number of rows affected</returns> public Task <NonQueryResult> Insert <T>(T obj) { InsertQuery <T> query = new InsertQuery <T>(Builder, obj); return(ExecuteNonQuery(query)); }