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));
}
