PreparedSqlLiteInsertCommand CreateInsertCommand(SQLiteConnection conn, string extra)
{
var cols = InsertColumns;
string insertSql;
if (!cols.Any() && Columns.Count() == 1 && Columns[0].IsAutoInc)
{
insertSql = string.Format("insert {1} into \"{0}\" default values", TableName, extra);
}
else
{
var replacing = string.Compare(extra, "OR REPLACE", StringComparison.OrdinalIgnoreCase) == 0;
if (replacing)
{
cols = InsertOrReplaceColumns;
}
insertSql = string.Format("insert {3} into \"{0}\"({1}) values ({2})", TableName, string.Join(",", (from c in cols select "\"" + c.Name + "\"").ToArray()), string.Join(",", (from c in cols select "?").ToArray()), extra);
}
var insertCommand = new PreparedSqlLiteInsertCommand(conn);
insertCommand.CommandText = insertSql;
return(insertCommand);
}
protected internal void Dispose()
{
if (_insertCommand != null)
{
_insertCommand.Dispose();
_insertCommand = null;
}
}
public PreparedSqlLiteInsertCommand GetInsertCommand(SQLiteConnection conn, string extra)
{
if (_insertCommand == null)
{
_insertCommand = CreateInsertCommand(conn, extra);
_insertCommandExtra = extra;
}
else if (_insertCommandExtra != extra)
{
_insertCommand.Dispose();
_insertCommand = CreateInsertCommand(conn, extra);
_insertCommandExtra = extra;
}
return(_insertCommand);
}