/// <summary>
/// Inserts the given object and retrieves its
/// auto incremented primary key if it has one.
/// </summary>
/// <param name="obj">
/// The object to insert.
/// </param>
/// <param name="extra">
/// Literal SQL code that gets placed into the command. INSERT {extra} INTO ...
/// </param>
/// <param name="objType">
/// The type of object to insert.
/// </param>
/// <returns>
/// The number of rows added to the table.
/// </returns>
public int Insert(object obj, string extra, Type objType)
{
if (obj == null || objType == null)
{
return(0);
}
var map = GetMapping(objType);
var replacing = string.Compare(extra, "OR REPLACE", StringComparison.OrdinalIgnoreCase) == 0;
var cols = replacing ? map.InsertOrReplaceColumns : map.InsertColumns;
var vals = new object[cols.Length];
for (var i = 0; i < vals.Length; i++)
{
vals [i] = cols [i].GetValue(obj);
}
var insertCmd = map.GetInsertCommand(this, extra);
var count = insertCmd.ExecuteNonQuery(vals);
if (map.HasAutoIncPK)
{
var id = SQLite3.LastInsertRowid(Handle);
map.SetAutoIncPK(obj, id);
}
return(count);
}
